ORA-01111

最新推荐文章于 2025-01-15 11:33:52 发布

原创最新推荐文章于 2025-01-15 11:33:52 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle添加数据文件 #oracle DG

oracle 专栏收录该内容

1 篇文章

订阅专栏

本文记录了一次Oracle备库出现数据文件未知错误及在线日志写入错误的问题，并详细描述了解决过程，包括设置文件名转换参数、手动管理备用文件及数据文件重命名等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

主库成功创建数据文件

备库报错：

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.