Oracle Cloud (DBaaS): Using dbaascli Utility for Reinstating Operations on Oracle Data Guard

    Sep 15, 2017 3:38:35 AM by Skant Gupta

    This article was written by Skant Gupta and Joel Perez in Oracle OTN.

    At the last part of this article we performed Switchover & Failover Operations on Oracle Data Guard using the dbaascli utility.

    You can read it here:

    Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard

    Now in this this article we will show the necessary steps to Reinstate using the dbaascli Utility

    After performing a failover to the standby database, you may be able to restore your original disaster-recovery solution by reinstating the failed primary database. You can use the Data Guard broker's reinstate capability to make the failed primary database a viable standby database for the new primary.

    Steps to Perform a Reinstating a Failed Primary Database using dbaascli utility

    You can use the dataguard reinstate subcommand of the dbaascli utility to reinstate a failed primary database after a failover.

    To determine whether the database can be reinstated, use the dataguard status subcommand as described in Checking the Status of the Oracle Data Guard Configuration.

    A status of ORA-16661: the standby database needs to be reinstated indicates the standby database can be reinstated.

    Let's Assume we come from this state:

     If you want to read rest to the article, go across this link : Using dbaascli Utility for Reinstating Operations on Oracle Data Guard

    Tags: Oracle Cloud DBaaS

    Skant Gupta

    Written by Skant Gupta

    Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. He is also Technical Writer on and with more than 30 article published in Oracle Technical Network.