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

<<Back to Oracle DataGuard Main Page

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

SQL> recover standby database;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 16 is unknown - rename to correct file
ORA-01110: data file 16: '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016'
ORA-01157: cannot identify/lock data file 16 - see DBWR trace file
ORA-01111: name for data file 16 is unknown - rename to correct file
ORA-01110: data file 16: '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016'

Cause:
The datafile has been added in the standby as UNNAMED. This can happen if  standby_file_management parameter is set to manual or there is not enough space on standby to create the datafile.

Solution:
Add the unnamed datafile as below
SQL> select CON_ID,name from v$datafile where name like '%UNNAMED%';
CON_ID     NAME
--------------------------------------------------------------------------------
4                /u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016

SQL>  alter system set standby_file_management='manual';
System altered.
SQL> alter session set container=PDB01;

SQL> alter database create datafile '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016' as '+DG_TEST_DATA/' size 1G;
Database altered.
SQL> alter session set container=CDB$ROOT;
SQL>  alter system set standby_file_management='auto';
System altered.