ORA-01111 ORA-01110 ORA-01157 in a physical standby database

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

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

0 ·

CC 4.0 BY-SA版权

Oracle 同时被 3 个专栏收录

189 篇文章

订阅专栏

报错&告警

53 篇文章

订阅专栏

灾备

23 篇文章

订阅专栏

本文详细解析了在Oracle数据库中，主库添加数据文件后，导致从库同步中断及出现ORA-10879等错误的原因。通过调整standby_file_management参数，并正确创建数据文件，最终解决了主从数据库的同步问题。

在主库添加数据文件后，主从同步突然中断，从库alter日志出现以下报错：

ORA-10879: error signaled in parallel recovery slave
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 6 is unknown - rename to correct file
ORA-01110: data file 6: '/data/uat/oracle/12.1.0.2/test/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: '/data/uat/oracle/12.1.0.2/test/dbs/UNNAMED00006'
ksvp2penabled: ep->flg = 0, rpr->slv_flg = 0
ksvp2penabled: ep = 0x7f0883d231e8, rpr = 0x184be0730
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 6: '/data/uat/oracle/12.1.0.2/test/dbs/UNNAMED00006'
ORA-10458: standby database requires recovery
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: '/data/uat/oracle/12.1.0.2/test/dbs/UNNAMED00006'

报错原因：

查询文档发现是主库standby_file_management没设为AUTO，在添加数据文件后从库无法识别，就会导致上面的报错

解决方法：

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=manual;

ALTER DATABASE CREATE DATAFILE '/data/uat/oracle/12.1.0.2/test/dbs/UNNAMED00006' AS '/data/uat/oracle/12.1.0.2/test/dbs/test01.dbf';

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

参考：

How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database (文档 ID 1416554.1)

http://yunlongzheng.blog.51cto.com/blog/788996/1091944