Oracle ADG，备库目录爆满，主库创建了新的数据文件，如何进行快速修复？

一、前言

备库在某中情况下，例如归档满，导致目录空间出现100%的使用率，此时adg同步滞后；恰好主库也新建了数据文件，这种情况下如何进行快速修复呢？
注意的是这种情况下，归档是没有丢失的，主备库均存在，也就是没有GAP。
这里就有同学问了，那出现gap了呢，有没有更方便的办法呢？
答案是有的，后续我会进行分享

二、问题复现

备库告警信息

2023-07-25T14:30:06.819949+08:00
 rfs (PID:20242): Standby controlfile consistent with primary

主库：

SQL> select count(*) from v$dbfile;

  COUNT(*)
----------
	26

备库：

SQL> select count(*) from v$dbfile;

  COUNT(*)
----------
	25

Note：以上可以看到备库的控制文件是少了一个主库的新建的数据文件，此时导致备库的控制文件信息跟主库不一致。

三、问题处理

这次模拟的环境为19c，自12c以来，adg的修复也就越来越来简单了，下面我们看看如何的简单法？

1、备库启动到nomount状态

shutdown immediate
startup nomount

2、恢复控制文件

[oracle@william ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 25 14:53:14 2023
Version 19.13.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: WLDB (not mounted)

RMAN> restore standby controlfile from service WLDB;

Starting restore at 25-JUL-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1137 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service WLDB
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output file name=/data/oradata/william/controlfile01.ctl
Finished restore at 25-JUL-23

RMAN> alter database mount;

released channel: ORA_DISK_1
Statement processed

RMAN> 

Note：可以看到利用tns从主库进行获取还原，非常的方便

3、恢复缺失的数据文件

RMAN> RESTORE DATAFILE 27 FROM SERVICE WLDB;

Starting restore at 25-JUL-23
Starting implicit crosscheck backup at 25-JUL-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=948 device type=DISK
Crosschecked 971 objects
Finished implicit crosscheck backup at 25-JUL-23

Starting implicit crosscheck copy at 25-JUL-23
using channel ORA_DISK_1
Finished implicit crosscheck copy at 25-JUL-23

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5169_lcyt21t7_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5170_lcyt24gx_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5171_lcyt3xts_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5172_lcyt3zjb_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4867_lcyt434n_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5173_lcyt43cd_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_5158_lcyt76f0_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4871_lcyt76pk_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4872_lcyt76pn_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5177_lcyt76pq_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4873_lcyt76pt_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5176_lcyt76pw_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5178_lcyt76pz_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5179_lcyt76vf_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4874_lcyt76yf_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5180_lcyt77dg_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_5159_lcyt78tw_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5181_lcyt78xm_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5182_lcyt79sp_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5664_lcyt79vr_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5183_lcyt7cw7_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5184_lcyt7cym_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4875_lcyt7pgd_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4876_lcyt7pgq_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4877_lcyt7pm2_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4878_lcyt7qdw_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4879_lcyt7qgz_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4880_lcyt7qhv_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4881_lcyt7r6k_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4882_lcyt7s19_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_4883_lcyt7srq_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5190_lcyt7svf_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_5160_lcytlkh1_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5665_lcytllx8_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5667_lcytst2l_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_5162_lcytsvtc_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_1_5668_lcytszmo_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_5163_lcytt1b9_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/archivelog/2023_07_25/o1_mf_2_5164_lcytzgsm_.arc
File Name: /data/oradata/fast_recovery_area/WILLIAM/autobackup/2022_01_07/o1_mf_s_1093356481_jxhp61y4_.bkp
File Name: /data/oradata/fast_recovery_area/WILLIAM/autobackup/2022_01_07/o1_mf_s_1093357387_jxhq2cv5_.bkp
File Name: /data/oradata/fast_recovery_area/WILLIAM/autobackup/2022_01_07/o1_mf_s_1093359738_jxhsdqhl_.bkp
File Name: /data/oradata/fast_recovery_area/WILLIAM/autobackup/2022_04_17/o1_mf_s_1102213822_k5p2wxxp_.bkp

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service wldb
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00027 to /data/oradata/WILLIAM/sysaux.309.1143121237
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
Finished restore at 25-JUL-23

RMAN> 

4、重新同步

edit database hipdg set state='apply-off';

edit database hipdg set state='apply-on';

DGMGRL> show configuration;

Configuration - williamadg

  Protection Mode: MaxAvailability
  Members:
  wldb   - Primary database
    william - Physical standby database 

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 18 seconds ago)

DGMGRL> 

Note：broker本身会自动同步，若没有同步，重新开启下

这里就有同学问了，那我11g的环境呢?
那当然就是手动的备份恢复方式啦，单独恢复备份控制文件，缺失的数据文件。