2 Replies Latest reply: May 5, 2013 3:30 AM by ora_tech RSS

    managed recovery in rac

    Ora_83
      Hi,

      Oracle 11.1.0.7.0 with rac.

      I want to check whether managed recovery is active or not.
      SQL> SELECT distinct(RECOVERY_MODE) from  V$ARCHIVE_DEST_STATUS;
      
      RECOVERY_MODE
      -----------------------
      IDLE
      According to above output, managed recovery is not active, however I am unable to start it. I presume it is already started.
      SQL> select open_mode from v$database;
      
      OPEN_MODE
      ----------
      MOUNTED
      
      
      alter database recover managed standby database using current logfile disconnect;
      
      
      MRP0: Some datafile enqueues are still held! Retry recovery...
      Errors in file /opt/oracle/diag/rdbms/orcl_kap/orcl1/trace/orcl1_mrp0_15198.trc:
      ORA-01124: cannot recover data file 1 - file is in use or recovery
      ORA-01110: data file 1: '+FAST_01/orcl_kap/datafile/system.451.719248277'
      Managed Standby Recovery not using Real Time Apply
      Errors in file /opt/oracle/diag/rdbms/orcl_kap/orcl1/trace/orcl1_mrp0_15198.trc:
      ORA-01124: cannot recover data file 1 - file is in use or recovery
      ORA-01110: data file 1: '+FAST_01/orcl_kap/datafile/system.451.719248277'
      SQL> select inst_id,process,pid,status,thread#,sequence#, block# from gv$managed_standby where process like 'MRP%';
      
         INST_ID PROCESS          PID STATUS          THREAD#  SEQUENCE#     BLOCK#
      ---------- --------- ---------- ------------ ---------- ---------- ----------
               4 MRP0            2578 APPLYING_LOG          3      55976          1
      When I connect 4rd instance, I am having the same output.

      SQL> SELECT distinct(RECOVERY_MODE) from  V$ARCHIVE_DEST_STATUS;
      
      RECOVERY_MODE
      -----------------------
      IDLE
      Why does recovery mode always show idle ? (although it is in managed recovery mode)
        • 1. Re: managed recovery in rac
          Osama_Mustafa
          Error: ORA 1124
          Text: cannot recover online file <name> - file is in use or recovery
          -------------------------------------------------------------------------------
          Cause: An attempt to do media recover found that the file was not available for recovery.
          Either it is online and the database is open in some instance, or another process is currently doing media recovery on the file.
          Action: Do not do media recovery.
          • 2. Re: managed recovery in rac
            ora_tech
            Hi,

            Refer MOS tech notes:

            *Ora-01124: Cannot Recover Data - File Is In Use Or Recovery [ID 1355591.1]*
            *MPP: (RDBMS) ORA-1124 ORA-283 ORA-1110 ON RECOVERY [ID 1031379.6]*

            thanks,
            X A H E E R