Oracle 11G DataGuard GAP 修复过程（通过主库scn增备恢复）
Oracle 11G DataGuard GAP 修复 （通过主库scn增备恢复）
介绍
DG GAP 顾名思义就是：DG不同步，当备库不能接受到一个或多个主库的归档日志文件时候，就发生了 GAP。
那么，如果遇到GAP如何修复呢？
DG GAP 主要分为以下两类情况：
- 主库归档日志存在，可以通过配置 Fetch Archive Log(FAL) 参数，自动解决归档 GAP；
- 主库归档日志丢失，需要
人工干预来修复；
不同 Oracle 版本的 GAP 修复方式也不尽相同，下面分别介绍不同版本的方式！
11G 的处理步骤：
- 在主库上创建一个备库的控制文件
- 以备库的当前SCN号为起点，在主库上做一个增量备份
- 将增量备份拷贝到备库上
- 使用新的控制文件将备库启动到mount状态
- 将增量备份注册到RMAN的catalog，取消备库的恢复应用，恢复增量备份
- 开启备库的恢复进程
12C 的新特性（RECOVER … FROM SERVICE）
19C 的新特性（RECOVER STANDBY DATABASE FROM SERVICE）
Oracle随着版本的升级，逐渐将步骤缩减，进行封装，19C 之后可谓是达到了所谓的一键刷新，恢复DG同步。
11G DG GAP实战
环境准备
以下为测试环境信息：
| 角色 | 主机名 | IP地址 | 数据库版本 | 实例名 | DB名 | DB_UNIQUE名 | services名 | TNS名 | sys密码 |
|---|---|---|---|---|---|---|---|---|---|
| 主 | hfhsdb | 172.30.21.164 | 11.2.0.4 | hfhsdb | hfhsdb | hfhsdb | hfhsdb | hfhsdb | oracle |
| 备 | dghfhsdb | 172.30.21.165 | 11.2.0.4 | dghfhsdb | dghfhsdb | dghfhsdb | dghfhsdb | dghfhsdb | oracle |
模拟 GAP 发生
首先，模拟备库断电，主库切几个最新的归档，然后手工删掉，重新开启DG同步。
备库停止 DG 同步进程：
[oracle@dghfhsdb:/home/oracle]$lsnrctl stop #停止监听LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 28-NOV-2024 20:39:01Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.30.21.165)(PORT=1521)))
The command completed successfully
[oracle@dghfhsdb:/home/oracle]$sqlplus / as sysdba #连接数据库SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 20:39:22 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter database recover managed standby database cancel; #停止日志同步Database altered.SQL> shu immediate #关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
主库切换多次归档：
[oracle@hfhsdb:/home/oracle]$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 20:41:52 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter system switch logfile;System altered.SQL> /System altered.SQL> /System altered.SQL> alter system checkpoint;System altered.SQL> alter system checkpoint;System altered.SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 75
Next log sequence to archive 79
Current log sequence 79
SQL>
主库删除最近几个归档日志：
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$ll
total 164640
-rw-r----- 1 oracle oinstall 333312 Nov 28 19:50 o1_mf_1_72_mnjp7v3b_.arc
-rw-r----- 1 oracle oinstall 57344 Nov 28 19:50 o1_mf_1_73_mnjp83z1_.arc
-rw-r----- 1 oracle oinstall 5632 Nov 28 19:50 o1_mf_1_74_mnjp8dy2_.arc
-rw-r----- 1 oracle oinstall 166799872 Nov 28 20:20 o1_mf_1_75_mnjr0wcn_.arc
-rw-r----- 1 oracle oinstall 1376256 Nov 28 20:42 o1_mf_1_76_mnjs8sky_.arc
-rw-r----- 1 oracle oinstall 3584 Nov 28 20:42 o1_mf_1_77_mnjs8yxc_.arc
-rw-r----- 1 oracle oinstall 6144 Nov 28 20:42 o1_mf_1_78_mnjs989v_.arc
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$mv o1_mf_1_77_mnjs8yxc_.arc o1_mf_1_77_mnjs8yxc_.arc.bak
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$mv o1_mf_1_78_mnjs989v_.arc o1_mf_1_78_mnjs989v_.arc.bak
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$ll
total 164640
-rw-r----- 1 oracle oinstall 333312 Nov 28 19:50 o1_mf_1_72_mnjp7v3b_.arc
-rw-r----- 1 oracle oinstall 57344 Nov 28 19:50 o1_mf_1_73_mnjp83z1_.arc
-rw-r----- 1 oracle oinstall 5632 Nov 28 19:50 o1_mf_1_74_mnjp8dy2_.arc
-rw-r----- 1 oracle oinstall 166799872 Nov 28 20:20 o1_mf_1_75_mnjr0wcn_.arc
-rw-r----- 1 oracle oinstall 1376256 Nov 28 20:42 o1_mf_1_76_mnjs8sky_.arc
-rw-r----- 1 oracle oinstall 3584 Nov 28 20:42 o1_mf_1_77_mnjs8yxc_.arc.bak
-rw-r----- 1 oracle oinstall 6144 Nov 28 20:42 o1_mf_1_78_mnjs989v_.arc.bak
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$
备库开启同步进程：
[oracle@dghfhsdb:/home/oracle]$lsnrctl startLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 28-NOV-2024 20:45:57Copyright (c) 1991, 2013, Oracle. All rights reserved.Starting /oracle/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/dghfhsdb/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.30.21.165)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.30.21.165)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 28-NOV-2024 20:45:57
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/dghfhsdb/listener/alert/log.xml
Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.30.21.165)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "dghfhsdb" has 1 instance(s).Instance "dghfhsdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@dghfhsdb:/home/oracle]$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 20:46:04 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup
ORACLE instance started.Total System Global Area 3340451840 bytes
Fixed Size 2257840 bytes
Variable Size 687869008 bytes
Database Buffers 2634022912 bytes
Redo Buffers 16302080 bytes
Database mounted.
Database opened.
SQL> alter database recover managed standby database using current logfile disconnect from session;Database altered.SQL>
主库刷新 DEST 状态：
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 20:47:45 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter system set log_archive_dest_state_2=defer;System altered.SQL> alter system set log_archive_dest_state_2=enable;System altered.SQL> alter system switch logfile;System altered.SQL> alter system checkpoint;System altered.SQL>查看同步情况，是否存在 GAP：
-- 主库执行
set line 1000
col status for a10
col type for a10
col error for a20
col gap_status for a20
col synchronization_status for a30
col recovery_mode for a30
select inst_id,status,DEST_ID,TYPE,ERROR,GAP_STATUS,SYNCHRONIZED,SYNCHRONIZATION_STATUS,RECOVERY_MODE from GV$ARCHIVE_DEST_STATUS where STatus <> 'INACTIVE' and type = 'PHYSICAL';INST_ID STATUS DEST_ID TYPE ERROR GAP_STATUS SYN SYNCHRONIZATION_STATUS RECOVERY_MODE
---------- ---------- ---------- ---------- ---------- ---------------- --- -------------------------- ------------------------------1 VALID 2 PHYSICAL UNRESOLVABLE GAP NO CHECK CONFIGURATION MANAGED REAL TIME APPLY
-- 显示 UNRESOLVABLE GAP，意味着无法自行修复，需要人工干预-- 当前数据库 scn 号
SQL> col CURRENT_SCN for 999999999999999999
SQL> select current_scn from v$database;CURRENT_SCN
-------------------1707911-- 备库执行
SQL> col group# for a30
SQL> select process,thread#,group#,sequence#,status from gv$managed_standby;PROCESS THREAD# GROUP# SEQUENCE# STATUS
--------- ---------- ------------------------------ ---------- ------------
ARCH 0 N/A 0 CONNECTED
ARCH 0 N/A 0 CONNECTED
ARCH 1 6 80 CLOSING
ARCH 1 6 81 CLOSING
RFS 0 N/A 0 IDLE
RFS 0 N/A 0 IDLE
RFS 0 N/A 0 IDLE
RFS 1 2 82 IDLE
MRP0 1 N/A 77 WAIT_FOR_GAP9 rows selected.
SQL> select count(*) from gv$archived_log where applied='NO';COUNT(*)
----------3SQL> select * from v$archive_gap;THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------1 77 78SQL> col CURRENT_SCN for 999999999999999999
SQL> select current_scn from v$database;CURRENT_SCN
-------------------1707090确定主库是否添加数据文件：
SQL> select FILE#,name from v$datafile where CREATION_CHANGE#> =1707090;no rows selected
注意 当前 ADG 已存在 GAP，并且 GAP 期间主库没有增加数据文件，缺少日志号为 77,78，即是前面模拟断电删除的归档日志文件，已经确认无法找回，需要人工干预进行修复。
常规修复
主库根据备库 scn 号进行增量备份：
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 28 20:59:25 2024Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: HEFEIDB (DBID=955642886)RMAN> backup incremental from scn 1707090 database format '/backup/incre_%U';Starting backup at 2024-11-28 21:00:06
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1528 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oradata/hefeidb/itpux.dbf
input datafile file number=00001 name=/oradata/hefeidb/system01.dbf
input datafile file number=00002 name=/oradata/hefeidb/sysaux01.dbf
input datafile file number=00003 name=/oradata/hefeidb/undotbs01.dbf
input datafile file number=00004 name=/oradata/hefeidb/users01.dbf
input datafile file number=00006 name=/oradata/hefeidb/hsdb1.dbf
channel ORA_DISK_1: starting piece 1 at 2024-11-28 21:00:07
channel ORA_DISK_1: finished piece 1 at 2024-11-28 21:00:42
piece handle=/backup/incre_083b9q6n_1_1 tag=TAG20241128T210007 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 2024-11-28 21:00:44
channel ORA_DISK_1: finished piece 1 at 2024-11-28 21:00:45
piece handle=/backup/incre_093b9q7q_1_1 tag=TAG20241128T210007 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2024-11-28 21:00:45将增量备份拷贝至备库：
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$scp /backup/incre_0* 172.30.21.165:/backup/
The authenticity of host '172.30.21.165 (172.30.21.165)' can't be established.
ECDSA key fingerprint is SHA256:P1FitT4UKjwoEHe9vJfy/ioPdwoHhdUWAequhuUXvDU.
ECDSA key fingerprint is MD5:8f:6e:9a:0f:1b:1d:53:19:d6:a7:4a:70:51:79:ce:86.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.30.21.165' (ECDSA) to the list of known hosts.
oracle@172.30.21.165's password:
Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password).
lost connection
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$scp /backup/incre_0* 172.30.21.165:/backup/
oracle@172.30.21.165's password:
Permission denied, please try again.
oracle@172.30.21.165's password:
incre_083b9q6n_1_1 100% 504KB 18.9MB/s 00:00
incre_093b9q7q_1_1 100% 40MB 42.1MB/s 00:00
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$备库关闭 DG 同步进程，如果是 ADG 则需要重启数据库到 mount 状态：
[oracle@dghfhsdb:/home/oracle]$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 21:05:06 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter database recover managed standby database cancel;Database altered.SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.Total System Global Area 3340451840 bytes
Fixed Size 2257840 bytes
Variable Size 687869008 bytes
Database Buffers 2634022912 bytes
Redo Buffers 16302080 bytes
Database mounted.
备库 rman 注册增量备份文件：
[oracle@dghfhsdb:/home/oracle]$rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 28 21:06:43 2024Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: HEFEIDB (DBID=955642886, not open)RMAN> catalog start with '/backup/';using target database control file instead of recovery catalog
searching for all files that match the pattern /backup/List of Files Unknown to the Database
=====================================
File Name: /backup/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
File Name: /backup/pdksh-5.2.14-30.x86_64.rpm
File Name: /backup/itpux_table_v4.tar.gz
File Name: /backup/itpux_table_v4.0.dmp
File Name: /backup/itpux_table_v4.0.log
File Name: /backup/itpux_table.log4
File Name: /backup/incre_083b9q6n_1_1
File Name: /backup/incre_093b9q7q_1_1Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging doneList of Cataloged Files
=======================
File Name: /backup/incre_083b9q6n_1_1
File Name: /backup/incre_093b9q7q_1_1List of Files Which Where Not Cataloged
=======================================
File Name: /backup/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpmRMAN-07517: Reason: The file header is corrupted
File Name: /backup/pdksh-5.2.14-30.x86_64.rpmRMAN-07517: Reason: The file header is corrupted
File Name: /backup/itpux_table_v4.tar.gzRMAN-07517: Reason: The file header is corrupted
File Name: /backup/itpux_table_v4.0.dmpRMAN-07517: Reason: The file header is corrupted
File Name: /backup/itpux_table_v4.0.logRMAN-07517: Reason: The file header is corrupted
File Name: /backup/itpux_table.log4RMAN-07517: Reason: The file header is corruptedRMAN> list backup
2> ;List of Backup Sets
===================BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1 Incr 496.00K DISK 00:00:00 2024-11-28 21:00:07BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20241128T210007Piece Name: /backup/incre_083b9q6n_1_1List of Datafiles in backup set 1File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- ------------------- ----1 Incr 1708384 2024-11-28 21:00:07 /oradata/hefeidb/system01.dbf2 Incr 1708384 2024-11-28 21:00:07 /oradata/hefeidb/sysaux01.dbf3 Incr 1708384 2024-11-28 21:00:07 /oradata/hefeidb/undotbs01.dbf4 Incr 1708384 2024-11-28 21:00:07 /oradata/hefeidb/users01.dbf5 Incr 1708384 2024-11-28 21:00:07 /oradata/hefeidb/itpux.dbf6 Incr 1708384 2024-11-28 21:00:07 /oradata/hefeidb/fghsdb1.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Incr 40.02M DISK 00:00:00 2024-11-28 21:00:42BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20241128T210007Piece Name: /backup/incre_093b9q7q_1_1Control File Included: Ckp SCN: 1708569 Ckp time: 2024-11-28 21:00:42RMAN> recover database noredo;Starting recover at 2024-11-28 21:11:49
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=15 device type=DISK
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oradata/hefeidb/system01.dbf
destination for restore of datafile 00002: /oradata/hefeidb/sysaux01.dbf
destination for restore of datafile 00003: /oradata/hefeidb/undotbs01.dbf
destination for restore of datafile 00004: /oradata/hefeidb/users01.dbf
destination for restore of datafile 00005: /oradata/hefeidb/itpux.dbf
destination for restore of datafile 00006: /oradata/hefeidb/fghsdb1.dbf
channel ORA_DISK_1: reading from backup piece /backup/incre_083b9q6n_1_1
channel ORA_DISK_1: piece handle=/backup/incre_083b9q6n_1_1 tag=TAG20241128T210007
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01Finished recover at 2024-11-28 21:11:51在主库上创建一个备库的控制文件：
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 21:13:58 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter database create standby controlfile as '/backup/oradb_standby241128.ctl';Database altered.将生成的控制文件拷贝到备库：
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$scp /backup/oradb_standby241128.ctl 172.30.21.165:/backup
oracle@172.30.21.165's password:
oradb_standby241128.ctl 100% 40MB 54.0MB/s 00:00
[oracle@hfhsdb:/archive/HFHSDB/archivelog/2024_11_28]$
备库关闭数据库实例，开启至 nomount 状态：
[oracle@dghfhsdb:/backup]$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 21:15:46 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> shutdown immediate
ORA-01109: database not openDatabase dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.Total System Global Area 3340451840 bytes
Fixed Size 2257840 bytes
Variable Size 687869008 bytes
Database Buffers 2634022912 bytes
Redo Buffers 16302080 bytes
SQL>
备库恢复新的控制文件：
[oracle@dghfhsdb:/backup]$rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 28 21:17:09 2024Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: HEFEIDB (not mounted)RMAN> restore standby controlfile from '/backup/oradb_standby241128.ctl';Starting restore at 2024-11-28 21:17:22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1521 device type=DISKchannel ORA_DISK_1: copied control file copy
output file name=/oradata/hefeidb/control01.ctl
output file name=/oradata/hefeidb/control02.ctl
Finished restore at 2024-11-28 21:17:23RMAN>
备库开启到 mount 状态：
[oracle@dghfhsdb:/backup]$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 21:17:59 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter database mount;
Database altered.
-----------------------------------------------------------------------------------------------
## 如果主备库数据文件路径不一致，备库控制文件需要注册数据文件，如果一样，可以不操作
RMAN> catalog start with '/oradata/ORADBDG/datafile/';searching for all files that match the pattern /oradata/ORADBDG/datafile/List of Files Unknown to the Database
=====================================
File Name: /oradata/ORADBDG/datafile/o1_mf_system_kzrsshwr_.dbf
File Name: /oradata/ORADBDG/datafile/o1_mf_sysaux_kzrst97y_.dbf
File Name: /oradata/ORADBDG/datafile/o1_mf_undotbs1_kzrstrhg_.dbf
File Name: /oradata/ORADBDG/datafile/o1_mf_users_kzrstzhx_.dbf
File Name: /oradata/ORADBDG/datafile/o1_mf_temp_kzrsxdq5_.tmp
File Name: /oradata/ORADBDG/datafile/o1_mf_system_kzrt67q4_.dbfDo you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging doneList of Cataloged Files
=======================
File Name: /oradata/ORADBDG/datafile/o1_mf_system_kzrsshwr_.dbf
File Name: /oradata/ORADBDG/datafile/o1_mf_sysaux_kzrst97y_.dbf
File Name: /oradata/ORADBDG/datafile/o1_mf_undotbs1_kzrstrhg_.dbf
File Name: /oradata/ORADBDG/datafile/o1_mf_users_kzrstzhx_.dbf
File Name: /oradata/ORADBDG/datafile/o1_mf_temp_kzrsxdq5_.tmp
File Name: /oradata/ORADBDG/datafile/o1_mf_system_kzrt67q4_.dbfRMAN> switch database to copy;datafile 1 switched to datafile copy "/oradata/ORADBDG/datafile/o1_mf_system_kzrsshwr_.dbf"
datafile 3 switched to datafile copy "/oradata/ORADBDG/datafile/o1_mf_sysaux_kzrst97y_.dbf"
datafile 4 switched to datafile copy "/oradata/ORADBDG/datafile/o1_mf_undotbs1_kzrstrhg_.dbf"
datafile 5 switched to datafile copy "/oradata/ORADBDG/datafile/o1_mf_system_kzrt67q4_.dbf"
datafile 7 switched to datafile copy "/oradata/ORADBDG/datafile/o1_mf_users_kzrstzhx_.dbf"---------------------------------------------------------------------------------------
##路径如果一致的话，之间open数据库SQL> alter database open;Database altered.备库开启日志同步进程：
SQL> alter database recover managed standby database using current logfile disconnect from session;Database altered.
set line 1000
col status for a10
col type for a10
col error for a20
col gap_status for a20
col synchronization_status for a30
col recovery_mode for a30
select inst_id,status,DEST_ID,TYPE,ERROR,GAP_STATUS,SYNCHRONIZED,SYNCHRONIZATION_STATUS,RECOVERY_MODE from GV$ARCHIVE_DEST_STATUS where STatus <> 'INACTIVE' and type = 'PHYSICAL';INST_ID STATUS DEST_ID TYPE ERROR GAP_STATUS SYN SYNCHRONIZATION_STATUS RECOVERY_MODE
---------- ---------- ---------- ---------- ---------- ----------------- --- ----------------------------- ------------------------------1 VALID 2 PHYSICAL NO GAP NO CHECK CONFIGURATION MANAGED REAL TIME APPLY
-- 显示 NO GAP，同步正常SQL> col group# for a30
SQL> select process,thread#,group#,sequence#,status from gv$managed_standby;PROCESS THREAD# GROUP# SEQUENCE# STATUS
--------- ---------- ------------------------------ ---------- ------------
ARCH 0 N/A 0 CONNECTED
ARCH 0 N/A 0 CONNECTED
ARCH 1 8 84 CLOSING
ARCH 0 N/A 0 CONNECTED
RFS 0 N/A 0 IDLE
RFS 0 N/A 0 IDLE
RFS 1 5 85 IDLE
RFS 0 N/A 0 IDLE
MRP0 1 N/A 85 APPLYING_LOG9 rows selected.SQL> select count(*) from gv$archived_log where applied='NO';COUNT(*)
----------0
SQL> select * from v$archive_gap;no rows selected至此，DG GAP已被修复，以上方式为常规修复方式，各个版本都通用。
相关文章：
Oracle 11G DataGuard GAP 修复过程（通过主库scn增备恢复）
Oracle 11G DataGuard GAP 修复 （通过主库scn增备恢复） 介绍 DG GAP 顾名思义就是：DG不同步，当备库不能接受到一个或多个主库的归档日志文件时候，就发生了 GAP。 那么，如果遇到GAP如何修复呢？…...
WLAN AutoConfig服务假死？重启服务恢复网络连接！
目录 背景： 过程： 可能引起原因： 具体解决步骤： 方法一： 方法二： 总结： 背景： 这个问题困扰我好长一段时间了，每次下班将电脑关机后，次日早上电脑开机…...
【linux】（30）shell-条件判断
if 语句 if 语句是 Shell 脚本中用于条件判断的基本结构。 基本语法 if 语句的基本语法如下： if [ condition ] thencommands ficondition 是要测试的条件。commands 是在条件为真时要执行的命令。 示例 简单条件判断 #!/bin/bashif [ 1 -eq 1 ] thenecho &q…...
docker安装启动问题解决排查
一、安装docker报错 刚开始安装docker报这个错： Error: Transaction test error: file /usr/libexec/docker/cli-plugins/docker-buildx from install of docker-ce-cli-1:20.10.8-3.el8.x86_64 conflicts with file from package docker-buildx-plugin-0:0.14.0…...
《MySQL 查询进阶：复杂查询语句的魅力》
一、引言 MySQL 的复杂查询语句就像是一把神奇的钥匙，能够打开数据世界的大门，展现出数据的无限魅力。本文将带你深入探索 MySQL 查询进阶技巧，从常用查询到子查询，再到视图的运用，让你领略复杂查询语句的强大功能。 …...
OpenHarmony-3.HDF框架（2）
OpenHarmony HDF 平台驱动 1.平台驱动概述 系统平台驱动框架是系统驱动框架的重要组成部分，它基于HDF驱动框架、操作系统适配层(OSAL, operating system abstraction layer)以及驱动配置管理机制，为各类平台设备驱动的实现提供标准模型。 系统平台驱动(…...
人大金仓(KingBaseEs)数据库操作手册
人大金仓数据库（KingbaseES）是由北京人大金仓信息技术股份有限公司（简称人大金仓）自主研发的、具有自主知识产权的通用关系型数据库管理系统。 官方下载地址：KingbaseES 人大金仓数据库 KES技术文档在线手册…...
Flink+Paimon实时数据湖仓实践分享
随着 Paimon 近两年的推广普及，使用 FlinkPaimon 构建数据湖仓的实践也越来越多。在 Flink 实时数据开发中，对于依赖大量状态 state 的场景，如长周期的累加指标计算、回撤长历史数据并更新等，使用实时数仓作为中间存储来代替 Flin…...
w~深度学习~合集1
我自己的原文哦~ https://blog.51cto.com/whaosoft/12663254 #Motion Plan 代码 github.com/liangwq/robot_motion_planing 轨迹约束中的软硬约束 前面的几篇文章已经介绍了，轨迹约束的本质就是在做带约束的轨迹拟合。输入就是waypoint点list，约束…...
KVM 虚拟化
KVM（Kernel-based Virtual Machine）是一种基于内核的虚拟机技术，具有以下优势： 开源性：KVM是完全开源的，这意味着它没有许可费用，适合预算有限的用户。性能：KVM利用Linux内…...
MONI后台管理系统-数据库设计
前言：该文档纯属个人总结设计，如果雷同，纯属巧合，其中还有很不合理之处，请大家批评指正。如有应用于项目，请慎重。 注意: 如有需要该文件的sql脚本，请移步：资源下载 1. 表清单 序号…...
Rigol DP711自动控制--SCPI命令
通过串口的SCPI命令来控制通道输入输出 也可以用UltraSigma UI来发送SCPI 物理连接： Pin2_2, Pin3_3, Pin5_5 串口命令控制： 命令：9600， 8bit, None SCPI CMD(Standard Commands for Programmable Instruments) OUTPut CH1, On…...
总结FastDFS的面试题
目录 一：FastDFS的基础知识 1：定义 2：FastDFS的优点 3：tracker server 4：storage server 二：FastDFS的存储原理 1：小文件存储的问题 2：小文件合并存储 3：文件上…...
Fiddler 5.21.0 使用指南：过滤浏览器HTTP(S)流量下（四）
概述 在上一篇文章中，我们介绍了一部分简单的过滤功能，已经可以帮助我们较为准确的定位到感兴趣的请求；提升我们的工作效率，我们可以通过设置更为复杂的过滤规则，精准到定位的我们想要的请求和响应信息。专注于分析对…...
【踩坑】pip安装依赖卡在Installing build dependencies ...
pip安装依赖卡在Installing build dependencies ... 如图，pip安装依赖一直卡着，最后不得不ctrlC强制终止 用–verbose显示详细安装信息，发现卡在安装numpy pip install -r requirements.txt --verbose大概率是网络问题，用镜像单…...
【WRF-Urban】SLUCM新增空间分布城市冠层参数及人为热排放AHF代码详解（下）
目录 详细解释更改文件内容4 运行模块（run）:README.namelist5 输出模块（share）:share/module_check_a_mundo.Fshare/output_wrf.F参考SLUCM新增空间分布城市冠层参数及人为热排放AHF代码详解的前两部分内容可参见-【WRF-Urban】SLUCM新增空间分布城市冠层参数及人为热排放A…...
云桌面：云计算桌面
目录 云桌面的定义和核心概念 技术架构详解 主流架构详解 管理成本分析 安全性措施 应用场景详解 云桌面的定义和核心概念 云桌面是一种通过云计算技术提供的虚拟桌面服务，它允许用户通过网络访问远程服务器上的虚拟机，这些虚拟机为用户提供了一个…...
WPF+LibVLC开发播放器-音量控制和倍速控制
界面 界面上增加音量的控件和倍速控制控件 音量控制 主要也是一个Slider进度条控件来实现音量调节 我们这里设置默认的最大值为100，默认Value值也为100，默认声音开到最大 这里目前完全由前端控制音量调节，可以直接使用ValueChanged事件实…...
数智运营一体化平台项目经营分享
分离前后台，增强产品管理灵活性 前端成熟的流程平台，支持低代码快速灵活配置流程表单，完美解决流程频繁变化与快速上线、费用控制的矛盾。使产品管理体系，摆脱了流程可移植性差和投入大量人力物力无止境修改流程的困境。同时&…...
记录blender学习过程中遇到的问题
物体发射的方向不对 被发射物体（例如一棵树）n键看旋转归0 切换正视图 将被发射物体的局部坐标的Z轴 指向 全局方向的X轴时 并且把粒子系统设置的物体旋转勾选上 方向就对了 做倒角发现有问题 检查缩放应用、面朝向、有没有重合点（融合点&am…...
龙虎榜——20250610
上证指数放量收阴线，个股多数下跌，盘中受消息影响大幅波动。 深证指数放量收阴线形成顶分型，指数短线有调整的需求，大概需要一两天。 2025年6月10日龙虎榜行业方向分析 1. 金融科技 代表标的：御银股份、雄帝科技 驱动…...
Chapter03-Authentication vulnerabilities
文章目录 1. 身份验证简介1.1 What is authentication1.2 difference between authentication and authorization1.3 身份验证机制失效的原因1.4 身份验证机制失效的影响 2. 基于登录功能的漏洞2.1 密码爆破2.2 用户名枚举2.3 有缺陷的暴力破解防护2.3.1 如果用户登录尝试失败次…...
ES6从入门到精通：前言
ES6简介 ES6（ECMAScript 2015）是JavaScript语言的重大更新，引入了许多新特性，包括语法糖、新数据类型、模块化支持等，显著提升了开发效率和代码可维护性。 核心知识点概览 变量声明 let 和 const 取代 var…...
R语言AI模型部署方案：精准离线运行详解
R语言AI模型部署方案：精准离线运行详解 一、项目概述 本文将构建一个完整的R语言AI部署解决方案，实现鸢尾花分类模型的训练、保存、离线部署和预测功能。核心特点： 100%离线运行能力自包含环境依赖生产级错误处理跨平台兼容性模型版本管理# 文件结构说明 Iris_AI_Deployme…...
PPT|230页| 制造集团企业供应链端到端的数字化解决方案：从需求到结算的全链路业务闭环构建
制造业采购供应链管理是企业运营的核心环节，供应链协同管理在供应链上下游企业之间建立紧密的合作关系，通过信息共享、资源整合、业务协同等方式，实现供应链的全面管理和优化，提高供应链的效率和透明度，降低供应链的成…...
【机器视觉】单目测距——运动结构恢复
ps：图是随便找的，为了凑个封面 前言 在前面对光流法进行进一步改进，希望将2D光流推广至3D场景流时，发现2D转3D过程中存在尺度歧义问题，需要补全摄像头拍摄图像中缺失的深度信息，否则解空间不收敛…...
【服务器压力测试】本地PC电脑作为服务器运行时出现卡顿和资源紧张（Windows/Linux）
要让本地PC电脑作为服务器运行时出现卡顿和资源紧张的情况，可以通过以下几种方式模拟或触发： 1. 增加CPU负载 运行大量计算密集型任务，例如： 使用多线程循环执行复杂计算（如数学运算、加密解密等）。运行图…...
汇编常见指令
汇编常见指令 一、数据传送指令 指令功能示例说明MOV数据传送MOV EAX, 10将立即数 10 送入 EAXMOV [EBX], EAX将 EAX 值存入 EBX 指向的内存LEA加载有效地址LEA EAX, [EBX4]将 EBX4 的地址存入 EAX（不访问内存）XCHG交换数据XCHG EAX, EBX交换 EAX 和 EB…...
算法岗面试经验分享-大模型篇
文章目录 A 基础语言模型A.1 TransformerA.2 Bert B 大语言模型结构B.1 GPTB.2 LLamaB.3 ChatGLMB.4 Qwen C 大语言模型微调C.1 Fine-tuningC.2 Adapter-tuningC.3 Prefix-tuningC.4 P-tuningC.5 LoRA A 基础语言模型 A.1 Transformer （1）资源 论文&a…...
《C++ 模板》
目录 函数模板 类模板 非类型模板参数 模板特化 函数模板特化 类模板的特化 模板，就像一个模具，里面可以将不同类型的材料做成一个形状，其分为函数模板和类模板。 函数模板 函数模板可以简化函数重载的代码。格式：templa…...