Oracle Archive Block Size
How to Check Archive Block Size ? To monitor the applying performance of a standby database, we usually make a query on V$MANAGED_STANDBY like this:… Read More »Oracle Archive Block Size
Managed Recovery Process (MRP)
How to Resolve ORA-45909: restore, recover or block media recovery may be in progress
ORA-45909 Tried to restore a data file by RMAN, it failed with ORA-45909, ORA-19890 and ORA-19573. RMAN> restore datafile 13; ... ORA-19870: error while restoring… Read More »How to Resolve ORA-45909: restore, recover or block media recovery may be in progress
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?
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 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
How to Resolve ORA-01579 in MRP
ORA-01579 in MRP After shrinking (i.e. resizing) a data file successfully, I was worry about the applying state of the standby database. Not surprisingly, I… Read More »How to Resolve ORA-01579 in MRP
How to Resolve Standby ORA-00600 [3020]
ORA-00600 [3020] Found MRP shutdown with ORA-00600 [3020] 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 [3020]
How to Resolve ORA-01153 an incompatible media recovery is active
ORA-01153 Got an error ORA-01153 like this: SQL> recover standby database until cancel; ORA-01153: an incompatible media recovery is active Let's see the content of… Read More »How to Resolve ORA-01153 an incompatible media recovery is active
How to Resolve ORA-19573: cannot obtain exclusive enqueue for datafile 1
ORA-19573 It's pretty easy to reproduce ORA-19573 because the solution is pretty easy, too. In this post, I will show you two run blocks on… Read More »How to Resolve ORA-19573: cannot obtain exclusive enqueue for datafile 1
Converting Standby Database to Snapshot (2/4) - Convert Manually
Converting Standby Database to Snapshot (1/4) - Convert by Broker We have demonstrated how to convert a physical standby database to a snapshot standby by… Read More »Converting Standby Database to Snapshot (2/4) - Convert Manually