ORA-01111 name for data file is unknown

ORA-01111: name for data file is unknown

ORA-01110: data file

ORA-01276: Cannot add file

If you get those error on your Standby DB. Try following to solve this.

Resolving ORA-01111 ORA-01110 ORA-01276

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment. 

SQL> select process, status , sequence# from v$managed_standby;

SQL> select name from v$datafile;

...

...

/apps/oracle/product/data/kardbprd60.dbf

/apps/oracle/product/11.2.0.3/dbs/UNNAMED00071

SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='manual';

SQL> alter database create datafile '/apps/oracle/product/11.2.0.3/dbs/UNNAMED00071' as '/apps/oracle/product/data/kardbprd61.dbf';

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO scope=both;

alter database recover managed standby database using current logfile disconnect;

If the above command does not work, do as follow.

alter database create datafile '/apps/oracle/product/12.2.0.1/db_12c/dbs/UNNAMED00242' as '+DATAKARDBPRD/KARDBPRD/DATAFILE/data.341.1018723309';

alter database create datafile '/apps/oracle/product/12.2.0.1/db_12c/dbs/UNNAMED00242' as '+DATAKARDBPRD/KARDBPRD/DATAFILE/data.341.1018723309';

alter database create datafile '/apps/oracle/product/12.2.0.1/db_12c/dbs/UNNAMED00242' as '+DATAKARDBPRD/KARDBPRD/DATAFILE/data.341.1018723309'

*

ERROR at line 1:

ORA-01276: Cannot add file +DATAKARDBPRD/KARDBPRD/DATAFILE/data.341.1018723309.

File has an Oracle Managed Files file name.

SOLUTION:

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUEL;

alter database create datafile '/apps/oracle/product/12.2.0.1/db_12c/dbs/UNNAMED00242' as new;

show parameter standby_file_management;

alter system set standby_file_management=AUTO scope=both;

 show parameter standby_file_management;

 alter database recover managed standby database disconnect from session;