6 Replies Latest reply: Oct 8, 2012 2:35 AM by Osama_Mustafa RSS

    Redo not getting shipped from primary to standby

    Atiq
      Hi All,

      I am receiving following error when trying to start MRP process in standby db. (Oracle 10g)

      Attempt to start background Managed Standby Recovery process (neonprd)
      MRP0 started with pid=31, OS id=5623962
      Mon Oct 8 09:12:10 2012
      MRP0: Background Managed Standby Recovery process started (neonprd)
      Managed Standby Recovery not using Real Time Apply
      parallel recovery setup failed: using serial mode
      Mon Oct 8 09:12:17 2012
      Waiting for all non-current ORLs to be archived...
      Mon Oct 8 09:12:17 2012
      Errors in file /oracle/admin/neonprd/bdump/neonprd_mrp0_5623962.trc:
      ORA-00367: checksum error in log file header
      ORA-00318: log 1 of thread 1, expected file size 512 doesn't match 512
      ORA-00312: online log 1 thread 1: '/oracle/redolog/neonprd/redo01a.log'
      Clearing online redo logfile 1 /oracle/redolog/neonprd/redo01a.log
      Clearing online log 1 of thread 1 sequence number 267655
      Mon Oct 8 09:12:17 2012
      Errors in file /oracle/admin/neonprd/bdump/neonprd_mrp0_5623962.trc:
      ORA-19527: physical standby redo log must be renamed
      ORA-00312: online log 1 thread 1: '/oracle/redolog/neonprd/redo01a.log'
      Clearing online redo logfile 1 complete
      Media Recovery Waiting for thread 1 sequence 268189
      Mon Oct 8 09:12:17 2012