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)