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 »Recreate Standby Redo Logs, How and Why?
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
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
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 
Since ALTER SYSTEM ARCHIVE LOG CURRENT is a synchronized fashion of switching redo logs, it has to synchronize the archive log completely to all archive… Read More »ALTER SYSTEM ARCHIVE LOG CURRENT Hangs ?