购物网站建设款流程/电视剧百度风云榜
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…...
（八）腾讯cloudstudio+Stable-Diffusion-webui AI绘画教程-安装插件
一、说明 本文安装8个插件，先安装，后面在慢慢学习，我也是第一次喔 二、中英文双语语言包 （二）Ubuntu22.04Stable-Diffusion-webui AI绘画 中英双语插件安装-CSDN博客https://blog.csdn.net/jiangkp/article/details…...
记一次跑前端老项目的问题
记一次跑前端老项目的问题 一、前言二、过程1、下载依赖2、启动项目3、打包 一、前言 在一次跑前端老项目的时候，遇到了一些坑，这里记录一下。 二、过程 1、下载依赖 使用 npm install下载很久，然后给我报了个错 core-js2.6.12: core-js…...
深度学习：MindSpore自动并行
随着模型规模的逐渐增大，需要的算力逐渐增强，但是算力需求增长速度远高于芯片算力增长速度。现在唯一的解决方案只有通过超大规模集群训练大模型。 大集群训练大模型的挑战 内存墙 200B参数量的模型，参数内存占用745GB内存，训练…...
python拆分Excel文件
按Sheet拆分Excel 或 按照某一列的不同值拆分Excel。文档样式如下： 结果：红色是按照Sheet名拆出的，蓝色和橙色是某个Sheet按照某列的不同值拆分的。 代码： # -*- coding: utf-8 -*- """ 拆分excel文件——按照…...
Python实现Excel中数据条显示
Python中要实现百分比数据条的显示，可以使用pandas库，pandas图表样式的设置与Excel中的条件格式设置比较类似，比如Excel里常用的数据条的用法，在pandas中使用代码进行高亮显示，用来突出重点数据，下面一起来…...
c#如何开发后端
1选择开发框架 在 C# 中，用于后端开发最常用的框架是ASP.NET。它提供了构建 Web 应用程序、Web API 和微服务等多种后端服务所需的功能。ASP.NET有不同的模式，如ASP.NET MVC（Model - View - Controller）和ASP.NET Web API。ASP.NE…...
6.Vue------async/await详细的讲解---知识积累
前提： 先说一下Promise解释 Promise是一种在JavaScript中处理异步操作的对象。它代表了一个尚未完成但承诺未来某个时间会完成的操作结果。Promise有三种状态：pending（等待中）、fulfilled（已成功）和reject…...
Redis面试专题-持久化
目录 前言 持久化相关知识 1.三种持久化机制 2.RDB持久化 3.深入剖析一下RDB持久化过程 4.AOF持久化 5.RDB和AOF对比编辑 面试题 1.redis持久化机制有哪些？ 2.那仔细讲讲你对他们的理解 3.你刚刚说AOF的文件很大，那AOF文件会越来越大…...
如何将快捷指令添加到启动台
如何将快捷指令添加到启动台/Finder/访达（Mac） 1. 打开快捷指令创建快捷指令 示例创建了一个文件操作测试的快捷指令。 2. 右键选择添加到程序坞 鼠标放在待添加的快捷指令上。 3. 右键添加到访达 鼠标放在待添加的快捷指令上。 之后就可以在启…...
ansible自动化运维（二）ad-hoc模式
目录 Ansible模块（ad-hoc模式） 1.command模块：远程执行命令 2.shell 模块：远程执行命令，支持管道，重定向 3.Raw模块：先登录，再执行，最后退出 4.Script模块ÿ…...