Oracle Database/Backup and Recovery Concepts

Describing the basics of database backup, restore, and recovery

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

Describing ways to tune instance recovery

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

Configuring ARCHIVELOG mode

Configuring a database for recoverability

Creating consistent database backups

Backing up your database without shutting it down

Creating incremental backups

Automating database backups

Monitoring the Flash Recovery area

Describing the difference between image copies and backup sets

Describing the different types of database backups

Backing up a control file to trace

Managing backups

Recovering from loss of a control file

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

Recovering from loss of a system-critical datafile

Recovering from loss of a non–system-critical datafile