Drop Standby Redo Log, How and Why?
Apply Lag Increasing After initiating data guard service by broker, we saw something unusual about redo applying. DGMGRL> show database ORCLSTB Database - ORCLSTB … Read More »Drop Standby Redo Log, How and Why?
Data Guard
How to Resolve ORA-16606: unable to find property
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-16606: unable to find property
How to Resolve ORA-16857: member disconnected from redo source for longer than specified threshold
Solution Found error ORA-16857 when I checked the data guard status of data synchronization. DGMGRL> show database ORCLSTB; Database - ORCLSTB Role: … Read More »How to Resolve ORA-16857: member disconnected from redo source for longer than specified threshold
How to Resolve ORA-16853: apply lag has exceeded specified threshold
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-16853: apply lag has exceeded specified threshold
How to Resolve ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
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-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
How to Resolve ORA-01156: recovery or flashback in progress may need access to files
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 to Resolve ORA-01156: recovery or flashback in progress may need access to files
How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup
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
How DGMGRL Switchover to Standby
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 DGMGRL Switchover to Standby
How to Configure Data Guard Broker 19c
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 to Configure Data Guard Broker 19c
How RMAN Duplicate 19c Standby Database
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 RMAN Duplicate 19c Standby Database