2 Replies Latest reply on Jan 20, 2013 6:04 PM by nhidba

    Problem in switchover to physical standby database

      Hi All,

      I am doing switchover from primary to physical standby database. Physical standby is in 'managed recovery' mode using real time apply and is in mount mode. I executed alter database commit to switchover to physical standby with session shutdown command. Now i am waiting for standby mrp to exit after processing eor record, but it seems mrp was hanged.

      Below is the content from standby database:

      Recovery of Online Redo Log: Thread 1 Group 5 Seq 620 Reading mem 0
      Mem# 0: /oracle/app/oracle/dbrac/th1-redo5a.log
      Resetting standby activation ID 749049115 (0x2ca5951b)
      Media Recovery End-Of-Redo indicator encountered
      Media Recovery Continuing
      Media Recovery Waiting for thread 1 sequence 621
      Archived Log entry 14 added for thread 1 sequence 620 ID 0x2ca5951b dest 1:

      Need some help to resolve.