Wikibooks

Oracle Database/Backup and Recovery Concepts

< Oracle Database

Describing the basics of database backup, restore, and recovery

edit
This section is a stub.
You can help Wikibooks by expanding it.

Describing the types of failure that can occur in an Oracle database

edit

Describing ways to tune instance recovery

edit

Identifying the importance of checkpoints, redo log files, and archived log files

edit

Configuring ARCHIVELOG mode

edit

Configuring a database for recoverability

edit

Creating consistent database backups

edit

Backing up your database without shutting it down

edit

Creating incremental backups

edit

Automating database backups

edit

Monitoring the Flash Recovery area

edit

Describing the difference between image copies and backup sets

edit

Describing the different types of database backups

edit

Backing up a control file to trace

edit

Managing backups

edit

Recovering from loss of a control file

edit

Using RMAN (the Recovery Manager provided since Oracle 8):

If flash recovery area is configured and control file auto backup is on then: 

RMAN> connect target /
RMAN> startup nomount;
RMAN> restore controlfile from autobackup;

This will restore the control file to the location specified by the initialization parameter CONTROL_FILES mentioned in initialization parameter.

If flash recovery area is configured and control file auto backup is off then: 

RMAN> connect target /
RMAN> startup nomount;
RMAN> restore controlfile from 'C:\FRA\DBNAME\backupset\date_of_backup\backupset_name';

This will restore the control file to the location specified by the initialization parameter CONTROL_FILES mentioned in initialization parameter.

If restoration is being done using recovery catalog then: 

RMAN> connect target /
RMAN> connect catalog catalog_database_user/password@recovery_catalog_service;
RMAN> startup nomount;
RMAN> restore controlfile;

This will restore the control file to the location specified by the initialization parameter CONTROL_FILES mentioned in initialization parameter.

If no flash recovery area is configured, no recovery catalog is available and RMAN backup piece is available at default location then: 

RMAN> connect target /
RMAN> startup nomount;
RMAN> set dbid 1234567890;
RMAN> restore controlfile from autobackup;

Recovering from loss of a redo log file

edit

Recovering from loss of a system-critical datafile

edit

Recovering from loss of a non–system-critical datafile

edit
Retrieved from "https://en.wikibooks.org/w/index.php?title=Oracle_Database/Backup_and_Recovery_Concepts&oldid=3443446"