Performing Disaster Recovery › Scenarios for Restoring to the Original Windows Server › Recover the ORCL1 Database

Recover the ORCL1 Database

You must create an Oracle instance before you start the recovery procedure. Because you had the starter database (ORCL) when reinstalling Oracle, we recommend that you create the instance for ORCL1.

To recover ORCL1 database

1. Reinstall Windows.
2. Install Arcserve Backup if it was on the same server as your Oracle databases.
3. Do one of the following:
   • Reinstall Oracle
   • Restore all necessary sessions (files) from media (for example, sessions for Oracle executables, configuration files and registry information)
4. Reinstall the option, and create an Oracle database instance entry for each of the instances you intend to restore.
5. Restore the last full backup of ORCL1.

   Note: If it is an offline backup, then no further recovery is needed. Proceed to the section Recover the ORCL2 Database in this appendix. If it is an online backup, continue with the next step.

6. Check the INITORCL1.ORA file to see if it contains all the necessary settings for the following entries:

   LOG_ARCHIVE_START
   LOG_ARCHIVE_DEST
   LOG_ARCHIVE_FORMAT
   

7. Copy the restored control file (CONTROL.ORCL1) from the option home directory to all necessary directories and rename this file with the appropriate name.
8. Connect to ORCL1 as user SYS in Oracle Version 9i and above).
9. Mount the database.
10. Enter the following command at the SQL*Plus prompt:

    recover database using backup controlfile until cancel;
    

11. When the recovery has been completed, enter the following command:

    alter database open resetlogs;
    

    Note: If the database does not open and a message reports on the status of the redo logs, enter the following query at the Server Manager or SQL*Plus prompt:

    select * from v$logfile
    

    This query returns, among other information, the directory structure in which Oracle looks for the redo logs. If the directory structure does not exist, create it. When you have done so, enter the following command again:

    alter database open resetlogs;
    

    Oracle should open the database and recreate the redo logs.

    Important! The following step is very important. Do not omit it.

12. Delete all archive logs for ORCL1.

The ORCL1 database is now fully recovered. You can now proceed to the second phase, recovering the ORCL2 database.