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 inMOUNT
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
- Open the navigation menu. Select Oracle Database, then select Oracle Base Database.
- Choose your Compartment. A list of DB systems is displayed.
- In the list of DB systems, click the name of the DB system with the failed database you want to reinstate.
- The details of the DB system followed by a list of databases are displayed.
- In the list of databases, click the name of the failed database.
- Under Resources, click Data Guard associations.
- For the Data Guard association on which you want to reinstate this database, click the Actions menu, and then click Reinstate.
- 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.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.