Oracle 12.2DG备库ORA-01110

最新推荐文章于 2023-06-13 16:25:24 发布

挠背小能手

最新推荐文章于 2023-06-13 16:25:24 发布

阅读量248

点赞数

文章标签： oracle 数据库 sql

本文链接：https://blog.csdn.net/m0_37625564/article/details/129691620

版权

$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 21 16:27:10 2023

Copyright (c) 1982, 2017, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
CDB       MOUNTED              PHYSICAL STANDBY

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
         0

PL/SQL Release 12.2.0.1.0 - Production
         0

CORE    12.2.0.1.0      Production
         0


BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
TNS for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production
         0

NLSRTL Version 12.2.0.1.0 - Production
         0

数据库版本Oracle 12.2.0.1.0，Oracle DataGuard主备数据同步正常。但是数据库alert日志频繁出现报错：

ORA-01110: data file 64: '/oradata/hisdb/ppms_idx01'
2023-03-21T16:28:47.441549+08:00
Errors in file /oracle/app/oracle/diag/rdbms/rzdps/cdb/trace/cdb_m000_38404624.trc:
ORA-01110: data file 65: '/oradata/hisdb/pts_data01'
2023-03-21T16:28:47.546314+08:00
Errors in file /oracle/app/oracle/diag/rdbms/rzdps/cdb/trace/cdb_m000_38404624.trc:
ORA-01110: data file 66: '/oradata/hisdb/pts_idx01'
2023-03-21T16:28:47.648157+08:00
Errors in file /oracle/app/oracle/diag/rdbms/rzdps/cdb/trace/cdb_m000_38404624.trc:
ORA-01110: data file 67: '/oradata/hisdb/pts_tp_outpregatime_data01'
2023-03-21T16:28:47.750015+08:00
Errors in file /oracle/app/oracle/diag/rdbms/rzdps/cdb/trace/cdb_m000_38404624.trc:
ORA-01110: data file 68: '/oradata/hisdb/pts_tp_outpregatime_idx01'
2023-03-21T16:28:47.856349+08:00
Errors in file /oracle/app/oracle/diag/rdbms/rzdps/cdb/trace/cdb_m000_38404624.trc:
ORA-01110: data file 69: '/oradata/hisdb/pts_tp_outpregdetail_data01'
2023-03-21T16:28:47.957142+08:00
Errors in file /oracle/app/oracle/diag/rdbms/rzdps/cdb/trace/cdb_m000_38404624.trc:
ORA-01110: data file 70: '/oradata/hisdb/pts_tp_outpregdetail_idx01'

参考MOS文档：ORA-01110 For All Files In Standby Database (Doc ID 2322290.1)
该问题是Oracle的Bug 24844841，即使备库数据正常同步或能正常打开，依旧会出现此报错，该bug在19.1版本中已修复。
处理方法：
按照操作系统类型选择下载补丁，重启MRP进程。