Standby : Unnamed file issue
2 min readSun 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)
