Oracle 12c DG备库Alert报错ORA-01110
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'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.
<wiz_tmp_tag id="wiz-table-range-border" contenteditable="false" style="display: none;">
最新文章
- String 字符串
- Linux SHELL 命令入门题目答案（一）
- Android中后台的劳动者“服务”
- Chrome 控制台使用大全
- Linux系统启动过程分析
- Android 常用时间格式转换代码
- Java API —— 递归
- MySQL 5.7 for Windows 解压缩版 MySQL 服务无法启动
- 2、使用Struts2实现登录功能（没有连接数据）
- kali高速更新源以及主题修改方法
- GPS校时器,GPS时钟装置,NTP网络时间服务器
- UNIX网络编程——进程间通信概述
- 单片机C语言基础编程源码六则
- c#数据库事务锁类型
- golang操作memcached 转自https://blog.csdn.net/weixin_37696997/article/details/78760397
- django部署笔记
- RESTful框架简述
- putty加了密钥ssh不能登陆，PuTTY:server refused our key问题的解决(转)
- 正则表达式（Swift）
- leetCode之二叉树数中序遍历（递归实现）