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

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Oracle 12c DG备库Alert报错ORA-01110，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2432字，纯文字阅读大概需要4分钟。

内容图文

环境是12.2.0.1 version, Oracle Data Guard备库近段时间一直报错，但是备库主库同步一致，数据一致。

2019-03-06T23:42:22.184048+08:00
Errors in file /u01/app/oracle/diag/rdbms/ccdb/ccdb/trace/ccdb_m000_129832.trc:
ORA-01110: data file 7: '/u01/app/oracle/oradata/ccdb/users01.dbf'
2019-03-06T23:42:22.258112+08:00
Errors in file /u01/app/oracle/diag/rdbms/ccdb/ccdb/trace/ccdb_m000_129832.trc:
ORA-01110: data file 8: '/u01/app/oracle/oradata/ccdb/system01.dbf'
2019-03-06T23:42:22.332476+08:00
Errors in file /u01/app/oracle/diag/rdbms/ccdb/ccdb/trace/ccdb_m000_129832.trc:
ORA-01110: data file 9: '/u01/app/oracle/oradata/ccdb/sysaux01.dbf'
2019-03-06T23:42:22.406769+08:00
Errors in file /u01/app/oracle/diag/rdbms/ccdb/ccdb/trace/ccdb_m000_129832.trc:
ORA-01110: data file 10: '/u01/app/oracle/oradata/ccdb/undotbs01.dbf'
2019-03-06T23:42:22.481081+08:00
Errors in file /u01/app/oracle/diag/rdbms/ccdb/ccdb/trace/ccdb_m000_129832.trc:
ORA-01110: data file 11: '/u01/app/oracle/oradata/ccdb/users01.dbf'

? ? ORA-01110 For All Files In Standby Database (文档 ID 2322290.1) ? ?

SYMPTOMS

On : 12.2.0.1 version, Oracle Data Guard

ORA-01110 for all files in Standby database show in Alert log after start managed recovery on new or upgraded 12.2.0.1 Standby database even though the Standby database can be opened Read Only successfully.

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.
 

来源： https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=327356201309662&id=2322290.1&_adf.ctrl-state=13j1gympwk_53

<wiz_tmp_tag id="wiz-table-range-border" contenteditable="false" style="display: none;">

? ? ? ?

来自为知笔记(Wiz)

内容总结

以上是互联网集市为您收集整理的Oracle 12c DG备库Alert报错ORA-01110全部内容，希望文章能够帮你解决Oracle 12c DG备库Alert报错ORA-01110所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---