![Previous Topic: Restore the Entire Database (Tablespaces and Control Files)](574.png)
![Next Topic: How to Perform a File-Level Recovery on Linux Nodes](573.png)
Restoring Protected Data › 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:
- 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.
- Log in to the restored computer.
- Open the command prompt and connect to the Oracle instance (for example ORCL) as sysdba.
- Verify the status of the Oracle instance.
SQL> SELECT STATUS FROM V$INSTANCE;
- 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;
- Recovery by executing the RECOVER command if database need media recovery
SQL> RECOVER DATABASE;
- Open the Oracle instance after the media recovery is complete.
SQL> ALTER DATABASE OPEN;
The Oracle database is recovered using the bare metal recovery.
Copyright © 2015 .
All rights reserved.
![Previous Topic: Restore the Entire Database (Tablespaces and Control Files)](574.png) ![Next Topic: How to Perform a File-Level Recovery on Linux Nodes](573.png)
|
|