1 、故障描述

       某次，在对某用户进行数据库深度检查时，发现归档磁盘存储空间剩余不足 10GB 。如果此时，归档磁盘被打爆，则将导致数据库运行报错甚至宕机，因此需要即刻对该问题进行详细诊断并处理。  2 、根因分析

对环境进行整体梳理后，情况为数据库归档磁盘存储剩余不足 10GB ，日均产生归档日志量达到 1 00G 左右，主库 RAC 集群对应的 ADG 备库 9 月份开始产生了 GAP 问题，问题表现如下：

a)  日均产生归档日志量达到 1 00G 左右

b)  主库 RAC 集群归档存储剩余空间不足 10GB

c)  主库 RAC 集群对应的 ADG 备库产生了 GAP 问题且时间较久

查看数据库产生归档日志量比较大数据库对象

查看备库有 GAP问题

  3 、解决方案

明确故障原因之后，接下来便是对 ADG进行同步修复操作，具体步骤参考如下：

a)  断开备库 ADG 的实时同步

b)  通过 rman 进入主库删除主库的归档日志释放存储空间

c)  重新部署备库 ADG 并实时应用

    Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 16 15:53:17 2023          Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.       connected to target database: XXXXXX (DBID=2290076166)     connected to auxiliary database: XXXXXX (not mounted)       RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16>     using target database control file instead of recovery catalog     allocated channel: c11     channel c11: SID=2710 instance=xxxxxx1 device type=DISK       allocated channel: c12     channel c12: SID=2933 instance=xxxxxx1 device type=DISK       allocated channel: c13     channel c13: SID=2081 instance=xxxxxx1 device type=DISK       allocated channel: c14     channel c14: SID=1707 instance=xxxxxx1 device type=DISK       allocated channel: c1     channel c1: SID=1153 device type=DISK       allocated channel: c2     channel c2: SID=1201 device type=DISK       allocated channel: c3     channel c3: SID=1249 device type=DISK       allocated channel: c4     channel c4: SID=1297 device type=DISK       Starting Duplicate Db at 16-NOV-23       contents of Memory Script:     {        backup as copy reuse        targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwrxxxxxx1' auxiliary format        '/export/home/oracle11/app/product/11.2.0/Db_1/dbs/orapwrxxxxxxdg';     }     executing Memory Script       Starting backup at 16-NOV-23     Finished backup at 16-NOV-23     input datafile copy RECID=43 STAMP=1153069415 file name=/Oradata/xxxxxxdg/datafile/ts_bas08.dbf     datafile 35 switched to datafile copy     input datafile copy RECID=44 STAMP=1153069415 file name=/Oradata/xxxxxxdg/datafile/ts_gis02.dbf     datafile 36 switched to datafile copy     input datafile copy RECID=45 STAMP=1153069415 file name=/Oradata/xxxxxxdg/datafile/ts_gis03.dbf     datafile 37 switched to datafile copy     input datafile copy RECID=46 STAMP=1153069415 file name=/Oradata/xxxxxxdg/datafile/ts_gis.309.1114946665     datafile 38 switched to datafile copy     input datafile copy RECID=47 STAMP=1153069415 file name=/Oradata/xxxxxxdg/datafile/ts_vect05.dbf     Finished Duplicate Db at 16-NOV-23       released channel: c1     released channel: c2     released channel: c3     released channel: c4     released channel: c11     released channel: c12     released channel: c13     released channel: c14       RMAN> Recovery Manager complete.       在进行相关步骤操作后，主备同步正常：              THREAD#  SEQUENCE# FIRST_CHANGE# NEXT_CHANGE# APPLIED     -------- --------- ------------- ------------ --------     1        16547     1.7785E+13    1.7785E+13   YES     2        17425     1.7785E+13    1.7785E+13   YES     1        16548     1.7785E+13    1.7785E+13   YES     2        17426     1.7785E+13    1.7785E+13   YES     ...