Oracle 12c DG备库Alert报错ORA-01110

发布时间:2020-04-08 04:18:24 作者:yangjunfeng
来源:网络 阅读:2027

环境是12.2.0.1 version, Oracle Data Guard备库今天故障恢复了一下,RMAN恢复后发现备库Alert一直报错,但是备库主库同步一致,数据一致。
2018-07-05T23:42:22.184048+08:00
Errors in file /u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:
ORA-01110: data file 7: '/u01/app/oracle/oradata/dwjrstdydb/users01.dbf'
2018-07-05T23:42:22.258112+08:00
Errors in file /u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:
ORA-01110: data file 8: '/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/system01.dbf'
2018-07-05T23:42:22.332476+08:00
Errors in file /u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:
ORA-01110: data file 9: '/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/sysaux01.dbf'
2018-07-05T23:42:22.406769+08:00
Errors in file /u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:
ORA-01110: data file 10: '/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/undotbs01.dbf'
2018-07-05T23:42:22.481081+08:00
Errors in file /u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:
ORA-01110: data file 11: '/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/users01.dbf'

参考MOS文档:
ORA-01110 For All Files In Standby Database (文档 ID 2322290.1)

CHANGES
New or Upgraded Standby on 12.2.0.1

CAUSE

Unpublished Bug 24844841 : PHSB:CDB M000 REPORTED ORA-1110 ON ADG WHEN A DATAFILE IS ADDED ON PRIMARY

is logged for error ORA-1110 being reported incorrectly on the Standby database alert log when a datafile change is made on the primary.

The bug is fixed in 19.1.

Backport requests can be made for 12.1 & 12.2

Rediscovery:

=========

Function kcidr_file_header_check_common is File Header check which cause of this issue. If you see this in the Stack Trace and Standby opens Read only successfully then you are most likely encountering this bug.

SOLUTION
To Solve the issue:

Apply fix of Bug 24844841. Please check for backports for your version and operating system.

If patch#24844841 is not available then please open an SR to request.

To Workaround:

Restart  the standby database and managed recovery.

特此记录一下,好记性不如烂笔头~

推荐阅读:
  1. Oracle 12C Rac到Rac搭建ADG
  2. Oracle 12C 利用Rman Duplicate搭建 Data Guard

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

ora 01110 报错

上一篇:win10修改mac地址

下一篇:chef 平台的搭建

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》