Using Arcserve UDP Agent (Windows) › Perform a Restore › How to Restore an Oracle Database › Recover the Oracle Database Using Bare Metal Recovery

Recover the Oracle Database Using Bare Metal Recovery

Bare metal recovery lets you recover and rebuild the entire computer system during a disaster. You can restore the original computer or you can restore another computer.

Follow these steps:

1. Restore the computer using one of the following methods:
   • If the recovery points are from an agent-based backup, perform a BMR to restore the computer.
   • If the recovery points are from a host-based agentless backup, then use Recover VM to restore the computer.
2. Log in to the restored computer.
3. Open the command prompt and connect to the Oracle instance (for example ORCL) as sysdba.
4. Verify the status of the Oracle instance.

   SQL> SELECT STATUS FROM V$INSTANCE;
   

5. Perform one of the following steps depending on the status of the Oracle instance:
   • If the status is Shutdown, then start and open the instance.

     SQL> STARTUP;
     

     SQL> ALTER DATABASE OPEN;
     

   • If the status is Nomount, then mount and open the instance.

     SQL> ALTER DATABASE MOUNT;
     

     SQL> ALTER DATABASE OPEN;
     

   • If the status is Mount, then open the Oracle instance.

     SQL> ALTER DATABASE OPEN;
     

6. Recovery by executing the RECOVER command if database need media recovery

   SQL> RECOVER DATABASE;
   

7. Open the Oracle instance after the media recovery is complete.

   SQL> ALTER DATABASE OPEN;
   

The Oracle database is recovered using the bare metal recovery.