$ 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进程。