Oracle Database/Backup and Recovery Concepts

Describing the basics of database backup, restore, and recoveryEdit

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

Describing ways to tune instance recoveryEdit

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

Configuring ARCHIVELOG modeEdit

Configuring a database for recoverabilityEdit

Creating consistent database backupsEdit

Backing up your database without shutting it downEdit

Creating incremental backupsEdit

Automating database backupsEdit

Monitoring the Flash Recovery areaEdit

Describing the difference between image copies and backup setsEdit

Describing the different types of database backupsEdit

Backing up a control file to traceEdit

Managing backupsEdit

Recovering from loss of a control fileEdit

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 fileEdit

Recovering from loss of a system-critical datafileEdit

Recovering from loss of a non–system-critical datafileEdit