Data Guard

How to Build Asymmetric Standby Database for Data Guard

Posted on
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 RAC to RAC. Practically, we could have downgraded standby servers in hardware specifications. For example, we may use 16 cores per instance on the primary side but use 8 cores […]
Data Guard

How to Resolve ORA-01579 in MRP

Posted on
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 found ORA-01579: write error occurred during recovery in Managed Recovery Process (MRP) log. oracle@boston>tail -f orcl_mrp0_23309410.trc … *** 2019-03-15 08:51:13.521 Media Recovery Log /oradata/ORCL/ARCH/ORCL_1_342376.arc *** 2019-03-15 09:02:01.230 Media Recovery Log […]
Data Guard

How to Resolve Standby ORA-00600 [3020]

Posted on
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 Nov 21 18:32:12 2018 Errors in file /oracle/admin/ORCL/bdump/orcl_mrp0_4589393.trc: ORA-00600: internal error code, arguments: [3020], [1786773511], [1], [37836], [320123], [72], [], [] ORA-10567: Redo is inconsistent with data block (file# 854, […]
RMAN

How to Resolve ORA-01153 an incompatible media recovery is active

Posted on
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 ORA-01153 Description ORA-01153: an incompatible media recovery is active Cause Attempted to start an incompatible media recovery or open resetlogs during media recovery or RMAN backup . Media recovery sessions […]