79927

Restoring and Recovering the Database

This section dcmonstrates how to restore and recover thc cntirc database using RMAN. This example assumes that you arc restoring and recovering your database after the loss of one or morę data files, but you still have a usablc scrver parameter file and control file. You can also use RMAN to restore a lost server parameter file or eon troi file.

To restore and recover the entire database:

1.    Connect RMAN to the target database as described in "Connccting to the Target Database" on page 9-9.

2.    Ensure that the database is mounted, but not open.

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

3.    Restore the database using the following co mm and:

RESTORE DATABASE;

The data files from thc RMAN backup are restored to their default locations.

4.    Rccover the database using the RECOVER command.

RECOVER DATABASE;

5.    Open the database using the following command:

ALTER DATABASE OPEN;