Data Guard Broker

How to Resolve ORA-16606: unable to find property

by Ed Chen
February 7, 2022February 7, 2022

ORA-16606 Tried to show the property value of a database in data guard broker, but it failed with ORA-16606. DGMGRL> show database ORCLSTB LogApplyStatus Error:… Read More »

How to Resolve ORA-16853: apply lag has exceeded specified threshold

by Ed Chen
February 2, 2022March 8, 2022
2 Comments

ORA-16853 and ORA-16855 After resuming data guard through broker, we saw ORA-16853 and ORA-16855 when showing the status of standby database: in DGMGRL. DGMGRL> show… Read More »

How to Resolve ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set

by Ed Chen
January 28, 2022March 8, 2022

ORA-16698 Tried to add a physical standby to the broker configuration, but it failed with ORA-16698. DGMGRL> create configuration drconf as primary database is ORCLCDB… Read More »

How to Resolve ORA-01156: recovery or flashback in progress may need access to files

by Ed Chen
November 29, 2021December 2, 2021

ORA-01156 Tried to add a standby log file to a database, but it failed with ORA-01156. SQL> alter database add standby logfile thread 1 group… Read More »

How DGMGRL Switchover to Standby

by Ed Chen
August 28, 2019December 10, 2022

DGMGRL Switchover Suppose that you have configured data guard broker for 19c primary and standby databases, we can test switchover by DGMGRL, an interactive broker… Read More »

How to Configure Data Guard Broker 19c

by Ed Chen
August 15, 2019December 10, 2022

Suppose you have duplicated a 19c physical standby already, it's time to build the data guard relationship between the primary and standby databases. In this… Read More »

How Standby Change Apply Instance

by Ed Chen
November 11, 2012April 5, 2022

Apply Instance If you have not assign a preferred apply instance in the broker configuration in advance, the broker will choose one of running instances… Read More »