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

Recover the ORCL2 Database

You can recover the database using the following procedure.

To recover the ORCL2 database

1. Create an instance for the ORCL2 database and start the ORCL2 instance.
2. Make sure the INITORCL2.ORA file contains all the necessary configuration information, as described in Step 6 of the previous phase. Do one of the following:
   • Restore the latest backup copy of the INITORCL2.ORA file from media.
   • Recreate this file by using INITORCL1.ORA as your template and making all the necessary changes to it.
3. Restore the last full backup of ORCL2.

   Note: If it is an offline backup, then no further recovery is needed. You have now completed recovery of your Oracle server.

4. Copy the restored control file (CONTROL.ORCL2) from the option home directory to all necessary directories and rename it with the appropriate name.
5. Connect to the instance you started in Step 1 of this procedure.
6. To mount the ORCL2 database, enter the following command:

   startup mount pfile=DRIVE:\PATH\initORCL2.ora
   

7. Enter the following command at the SQL*Plus or Server Manager prompt:

   recover database using backup controlfile until cancel;
   

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

   alter database open resetlogs;
   

   If the database does not open and a message reports on the status of the redo logs, enter the following query at the SQL*Plus or Server Manager 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.

9. Delete all archive logs for ORCL2. The ORCL2 database is now fully recovered.
10. (Optional) You can recreate an instance for ORCL2 using the oradim utility. The syntax is:

    oradim -new -sid SID -srvc ServiceName -intpwd Password -startmode auto | manual -pfile FullPathToOracleInitSIDFile
    

11. (Optional) Create the password file if necessary, using the orapwdx.exe utility.