Reinstate a Database

This article provides the details and procedure to reinstate a database.

The reinstate moves a database into the standby role in an Oracle Data Guard association. You can use the reinstate command to return a failed database into service after correcting the cause of failure.

After you fail over a primary database to its standby, the standby assumes the primary role, and the old primary is identified as a disabled standby. After you correct the cause of failure, you can reinstate the failed database as a functioning standby for the current primary by using its Data Guard association.

Note:

Before you can reinstate a 12.2 database, you must perform some steps on the database host to stop the database or start it in MOUNT mode.

Set your ORACLE_UNQNAME environment variable to the value of the Database Unique Name (as seen in the Console), and then run these commands: 

srvctl stop database -d db-unique-name -o abort
srvctl start database -d db-unique-name -o mount

Procedure

Perform the following steps to reinstate a database using the OCI Console:

  1. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
  2. Select your Compartment. A list of DB systems is displayed.
  3. On the DB system list page, select the DB system with the current primary database from where we can reinstate the failed database. The DB system details page is displayed.
  4. On the DB system details page, select the current primary database.
  5. On the database details page, under Resources, select Data Guard associations.
  6. For the Data Guard association on which you want to reinstate this database, from the Actions menu, select Reinstate.
  7. In the Reinstate database panel, enter the database admin password, and then select Ok.

This database should now be reinstated as the standby in the Data Guard association.

Related Topics