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, […]