Restoring and Recovering the Database

This section demonstrates how to restore and recover the entire database using Oracle Recovery Manager (RMAN). This example assumes that you are restoring and recovering your database after the loss of one or more data files, but you still have a usable server parameter file and control file. You can also use RMAN to restore a lost server parameter file or control file.

To restore and recover the entire database:

Connect RMAN to the target database as described in "Connecting to the Target Database Using RMAN."
Ensure that the database is mounted, but not open.
```
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
```
Restore the database using the following command:
```
RESTORE DATABASE;
```
The data files from the RMAN backup are restored to their default locations.
Recover the database using the RECOVER command.
```
RECOVER DATABASE;
```
Open the database using the following command:
```
ALTER DATABASE OPEN;
```