ORA-01111: Name For Data File Is Unknown – Rename To Correct File

Today one of the Physical standby database environment faced an case where the Media Recovery MRP process got crashed and the standby database got out of sync. This post describes how to repair multiple or single-correct file of data files.

Mon Jul 28 10:26:04 2020
MRP0: Background Media Recovery terminated with error 1111
ORA-01157: cannot identify/lock data file 36 – see DBWR trace file
ORA-01111: name for data file 36 is unknown – rename to correct file
Managed Standby Recovery not using Real Time Apply
Recovery Slave PR00 previously exited with exception 1111

ORA-01111: name for data file 36 is unknown – rename to correct file This error basically indicates that the data file in standby mode cannot be created on the same location as the primary. If the path / mount point is not on hold, there could be several reasons.

Stand By

select * from v$recover_file where error like ‘%FILE%’;
select name from v$datafile where name like ‘%UNNAMED%’;

Primary

Select file#, name from v$datafile where file#=36;

Follow the steps below..

SQL> alter system set standby_file_management=’manual’;
SQL> show parameter standby_file_management;
SQL> alter database create datafile ‘/u01/app/ora/product/test/dbs/UNNAMED00036’ as ‘+DATAC1/test/datafile/’ size 1G;

ERROR at line 1:
ORA-01136: specified size of file 36 (1048576 blocks) is less than original
size of 1049088 blocks
ORA-01110: data file 36: ‘+DATAC1/tedasdg/datafile/’

Fix: db_block_size *  number of blocks reported in the error

SQL> alter database create datafile ‘/u01/app/ora/product/test/dbs/UNNAMED00036’ as ‘+DATAC1/test/datafile/standby36.dbf’ size 8292M;
Database altered.

alter system set standby_file_management=’AUTO’;

SQL> Alter database recover managed standby database disconnect from session;
Database altered.

MRP0: Background Managed Standby Recovery process started (TESTDG)
started logmerger process
Mon Jul 28 10:22:31 2020
Managed Standby Recovery not using Real Time Apply
Mon Jul 28 10:22:31 2020

Congrats have a nice day.

You can also look at the other post.