RelationalDBDesign RelationalDBDesign


Backup Recovery   «Prev  Next»
Lesson 8 Perform database recovery with line command RMAN
Objective Use line command RMAN to recover a failed database.

Perform Database Recovery with Line Command RMAN

Recovering from failure

Backing up the database is the easy part. The real challenge begins when the "ORA-01113 file needs recovery" message flashes on your console.
Fortunately, using RMAN for recovery is as simple as backing up in the first place.
Just as only a few commands are required to back up the database, it takes only a few commands to restore it:

RMAN> RUN {
2> ALLOCATE CHANNEL T1 TYPE 'SBT_TAPE';
3> RESTORE DATABASE;
4> RECOVER DATABASE;
5> RELEASE CHANNEL T1;
6> }

To restore the database to its present location

Start RMAN and connect to the target database and recovery catalog database. For example, enter:

% RMAN CATALOG RMAN/RMAN@BACKUP

RMAN> CONNECT TARGET RMAN/RMAN@PETS

If the database is open, shut it down, and then mount it:
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;

After allocating the channels, restore the database:
RUN
{ 
ALLOCATE CHANNEL C1 TYPE DISK;
RESTORE DATABASE;
}

Once the database is restored, open the database.
The following simulation uses RMAN to recover a failed database.
Recovering Database Line Mode
The next lesson shows how to restore a tablespace, control file, and archived log files by using RMAN.