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

DG 备库不能创建数据文件，出现ORA-01111错误，查看alter.log日志：

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

Attempt to start background Managed Standby Recovery process (ora)

Mon Dec 28 16:41:57 2015

MRP0 started with pid=28, OS id=21828 

MRP0: Background Managed Standby Recovery process started (ora)

 started logmerger process

Mon Dec 28 16:42:02 2015

Managed Standby Recovery starting Real Time Apply

MRP0: Background Media Recovery terminated with error 1111

Errors in file /opt/oracle/diag/rdbms/ora_st/ora/trace/ora_pr00_21830.trc:

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

ORA-01110: data file 6: '/opt/oracle/product/11.2.0/db_64/dbs/UNNAMED00006'

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

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

ORA-01110: data file 6: '/opt/oracle/product/11.2.0/db_64/dbs/UNNAMED00006'

Managed Standby Recovery not using Real Time Apply

Slave exiting with ORA-1111 exception

Errors in file /opt/oracle/diag/rdbms/ora_st/ora/trace/ora_pr00_21830.trc:

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

ORA-01110: data file 6: '/opt/oracle/product/11.2.0/db_64/dbs/UNNAMED00006'

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

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

ORA-01110: data file 6: '/opt/oracle/product/11.2.0/db_64/dbs/UNNAMED00006'

Recovery Slave PR00 previously exited with exception 1111

MRP0: Background Media Recovery process shutdown (ora)

Mon Dec 28 16:42:03 2015

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

解决：

SQL> show parameter standby

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

standby_archive_dest                 string      ?/dbs/arch

standby_file_management              string      AUTO

SQL> alter system set standby_file_management='MANUAL' scope=both;

System altered.

SQL> alter database create datafile '/opt/oracle/product/11.2.0/db_64/dbs/UNNAMED00006' as '/opt/oracle/oradata/ora/text.256.898447813';

Database altered.

SQL> alter system set standby_file_management='AUTO' scope=both;

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Database altered.