ORA-01111: name for data file 33 is unknown – rename to correct file
ORA-01157: cannot identify/lock data file 33 – see DBWR trace file

====================
Primary Alert Log
===================

No Clue

==================
Standby Alert Log
==================
MRP0: Background Media Recovery terminated with error 1111
ORA-01111: name for data file 33 is unknown – rename to correct file
ORA-01110: data file 33: ‘E:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\UNNAMED00033’


Sympton:- MRP Process terminated and not starting up.

==========
Reason: A datafile has been added in primary but due to standby_file_management=manual parameter in standby its not added to controlfile automatically.
==========

=================
Troubleshooting
=================
1. select * from v$recover_file where error like ‘%FILE%’;
	FILE#  ONLINE  ONLINE_ ERROR                   CHANGE# TIME
	—— ——- ——- ——————– ———- ——————–
    	33 ONLINE  ONLINE  FILE MISSING                  0


2. Identify dummy file name created in (Standby)

	SQL> select file#,name from v$datafile where file#=33;
	FILE#  NAME
	—— ———————————————————————-
	33 E:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\UNNAMED00033

3. Crosscheck that no MRP is running and STANDBY_FILE_MANAGEMENT can be enabled once after creating file on standby

SQL> alter database create datafile ‘E:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\UNNAMED00033’ as ‘M:\UNDO\UNDOTBS02.DBF;

Database altered.

4. Set the standby_file_management=auto in standby immediately

5. alter database recover managed standby database disconnect from session using current logfile;