Oracle 12c DG备库Alert报错ORA

Wesley13
• 阅读 712

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

点赞
收藏
评论区
推荐文章
blmius blmius
3年前
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
文章目录问题用navicat导入数据时,报错:原因这是因为当前的MySQL不支持datetime为0的情况。解决修改sql\mode:sql\mode:SQLMode定义了MySQL应支持的SQL语法、数据校验等,这样可以更容易地在不同的环境中使用MySQL。全局s
Jacquelyn38 Jacquelyn38
3年前
2020年前端实用代码段,为你的工作保驾护航
有空的时候,自己总结了几个代码段,在开发中也经常使用,谢谢。1、使用解构获取json数据let jsonData  id: 1,status: "OK",data: 'a', 'b';let  id, status, data: number   jsonData;console.log(id, status, number )
Wesley13 Wesley13
3年前
java中比较两个时间的差值
项目背景1.某篇文稿的发布时间是publishDate,例如:2020072118:00:41。2.现要求判断该篇文稿的发布时间是否在近30天之内。publicstaticlongdayDiff(DatecurrentDate,DatepublishDate){LongcurrentTimecurrentDat
Wesley13 Wesley13
3年前
RAC环境单实例启动数据库收到ORA
     在RAC环境中,如果你在没有启动节点的集群服务的情况下单实例启动数据库,将收到类似如下的报错:\oracle@rhel1u01\$sqlSQL\Plus:Release10.2.0.5.0ProductiononTueApr215:00:272013Copyright(
Stella981 Stella981
3年前
Django之Django模板
1、问:html页面从数据库中读出DateTimeField字段时,显示的时间格式和数据库中存放的格式不一致,比如数据库字段内容为2012082616:00:00,但是页面显示的却是Aug.26,2012,4p.m.答:为了页面和数据库中显示一致,需要在页面格式化时间,需要添加<td{{dayrecord.p\_time|date:
Stella981 Stella981
3年前
30分钟创建一个Oracle11g DataGuard物理备库的步骤
30分钟创建一个Oracle11gDataGuard物理备库的步骤:主库主机名:prmy备库主机名:sby1主库ip:192.168.1.1备库ip:192.168.1.2 主库dbname:prmy备库dbname:sby1主库db\_unique\_nameprmy备库db\_unique\_names
Wesley13 Wesley13
3年前
ORACLE DATAGUARD 日志传输状态监控
ORACLEDATAGUARD的主备库同步,主要是依靠日志传输到备库,备库应用日志或归档来实现。当主、备库间日志传输出现GAP,备库将不再与主库同步。因此需对日志传输状态进行监控,确保主、备库间日志没有GAP,或发现GAP后及时处理。除了在告警日志中查看日志同步情况外,还可以通过查看相关视图来对日志传输状态进行监控。1、主、备库查看当前日志状况
Stella981 Stella981
3年前
Android蓝牙连接汽车OBD设备
//设备连接public class BluetoothConnect implements Runnable {    private static final UUID CONNECT_UUID  UUID.fromString("0000110100001000800000805F9B34FB");
Wesley13 Wesley13
3年前
MySQL学习(三)主备分库分表和恢复数据
1、MySQL主备切换readonly设置对超级(super)权限是无效的,而用于同步更新的线程,就拥有超级权限。建议在做主备数据库的时候,将备用数据库设置为只读。(反向用readonly来判断节点的角色)主备的同步是通过binlog日志同步,流程:1)、备库上通过changemaster命令,设置主库的
Python进阶者 Python进阶者
11个月前
Excel中这日期老是出来00:00:00,怎么用Pandas把这个去除
大家好,我是皮皮。一、前言前几天在Python白银交流群【上海新年人】问了一个Pandas数据筛选的问题。问题如下:这日期老是出来00:00:00,怎么把这个去除。二、实现过程后来【论草莓如何成为冻干莓】给了一个思路和代码如下:pd.toexcel之前把这