Example: Restoring and Recovering an Entire Database With the Existing Current Control File

This example assumes that some or all the data files in the protected database are lost or damaged. However, the control file is available.

To restore and recover all the data files in a protected database:

Ensure that the prerequisites described in "Prerequisites for Restoring and Recovering Data from Recovery Appliance" are met.
Use RMAN to connect to the protected database as TARGET and the Recovery Appliance catalog as CATALOG.

See Also:

"Connecting to the Protected Database and Recovery Appliance Using CLI"

Restore and recover all the data files using the following command:

STARTUP MOUNT;
RUN 
{
  RESTORE DATABASE;
  RECOVER DATABASE;
  ALTER DATABASE OPEN;
}