POSSIBLE REASON
1.Mount Point of Production and Standby DB is not similar.
2.Standby standby_archive_dest set to manual instead of Auto.
3.db_file_name_convert is not set if the production Data mount point is different from standby one.
ERROR
MRP0: Background Managed Standby Recovery process started (orclsb)
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
Wed Mar 1 08:35:19 2017
Errors in file /u01/app/oracle/admin/orclsb/bdump/orclsb_mrp0_8563.trc:
ORA-01111: Message 1111 not found; No message file for product=RDBMS, facility=ORA; arguments: [432]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [432] [/u01/app/oracle/product/10.2/dbs/UNNAMED00432]
ORA-01157: Message 1157 not found; No message file for product=RDBMS, facility=ORA; arguments: [432]
ORA-01111: Message 1111 not found; No message file for product=RDBMS, facility=ORA; arguments: [432]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [432] [/u01/app/oracle/product/10.2/dbs/UNNAMED00432]
MRP0: Background Media Recovery process shutdown (orclsb)
Wed Mar 1 08:35:20 2017
Completed: alter database recover managed standby database disconnect from session
TROUBLESHOOTING
1.In my case , I have set the standby_archive_dest set to Manual instead of Auto.
SQL>show parameter standby
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
standby_file_management string MANUAL
2. Check for the files needs to be recovered.
SQL> select * from v$recover_file where error like '%FILE%';
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- ---------
432 ONLINE ONLINE FILE MISSING 0
3. check file 432 in Production
SQL> select name from V$datafile where file#=432;
NAME
-------------------------------------------------
/u18/oradata/orcl/data01/abc_data_83.dbf
4.Identify dummy file name created in (Standby)
SQL> select file#,name from v$datafile where file#=432;
FILE# NAME
---------- --------------------------------------------------
432 /u01/app/oracle/product/10.2/dbs/UNNAMED00432
5. Stop the MRP process if it is running and set standby_file_management to Manual.
SQL>alter database recover managed standby database cancel;
SQL>alter system set standby_file_management=Manual Scope=both;
6.Move UNNAMED00432 to its original location, like it is in Production.
SQL> alter database create datafile '/u01/app/oracle/product/10.2/dbs/UNNAMED00432' as '/u18/oradata/orcl/data01/abc_data_83.dbf';
Database altered.
NOTE:- FOR OMF managed file
ORA-01276: Cannot add file'dbs/UNNAMED00432'.File has an Oracle Managed Files file name.
Run Below command.
SQL> alter database create datafile '/u01/app/oracle/product/10.2/dbs/UNNAMED00432' as new;
7. Now enable the standby_file_management and start MRP.
SQL> alter system set standby_file_management=auto scope=both;
System altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
8.Check the Log
MRP0: Background Managed Standby Recovery process started (orclsb)
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 7 processes
Wed Mar 1 08:55:07 2017
Waiting for all non-current ORLs to be archived...
Media Recovery Log /u03/orarch/orclsb/standby/arch_1_10237_932005527.arc
Wed Mar 1 08:55:07 2017
Completed: alter database recover managed standby database disconnect from session
Wed Mar 1 08:55:10 2017
Media Recovery Log /u03/orarch/orclsb/standby/arch_1_10238_932005527.arc
Wed Mar 1 08:56:17 2017
Media Recovery Log /u03/orarch/orclsb/standby/arch_1_10239_932005527.arc
