Oracle 12c DG备库Alert报错ORA-01110
admin
2023-04-18 22:04:07
0

环境是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.

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

相关内容

热门资讯

终于明白“蜀友汇怎么装挂?”(... 网上科普关于“蜀友汇有没有挂”话题很是火热,小编也是针对蜀友汇作*弊开挂的方法以及开挂对应的知识点,...
终于懂了“推大石辅助器?”(确... 您好:推大石这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9752949】很多玩家在这款游戏中...
今日重大通报“天涯麻将到底有挂... 您好:天涯麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款游戏...
玩家分享攻略“哈灵麻将有没有挂... 家人们!今天小编来为大家解答哈灵麻将透视挂怎么安装这个问题咨询软件客服徽4282891的挂在哪里买很...
今日重大通报“川麻圈可以开挂吗... 有 亲,根据资深记者爆料川麻圈是可以开挂的,确实有挂(咨询软件无需打开直...
今日重大消息“福建麻将有没有挂... 您好:福建麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款游戏...
【今日要闻】“经典联盟炸/金/... 有 亲,根据资深记者爆料经典联盟炸/金/花是可以开挂的,确实有挂(咨询软...
今日重大通报“微信链接牛牛真的... 家人们!今天小编来为大家解答微信链接牛牛透视挂怎么安装这个问题咨询软件客服徽9784099的挂在哪里...
今日重大消息“网易麻将究竟有挂... 有 亲,根据资深记者爆料网易麻将是可以开挂的,确实有挂(咨询软件无需打开...
今日重大发现“微乐锄大地辅助器... 家人们!今天小编来为大家解答微乐锄大地透视挂怎么安装这个问题咨询软件客服徽9752949的挂在哪里买...