Standby : Unnamed file issue

Sun Jan 1 22:02:11 2022
Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc:
ORA-01111: name for data file 185 is unknown - rename to correct file
ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185'
ORA-01157: cannot identify/lock data file 185 - see DBWR trace file
ORA-01111: name for data file 185 is unknown - rename to correct file
ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185'
Sun Jan 1 22:02:11 2022
Stopping change tracking
Sun Jan 1 22:02:11 2022
Recovery Slave PR00 previously exited with exception 1111
Sun Jan 1 22:02:11 2022
Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_mrp0_116791.trc:
ORA-01111: name for data file 185 is unknown - rename to correct file
ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185'
ORA-01157: cannot identify/lock data file 185 - see DBWR trace file
ORA-01111: name for data file 185 is unknown - rename to correct file
ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185'
Sun Jan 1 22:02:11 2022
Background Media Recovery process shutdown (proddb1)
Sun Jan 1 22:02:43 2022
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT
Sun Jan 1 22:02:43 2022
Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_mz00_117089.trc:
ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185'
ORA-01565: error in identifying file '/u01/oracle/product/19/db/dbs/UNNAMED00185'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

Troubleshoot Steps

The issue was reported on newly created standby where the standby_file_management=MANUAL and as a result MRP was stuck and not applying the logs.

To resolve the issue, We renamed the file(/u01/oracle/product/19/db/dbs/UNNAMED00185) and changed file standby_file_management=auto and re started the MRP.

Steps followed:

alter system set standby_file_management='manual' scope=both sid=''; 

alter database create datafile '/u01/oracle/product/19/db/dbs/UNNAMED00185' as '+DATA'; 

alter system set standby_file_management='auto' scope=both sid='';

alter database recover managed standby database disconnect from session;

Ref: MRP0: Background Media Recovery terminated with error 1119 (Doc ID 1397416.1)