MRP Fails W/ ORA-1579 'write Error Occurred During Recovery' (Doc ID 2134120.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 11.2.0.2.0 [Release 12.1 to 11.2]
Information in this document applies to any platform.

Symptoms

After enabling Big Table Cache feature on Active Data Guard via initialization parameter db_big_table_cache_percent_target, Managed Recovery intermittently fails with ORA-1579.

  Sat Mar 05 07:11:18 2016
  Media Recovery Log /u01/oracle/oradata/TARBS/TARBS_t1_s148227.arc
  Sat Mar 05 07:11:19 2016
  Slave exiting with ORA-1579 exception
  Sat Mar 05 07:11:19 2016
  Errors in file /u01/oracle/diag/rdbms/tarbs/TARBS/trace/TARBS_pr0b_12386652.trc:
  ORA-01579: write error occurred during recovery
  Sat Mar 05 07:11:19 2016
  Slave exiting with ORA-1579 exception
  Sat Mar 05 07:11:19 2016
  Errors in file /u01/oracle/diag/rdbms/tarbs/TARBS/trace/TARBS_pr03_23789888.trc:
  ORA-01579: write error occurred during recovery
  ....
  Sat Mar 05 07:11:20 2016
  Errors in file /u01/oracle/diag/rdbms/tarbs/TARBS/trace/TARBS_pr0h_55443570.trc:
  ORA-01579: write error occurred during recovery
  Recovery interrupted!
  Recovered data files to a consistent state at change 124131947580
  Sat Mar 05 07:11:20 2016
  Errors in file /u01/oracle/diag/rdbms/tarbs/TARBS/trace/TARBS_pr00_40632606.trc:
  ORA-00448: normal completion of background process
  Sat Mar 05 07:11:21 2016
  Errors in file /u01/oracle/diag/rdbms/tarbs/TARBS/trace/TARBS_mrp0_29884712.trc:
  ORA-01579: write error occurred during recovery
  Sat Mar 05 07:11:21 2016
  MRP0: Background Media Recovery process shutdown (TARBS)


Changes

Initialization parameter db_big_table_cache_percent_target was set to a value greater than 0 to enable Big Table Cache feature.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms