Oracle Database/Backup and Recovery Concepts

From Wikibooks, open books for an open world
Jump to navigation Jump to search

Describing the basics of database backup, restore, and recovery[edit | edit source]

 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 | edit source]

Describing ways to tune instance recovery[edit | edit source]

Identifying the importance of checkpoints, redo log files, and archived log files[edit | edit source]

Configuring ARCHIVELOG mode[edit | edit source]

Configuring a database for recoverability[edit | edit source]

Creating consistent database backups[edit | edit source]

Backing up your database without shutting it down[edit | edit source]

Creating incremental backups[edit | edit source]

Automating database backups[edit | edit source]

Monitoring the Flash Recovery area[edit | edit source]

Describing the difference between image copies and backup sets[edit | edit source]

Describing the different types of database backups[edit | edit source]

Backing up a control file to trace[edit | edit source]

Managing backups[edit | edit source]

Recovering from loss of a control file[edit | edit source]

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 | edit source]

Recovering from loss of a system-critical datafile[edit | edit source]

Recovering from loss of a non–system-critical datafile[edit | edit source]

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