Disaster Recovery Scenarios › Disaster Recovery Scenario

Disaster Recovery Scenario

Assume you have a Windows server running Oracle, and that there is one Oracle database instance on the server, ORCL. A disaster occurs and it is necessary to rebuild the entire server.

A typical disaster recovery scenario consists of the following steps:

1. Reinstall Windows.
2. Restore the offline backup of the Oracle data files, configuration files.
3. Restore the latest offline or online backup of ORCL.
4. Connect to ORCL as sysdba.
5. Mount the database.
6. Enter the following command at the SQL*Plus prompt:

   recover database using backup controlfile until cancel;
   

7. When the recovery process is complete, enter the following command:

   alter database open resetlogs;
   

   Oracle opens the database.