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?
Standby Redo Log
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 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 to Build Asymmetric Standby Database for Data Guard
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