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 on the current primary database from where we can reinstate the failed database using the OCI Console:

  1. On the DB Systems list page, select the DB system that contains the database that you want to work with. If you need help finding the list page or the DB system, see List the DB Systems.
  2. On the Databases tab, select the database that you want to work with.
  3. On the database details page, select the Data Guard associations tab.
  4. For the Data Guard association on which you want to reinstate this database, from the Actions menu, select Reinstate.
  5. 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