再次踩到搜遍全网也找不到解药的坑ORA-49204之解决方案

导读

作者：杨漆
16年关系型数据库管理，从oracle 9i 、10g、11g、12c到Mysql5.5、5.6、5.7、8.0 到TiDB获得3个OCP、2个OCM；运维路上不平坦，跌过不少坑、熬过许多夜。把工作笔记整理出来分享给大伙儿，希望帮到大家少走弯路、少熬夜。

最近总是踩到搜遍全网都也找不到解决方案，仅原厂才有解药的坑里
Dg告警日志中大量出现Error
2021-07-13T17:00:23.984655+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcldg3/orcl/trace/orcl_m000_9167.trc:
ORA-01110: 数据文件 155: ‘/u01/oradata/datafile/efsw_dat.980.1072178937’
2021-07-13T17:00:24.077126+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcldg3/orcl/trace/orcl_m000_9167.trc:
ORA-01110: 数据文件 156: ‘/u01/oradata/datafile/efsw_dat.982.1072179003’
2021-07-13T17:00:24.168845+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcldg3/orcl/trace/orcl_m000_9167.trc:
ORA-01110: 数据文件 157: ‘/u01/oradata/datafile/efsw_dat.979.1072179087’
2021-07-13T17:00:24.261303+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcldg3/orcl/trace/orcl_m000_9167.trc:
ORA-01110: 数据文件 158: ‘/u01/oradata/datafile/loan_dat.978.1072179227’
2021-07-13T17:00:24.353301+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcldg3/orcl/trace/orcl_m000_9167.trc:
ORA-01110: 数据文件 159: ‘/u01/oradata/datafile/loan_index.977.1072179343’
2021-07-13T17:00:24.448821+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcldg3/orcl/trace/orcl_m000_9167.trc:
ORA-01110: 数据文件 160: ‘/u01/oradata/datafile/efs_dat.976.1072179459’
Errors in file /u01/app/oracle/diag/rdbms/orcldg3/orcl/trace/orcl_tt00_8566.trc:
ORA-00314: 日志 16 (用于线程 1) 要求的 sequence# 291926 与 291553 不匹配
ORA-00312: 联机日志 16 线程 1: ‘/u01/oradata/onlinelogstb1_redo16.log’
2021-07-13T17:15:09.529144+08:00
Errors in file