Symptoms: alart.log file: Wed Nov 02 15:35:48 2016 ALTER DATABASE RECOVER managed standby database disconnect using current logfile Attempt to start background Managed Standby Recovery process (STDB4_DG) Wed Nov 02 15:35:48 2016 MRP0 started with pid=43, OS id=27960 MRP0: Background Managed Standby Recovery process started (STDB4_DG) started logmerger process Wed Nov 02 15:35:53 2016 Managed Standby Recovery starting Real Time Apply MRP0: Background Media Recovery terminated with error 1111 Errors in file /opt/oracle/diag/rdbms/stdb4_dg/STDB4_DG/trace/STDB4_DG_pr00_28005.trc: ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' ORA-01157: cannot identify/lock data file 29 - see DBWR trace file ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' Managed Standby Recovery not using Real Time Apply Slave exiting with ORA-1111 exception Errors in file /opt/oracle/diag/rdbms/stdb4_dg/STDB4_DG/trace/STDB4_DG_pr00_28005.trc: ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' ORA-01157: cannot identify/lock data file 29 - see DBWR trace file ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' Recovery Slave PR00 previously exited with exception 1111 MRP0: Background Media Recovery process shutdown (STDB4_DG) Completed: ALTER DATABASE RECOVER managed standby database disconnect using current logfile Trace file: root@stagedb4 rdbms]# cat /opt/oracle/diag/rdbms/stdb4_dg/STDB4_DG/trace/STDB4_DG_pr00_28005.trc Trace file /opt/oracle/diag/rdbms/stdb4_dg/STDB4_DG/trace/STDB4_DG_pr00_28005.trc Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /opt/oracle/product/11.2.0.3 System name: Linux Node name: stagedb4.ipx.com Release: 2.6.18-406.el5 Version: #1 SMP Fri May 1 10:37:57 EDT 2015 Machine: x86_64 Instance name: STDB4_DG Redo thread mounted by this instance: 1 Oracle process number: 44 Unix process pid: 28005, image: oracle@stagedb4.ipx.com (PR00)
*** 2016-11-02 15:35:53.727 *** SESSION ID:(3022.7173) 2016-11-02 15:35:53.727 *** CLIENT ID:() 2016-11-02 15:35:53.727 *** SERVICE NAME:() 2016-11-02 15:35:53.727 *** MODULE NAME:() 2016-11-02 15:35:53.727 *** ACTION NAME:() 2016-11-02 15:35:53.727
Started Parallel Media Recovery *** 2016-11-02 15:35:53.746 4320 krsh.c Managed Standby Recovery starting Real Time Apply DDE rules only execution for: ORA 1110 ----- START Event Driven Actions Dump ---- ---- END Event Driven Actions Dump ---- ----- START DDE Actions Dump ----- Executing SYNC actions ----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) ----- Successfully dispatched ----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) ----- Executing ASYNC actions ----- END DDE Actions Dump (total 0 csec) ----- DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident) ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' ORA-01157: cannot identify/lock data file 29 - see DBWR trace file ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' *** 2016-11-02 15:35:53.856 4320 krsh.c MRP0: Background Media Recovery terminated with error 1111 ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' ORA-01157: cannot identify/lock data file 29 - see DBWR trace file ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' *** 2016-11-02 15:35:53.856 4320 krsh.c Managed Standby Recovery not using Real Time Apply
*** 2016-11-02 15:35:53.858 Completed Media Recovery Managed Recovery: Not Active posted. Slave exiting with ORA-1111 exception ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029' ORA-01157: cannot identify/lock data file 29 - see DBWR trace file ORA-01111: name for data file 29 is unknown - rename to correct file ORA-01110: data file 29: '/opt/oracle/product/11.2.0.3/dbs/UNNAMED00029'
Cause: This Error occurs if we add a Datafile OR Tablespace in PRIMARY Database and that could not be translated to the Standby Database due to these Reasons:
Alert Log in Standby Shows MRP
is terminated with below error By default it is AUTO by broker. Solution: For version < 12c -- In Standby SQL> select * from v$recover_file where
error like '%FILE%'; SQL> select name from v$datafile; NAME . . +DATA/db4_dg/datafile/ipx_large_data_2.295.882184319 +INDX/db4_dg/datafile/ipx_large_index_tmp.268.882190631
-- In Standby SQL> show parameter
file_name_convert
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO scope=both; Database altered.
Oracle Doc ID 739618.1 |