When I tried to open the standby database to READ ONLY for later real-time query of Active Data Guard (ADG), I got this error message.… Read More »How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup
Suppose that you have configured data guard broker for 19c primary and standby databases, we can test switchover by using the broker. The switchover operation… Read More »How to Switchover to Standby Database in 19c by DGMGRL
You don't have to create an empty database on the standby server for building a standby database. In this post, I will show you how… Read More »How to Duplicate a 19c Physical Standby Database
ORA-16571 ORA-16571 means that DGMGRL tried to create or save broker files on the destination you designed, but somehow it failed in DGMGRL command line… Read More »How to Resolve ORA-16571: Oracle Data Guard configuration file creation failure
Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or… Read More »How to Build Asymmetric Standby Database for Data Guard
We're going to introduce 3 ways that can failover to a standby database at connect-time in this post. Using a Persistent Service Name Using a… Read More »Connect-Time Failover to Standby Database
ORA-00600  Found MRP shutdown with ORA-00600  in alert log of a standby database due to inconsistency of a newly created data file. Wed… Read More »How to Resolve Standby ORA-00600 
At times, you may need to enable configuration or enable database to make the broker work again.$ dgmgrl /...DGMGRL> enable configuration;If you were waiting for… Read More »Are You Still Waiting for the Completion of "enable configuration"