Sunday, December 20, 2020

How to perform failover in Dataguard.

 If the primary database is not available then the standby database can be activated as a primary database using the following statements.


ALTER  DATABASE  RECOVER MANAGED STANDBY DATABASE  FINISH;

ALTER DATABASE ACTIVATE STANDBY DATABASE;

Since the standby database is now the primary database it should be backed up immediately.


No comments:

Post a Comment

Oracle Enterprise Manager Cloud Control 13c (OMS upgrade from 13.3 or 13.4 to OMS 13.5)

 OMS upgrade from 13.3 or 13.4 to OMS 13.5 PHASE -I Planning 1. OMS 13.5 is the latest Oracle Cloud Control version available. 2. To directl...