UNNAMED datafile - MRP was not running - Dataguard issue

MRP was not running and when I checked the alert log file of the Standby database, I could see the below UNNAMED00005 file errors.

This error basically states that the datafile on the standby wasn’t able to create on the particular location same as primary. 

There could be number of reasons for this if the path/mount point isn’t present on standby.

Serial Media Recovery started

MRP0 (PID:5008): Managed Standby Recovery starting Real Time Apply

MRP0 (PID:5008): MRP0: Background Media Recovery terminated with error 1111

2024-11-01T12:04:06.239241+05:30

Errors in file /u01/app/oracle/oracle_base/diag/rdbms/orcl/orcl/trace/orcl_mrp0_5008.trc:

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

MRP0 (PID:5008): Managed Standby Recovery not using Real Time Apply

Stopping change tracking

2024-11-01T12:04:06.290887+05:30

Errors in file /u01/app/oracle/oracle_base/diag/rdbms/orcl/orcl/trace/orcl_mrp0_5008.trc:

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

2024-11-01T12:04:06.290942+05:30

Background Media Recovery process shutdown (orcl)

2024-11-01T12:04:06.307938+05:30

Errors in file /u01/app/oracle/oracle_base/diag/rdbms/orcl/orcl/trace/orcl_mz00_5010.trc:

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

ORA-01565: error in identifying file '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 7

2024-11-01T12:04:07.219202+05:30

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT  NODELAY

2024-11-01T12:04:37.740818+05:30

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT  NODELAY

2024-11-01T12:04:37.741871+05:30

Attempt to start background Managed Standby Recovery process (orcl)

Starting background process MRP0

2024-11-01T12:04:37.768105+05:30

MRP0 started with pid=51, OS id=5026

2024-11-01T12:04:37.770190+05:30

Background Managed Standby Recovery process started (orcl)

2024-11-01T12:04:42.778108+05:30

Serial Media Recovery started

MRP0 (PID:5026): Managed Standby Recovery starting Real Time Apply

MRP0 (PID:5026): MRP0: Background Media Recovery terminated with error 1111

2024-11-01T12:04:42.802493+05:30

Errors in file /u01/app/oracle/oracle_base/diag/rdbms/orcl/orcl/trace/orcl_mrp0_5026.trc:

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

MRP0 (PID:5026): Managed Standby Recovery not using Real Time Apply

Stopping change tracking

2024-11-01T12:04:42.832995+05:30

Errors in file /u01/app/oracle/oracle_base/diag/rdbms/orcl/orcl/trace/orcl_mrp0_5026.trc:

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

2024-11-01T12:04:42.833075+05:30

Background Media Recovery process shutdown (orcl)

2024-11-01T12:04:43.357012+05:30

alter database recover managed standby database disconnect from session

2024-11-01T12:04:43.358628+05:30

Attempt to start background Managed Standby Recovery process (orcl)

Starting background process MRP0

2024-11-01T12:04:43.373674+05:30

MRP0 started with pid=51, OS id=5028

2024-11-01T12:04:43.374901+05:30

Background Managed Standby Recovery process started (orcl)

2024-11-01T12:04:48.381374+05:30

Serial Media Recovery started

MRP0 (PID:5028): Managed Standby Recovery starting Real Time Apply

MRP0 (PID:5028): MRP0: Background Media Recovery terminated with error 1111

2024-11-01T12:04:48.393635+05:30

Errors in file /u01/app/oracle/oracle_base/diag/rdbms/orcl/orcl/trace/orcl_mrp0_5028.trc:

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

MRP0 (PID:5028): Managed Standby Recovery not using Real Time Apply

Stopping change tracking

2024-11-01T12:04:48.419283+05:30

Errors in file /u01/app/oracle/oracle_base/diag/rdbms/orcl/orcl/trace/orcl_mrp0_5028.trc:

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005'

2024-11-01T12:04:48.419342+05:30

In order to fix that you can do the below steps:-

On standby:- connect to sqlplus and check the file details in question for which the error caused.(Same can be found in alert log)

col ERROR for a25
set lines 200
select * from v$recover_file where error like '%FILE%';

   On primary :- Get the correct file name for the datafile

SQL> select file#, name from v$datafile where file#=5;

On Standby DB steps to rename datafile with correct:

SQL> alter system set standby_file_management='MANUAL';
SQL> alter database create datafile '/u01/app/oracle/product/19.3/db_home/dbs/UNNAMED00005' as '/data1/ORCL/user_tablespace.dbf.dbf';
SQL> alter system set standby_file_management='AUTO';
SQL> alter database recover managed standby database disconnect from session;

No file required any recovery:-

SQL> select * from v$recover_file where error like '%FILE%';

no rows selected