Oracle Cloud Infrastructure Documentation

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

  1. Open the navigation menu. Select Oracle Database, then select Oracle Base Database Service.
  2. Select your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system with the failed database you want to reinstate.
  4. The details of the DB system followed by a list of databases are displayed.
  5. In the list of databases, click the name of the failed database.
  6. Under Resources, click Data Guard associations.
  7. For the Data Guard association on which you want to reinstate this database, click the Actions menu, and then click Reinstate.
  8. In the Reinstate database dialog box, enter the database admin password, and then click OK.

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