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"