ORA-01111

主库成功创建数据文件

备库报错：

Errors in file /u01/oracle/diag/rdbms/cqltback/cqlt/trace/cqlt_mrp0_7505.trc:

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

ORA-01110: data file 15: '/u01/oracle/product/11.2.0/db_1/dbs/UNNAMED00015'

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

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

ORA-01110: data file 15: '/u01/oracle/product/11.2.0/db_1/dbs/UNNAMED00015'

MRP0: Background Media Recovery process shutdown (cqlt)

'/u01/oracle/product/11.2.0/db_1/dbs/UNNAMED00015'

Mon May 30 12:44:03 2016

alter database rename file '/u01/oracle/product/11.2.0/db_1/dbs/UNNAMED00015' to '/u01/oracle/oradata/cqlt/ltjc03.dbf'

ORA-1511 signalled during: alter database rename file '/u01/oracle/product/11.2.0/db_1/dbs/UNNAMED00015' to '/u01/oracle/oradata/cqlt/ltjc03.dbf'...

Mon May 30 12:44:04 2016

Errors in file /u01/oracle/diag/rdbms/cqltback/cqlt/trace/cqlt_rfs_7434.trc:

ORA-00345: redo log write error block 16146 count 1

ORA-00312: online log 5 thread 1: ''

ORA-17611: ksfd: file '' cannot be accessed, global open closed

Errors in file /u01/oracle/diag/rdbms/cqltback/cqlt/trace/cqlt_rfs_7434.trc:

ORA-00345: redo log write error block 16146 count 1

ORA-00312: online log 5 thread 1: ''

ORA-17611: ksfd: file '' cannot be accessed, global open closed

Errors in file /u01/oracle/diag/rdbms/cqltback/cqlt/trace/cqlt_rfs_7434.trc:

ORA-00340: IO error processing online log 5 of thread 1

ORA-00345: redo log write error block 16146 count 1

ORA-00312: online log 5 thread 1: ''

ORA-17611: ksfd: file '' cannot be accessed, global open closed

Mon May 30 12:44:16 2016

原因：备库未设置convert 参数

ALTER SYSTEM SET db_file_name_convert='/u01/oracle/oradata/cqlt/','/u01/oracle/oradata/cqlt/' SCOPE=SPFILE;

解决办法：

ALTER SYSTEM SET db_file_name_convert='/u01/oracle/oradata/cqlt/','/u01/oracle/oradata/cqlt/' SCOPE=SPFILE;

关闭重启备库 

SQL>    alter system set STANDBY_FILE_MANAGEMENT='manual';

System altered.

SQL> alter database rename file '/u01/oracle/product/11.2.0/db_1/dbs/UNNAMED00015' to '/u01/oracle/oradata/cqlt/ltjc03.dbf'

  2  ;

Database altered.

SQL> alter system set STANDBY_FILE_MANAGEMENT='auto';

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel;

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

Database altered.

解决办法

SQL>  alter system set standby_file_management=manual;

System altered.

SQL>  alter database create datafile     ' /u01/oracle/oradata/cqlt/ ltjc05.dbf ' as '/u01/oracle/oradata/cqlt/ltjc05.dbf';

Database altered.

SQL>  alter system set standby_file_management=auto;

System altered.