DG主備日誌缺失，資料無法同步修復
1、資料庫版本：
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
2、檢查主備庫同步狀態
主庫：
SYS@orcl>archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Next log sequence to archive 8
Current log sequence 8
備庫：
SYS@orcl>select process,sequence#,status from v$managed_standby;
PROCESS SEQUENCE# STATUS
--------- ---------- ------------
ARCH 0 CONNECTED
DGRD 0 ALLOCATED
DGRD 0 ALLOCATED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
RFS 0 IDLE
RFS 8 IDLE
RFS 0 IDLE
MRP0 8 APPLYING_LOG
10 rows selected.
3、主庫 scott/oracle@pdb1 增加 it表記錄
SCOTT@pdb1>select count(*) from it;
COUNT(*)
----------
16
SCOTT@pdb1>commit;
Commit complete
備庫顯示已經同步：
SCOTT@pdb1>select count(*) from it;
COUNT(*)
----------
12
4、刪除主庫所有線上 redo日誌，重啟庫：
[oracle@db1 ORCL]$ rm -rf redo0*
[oracle@db1 ORCL]$ ll
total 3015912
-rw-r----- 1 oracle oinstall 20103168 Jul 31 10:10 control01.ctl
-rw-r----- 1 oracle oinstall 104865792 Jul 31 09:33 data01.dbf
drwxr-xr-x 2 oracle oinstall 103 Jul 31 09:30 pdb1
drwxr-xr-x 2 oracle oinstall 6 Jul 31 09:20 pdb2
drwxr-xr-x 2 oracle oinstall 6 Jul 31 09:20 pdb3
drwxr-xr-x 2 oracle oinstall 6 Jul 31 09:20 pdb4
drwxr-x--- 2 oracle oinstall 111 Jul 31 09:30 pdbseed
-rw-r----- 1 oracle oinstall 209715712 Jul 31 09:33 standby01.log
-rw-r----- 1 oracle oinstall 209715712 Jul 31 09:33 standby02.log
-rw-r----- 1 oracle oinstall 209715712 Jul 31 09:33 standby03.log
-rw-r----- 1 oracle oinstall 209715712 Jul 31 09:33 standby04.log
-rw-r----- 1 oracle oinstall 796925952 Jul 31 10:08 sysaux01.dbf
-rw-r----- 1 oracle oinstall 964698112 Jul 31 10:08 system01.dbf
-rw-r----- 1 oracle oinstall 104865792 Jul 31 09:33 temp.dbf
-rw-r----- 1 oracle oinstall 356524032 Jul 31 10:05 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Jul 31 09:33 users01.dbf
主庫 alert.log報錯：
2022-07-31T10:15:47.167108+08:00
ARC1 (PID:24715): Master archival failure: error=313
2022-07-31T10:15:47.168645+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc2_24717.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata/ORCL/redo02.log'
4、清空線上 redo日誌
主庫：
RMAN> list failure;
using target database control file instead of recovery catalog
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
8303 CRITICAL OPEN 31-JUL-22 Online log group 3 is unavailable
8297 CRITICAL OPEN 31-JUL-22 Online log group 2 is unavailable
8291 CRITICAL OPEN 31-JUL-22 Online log group 1 is unavailable
8306 HIGH OPEN 31-JUL-22 Online log member /oradata/ORCL/redo03.log is missing
8300 HIGH OPEN 31-JUL-22 Online log member /oradata/ORCL/redo02.log is missing
8294 HIGH OPEN 31-JUL-22 Online log member /oradata/ORCL/redo01.log is missing
清空 redo日誌：
SYS@orcl>set linesize 200;
SYS@orcl>select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ----------
1 1 15 209715200 512 1 YES INACTIVE 4349770 31-JUL-22 4352046 31-JUL-22 0
3 1 16 209715200 512 1 YES INACTIVE 4352046 31-JUL-22 4352054 31-JUL-22 0
2 1 17 209715200 512 1 NO CURRENT 4352054 31-JUL-22 1.8447E+19 0
SYS@orcl>alter database clear logfile group 1;
Database altered.
SYS@orcl>alter database clear logfile group 2;
alter database clear logfile group 2
ERROR at line 1:
ORA-00350: log 2 of instance orcl (thread 1) needs to be archived
ORA-00312: online log 2 thread 1: '/oradata/ORCL/redo02.log'
SYS@orcl>alter database clear logfile group 3;
Database altered.
嘗試使用 clear unarchived logfile方式清空；
SYS@orcl>alter database clear unarchived logfile group 2;
Database altered.
啟動主庫：
SYS@orcl>alter database open;
Database altered.
SYS@orcl>alter pluggable database all open;
Pluggable database altered.
SYS@orcl>show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
SYS@orcl>archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 18
Next log sequence to archive 19
Current log sequence 19
SCOTT@pdb1>select * from it;
ID
----------
1
2
100
1
2
100
1
2
100
1
2
ID
----------
100
999
222
888
1111
16 rows selected.
5、檢查備庫資料同步狀態
SYS@orcl>select process,sequence#,status from v$managed_standby;
PROCESS SEQUENCE# STATUS
--------- ---------- ------------
ARCH 0 CONNECTED
DGRD 0 ALLOCATED
DGRD 0 ALLOCATED
ARCH 18 CLOSING
ARCH 0 CONNECTED
ARCH 0 CONNECTED
RFS 0 IDLE
RFS 19 IDLE
RFS 0 IDLE
MRP0 17 APPLYING_LOG
10 rows selected.
SYS@orcl>archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 15
Next log sequence to archive 0
Current log sequence 17
SCOTT@pdb1>select * from it;
ID
1
2
100
1
2
100
1
2
100
1
2
ID
----------
100
999
222
888
15 rows selected.
從現象來看，主庫資料沒有同步過來！！！ 主庫日誌日誌斷檔 -缺少 17號日誌，造成資料無法同步；
[oracle@db1 2022_07_31]$ ll -lrth
-rw-r----- 1 oracle oinstall 153K Jul 31 06:50 o1_mf_1_21_kgcfgfxs_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 06:50 o1_mf_1_22_kgcfgfz0_.arc
-rw-r----- 1 oracle oinstall 4.4M Jul 31 08:29 o1_mf_1_23_kgcm728w_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 08:29 o1_mf_1_1_kgcm72fl_.arc
-rw-r----- 1 oracle oinstall 11M Jul 31 09:09 o1_mf_1_2_kgcokkpm_.arc
-rw-r----- 1 oracle oinstall 1.5K Jul 31 09:09 o1_mf_1_3_kgcokl7z_.arc
-rw-r----- 1 oracle oinstall 2.0M Jul 31 09:26 o1_mf_1_4_kgcpkwqk_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 09:26 o1_mf_1_5_kgcpkws2_.arc
-rw-r----- 1 oracle oinstall 241K Jul 31 09:32 o1_mf_1_6_kgcpy08y_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 09:33 o1_mf_1_7_kgcpz1ot_.arc
-rw-r----- 1 oracle oinstall 19K Jul 31 10:17 o1_mf_1_9_kgcsl61c_.arc
-rw-r----- 1 oracle oinstall 31K Jul 31 10:21 o1_mf_1_10_kgcsrqq2_.arc
-rw-r----- 1 oracle oinstall 1.9M Jul 31 10:21 o1_mf_1_11_kgcssn3l_.arc
-rw-r----- 1 oracle oinstall 249K Jul 31 10:30 o1_mf_1_12_kgct980r_.arc
-rw-r----- 1 oracle oinstall 179K Jul 31 10:34 o1_mf_1_13_kgctlkfr_.arc
-rw-r----- 1 oracle oinstall 12K Jul 31 10:35 o1_mf_1_14_kgctm6hq_.arc
-rw-r----- 1 oracle oinstall 730K Jul 31 10:45 o1_mf_1_15_kgcv6x9d_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 10:45 o1_mf_1_16_kgcv6xbo_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 11:31 o1_mf_1_18_kgcxx9lr_.arc
[oracle@db2 2022_07_31]$ ls -lrth
total 5.3M
-rw-r----- 1 oracle oinstall 1.5K Jul 31 09:09 o1_mf_1_3_kgcokl49_.arc
-rw-r----- 1 oracle oinstall 2.0M Jul 31 09:26 o1_mf_1_4_kgcpkwlv_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 09:26 o1_mf_1_5_kgcpkwo9_.arc
-rw-r----- 1 oracle oinstall 241K Jul 31 09:34 o1_mf_1_6_kgcq18bj_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 09:34 o1_mf_1_7_kgcq1bwz_.arc
-rw-r----- 1 oracle oinstall 19K Jul 31 10:17 o1_mf_1_9_kgcsl883_.arc
-rw-r----- 1 oracle oinstall 31K Jul 31 10:21 o1_mf_1_10_kgcsrt2x_.arc
-rw-r----- 1 oracle oinstall 1.9M Jul 31 10:21 o1_mf_1_11_kgcssn72_.arc
-rw-r----- 1 oracle oinstall 249K Jul 31 10:30 o1_mf_1_12_kgct983p_.arc
-rw-r----- 1 oracle oinstall 179K Jul 31 10:34 o1_mf_1_13_kgctlkjw_.arc
-rw-r----- 1 oracle oinstall 12K Jul 31 10:35 o1_mf_1_14_kgctm6ml_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 10:45 o1_mf_1_16_kgcv6xco_.arc
-rw-r----- 1 oracle oinstall 730K Jul 31 10:45 o1_mf_1_15_kgcv6xdh_.arc
-rw-r----- 1 oracle oinstall 1.0K Jul 31 11:31 o1_mf_1_18_kgcxxcx9_.arc
7、恢復備庫日誌斷檔，使主備資料同步！
方法有多種：
第一種：使用 duplicate 複製線上庫；
第二種：採用主庫建立備庫控制檔案，使用全備份主庫，二者一起恢復備庫；（資料量大）
第三種：採用主庫建立備庫控制檔案，使用增量備份主庫，二者一起恢復備庫。（資料量較少）
下面第三種方式（主備同步）：
開始增量備份主庫：
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup as compressed backupset incremental level 1 cumulative database format '/home/oracle/backup3/full_db_level1_%U_%T.bak';
sql 'alter system archive log current';
backup archivelog all not backed up 1 times format '/home/oracle/backup3/arh_level1_%U_%T.bak';
backup current controlfile format '/home/oracle/backup3/ctl_level1_%U_%T.bak';
backup spfile format '/home/oracle/backup3/spfile_level1_%U_%T.bak';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
為備庫備份控制檔案：
[oracle@db1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 31 15:04:27 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SYS@orcl>alter database create standby controlfile as '/home/oracle/standby01.ctl';
Database altered.
增量備份 +控制檔案一起復制到備庫：
[oracle@db1 ~]$ scp -r backup3 oracle@db2:/home/oracle
啟動備庫到 nomount狀態：
SYS@orcl>startup nomount;
ORACLE instance started.
Total System Global Area 2466250400 bytes
Fixed Size 9137824 bytes
Variable Size 553648128 bytes
Database Buffers 1895825408 bytes
Redo Buffers 7639040 bytes
恢復控制檔案：
RMAN> restore controlfile from '/home/oracle/backup3/standby01.ctl';
Starting restore at 31-JUL-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=379 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=/oradata/ORCLDG/control01.ctl
output file name=/flash_recovery_area/ORCLDG/control02.ctl
Finished restore at 31-JUL-22
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
註冊恢復目錄：
RMAN> catalog start with '/home/oracle/backup3/';
恢復備庫：
RMAN> recover database;
Starting recover at 31-JUL-22
using channel ORA_DISK_1
RMAN-00571: =======================================
RMAN-00569: ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/31/2022 15:10:40
RMAN-06094: datafile 86 must be restored
RMAN> restore datafile 86;
Starting restore at 31-JUL-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00086 to /oradata/ORCL/data111.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup3/full_db_level1_h4140ct6_1_1_20220731.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup3/full_db_level1_h4140ct6_1_1_20220731.bak tag=TAG20220731T150302
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 31-JUL-22
RMAN> recover database;
Starting recover at 31-JUL-22
using channel ORA_DISK_1
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 00004: /oradata/ORCL/undotbs01.dbf
destination for restore of datafile 00085: /oradata/ORCL/data01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup3/full_db_level1_h5140ct6_1_1_20220731.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup3/full_db_level1_h5140ct6_1_1_20220731.bak tag=TAG20220731T150302
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 00075: /oradata/ORCL/pdb1/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup3/full_db_level1_h6140ct6_1_1_20220731.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup3/full_db_level1_h6140ct6_1_1_20220731.bak tag=TAG20220731T150302
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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/ORCL/system01.dbf
destination for restore of datafile 00007: /oradata/ORCL/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup3/full_db_level1_h3140ct6_1_1_20220731.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup3/full_db_level1_h3140ct6_1_1_20220731.bak tag=TAG20220731T150302
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00003: /oradata/ORCL/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup3/full_db_level1_h4140ct6_1_1_20220731.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup3/full_db_level1_h4140ct6_1_1_20220731.bak tag=TAG20220731T150302
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00074: /oradata/ORCL/pdb1/system01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup3/full_db_level1_h8140ctb_1_1_20220731.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup3/full_db_level1_h8140ctb_1_1_20220731.bak tag=TAG20220731T150302
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00076: /oradata/ORCL/pdb1/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup3/full_db_level1_hb140cte_1_1_20220731.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup3/full_db_level1_hb140cte_1_1_20220731.bak tag=TAG20220731T150302
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00081: /oradata/ORCL/pdb1/data11.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup3/full_db_level1_hc140ctf_1_1_20220731.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup3/full_db_level1_hc140ctf_1_1_20220731.bak tag=TAG20220731T150302
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
starting media recovery
archived log for thread 1 with sequence 19 is already on disk as file /flash_recovery_area/ORCLDG/archivelog/2022_07_31/o1_mf_1_19_kgdb9m0n_.arc
archived log for thread 1 with sequence 20 is already on disk as file /flash_recovery_area/ORCLDG/archivelog/2022_07_31/o1_mf_1_20_kgdb9mbm_.arc
archived log file name=/flash_recovery_area/ORCLDG/archivelog/2022_07_31/o1_mf_1_19_kgdb9m0n_.arc thread=1 sequence=19
archived log file name=/flash_recovery_area/ORCLDG/archivelog/2022_07_31/o1_mf_1_20_kgdb9mbm_.arc thread=1 sequence=20
media recovery complete, elapsed time: 00:00:00
Finished recover at 31-JUL-22
啟動備庫：
RMAN> alter database open;
Statement processed
備庫同步主庫資料：
[oracle@db2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 31 15:13:14 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SYS@orcl>@1
Database altered.
檢查備庫日誌：（日誌序列 21已經同步到備庫了，主庫下一個日誌序列是 21）
2022-07-31T15:13:20.717299+08:00
TT02 (PID:48672): Waiting for all non-current ORLs to be archived
2022-07-31T15:13:20.717411+08:00
TT02 (PID:48672): All non-current ORLs have been archived
2022-07-31T15:13:20.867609+08:00
PR00 (PID:48662): Media Recovery Waiting for T-1.S-21 (in transit)
2022-07-31T15:13:20.868152+08:00
Recovery of Online Redo Log: Thread 1 Group 4 Seq 21 Reading mem 0
Mem# 0: /oradata/ORCL/standby01.log
2022-07-31T15:13:21.492542+08:00
Completed: alter database recover managed standby database using current logfile disconnect from session
主庫：
[oracle@db1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 31 15:14:49 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SYS@orcl>archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 19
Next log sequence to archive 21
Current log sequence 21
開啟 pdb1庫；
[oracle@db2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 31 15:13:14 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SYS@orcl>@1
Database altered.
（ ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;）
SYS@orcl>show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
SYS@orcl>alter pluggable database pdb1 open;
Pluggable database altered.
SYS@orcl>show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ ONLY NO
檢查主備庫資料一致性：
主庫：
SCOTT@pdb1>select count(*) from it;
COUNT(*)
----------
16
備庫：
SCOTT@pdb1>select count(*) from it;
COUNT(*)
----------
16
總結：主備資料不同步可能有多種原因，一般過程如下： 1、資料同步語句是否開啟 2、主備應用日誌是否相同，是否存在日誌缺失 3、備庫 alter檔案是否報錯，具體問題再來解決。
Yicheng16
22.07.31
-- The End --
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/69963467/viewspace-2908333/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- DG歸檔日誌缺失恢復
- win10日誌檔案缺了怎麼辦_win10日誌缺失如何修復Win10
- ORA-00279異常處理_offline資料檔案缺失日誌檔案問題一鍵修復
- oracle dg 歸檔日誌恢復情況Oracle
- dg主庫建立檔案備庫未同步解決方法
- 在DG備庫備份資料庫並恢復到一個主機上，報錯RMAN-06820資料庫
- SQLServer 2012 AG主節點無法截斷事務日誌SQLServer
- DG同步異常恢復文件
- springboot+logback日誌非同步資料庫Spring Boot非同步資料庫
- win10缺失dll檔案怎麼修復 win10一鍵修復dll缺失Win10
- 利用binlog日誌恢復mysql資料MySql
- PostgreSQL 恢復大法 - 恢復部分資料庫、跳過壞塊、修復無法啟動的資料庫SQL資料庫
- 【北亞資料恢復】IBM DS系列儲存伺服器熱備盤同步資料故障導致卷無法掛載的資料恢復資料恢復IBM伺服器
- Oracle DG異構主備支援Oracle
- win10剪下板無法同步如何解決_win10剪下板無法跨平臺同步怎麼修復Win10
- MySQL 日誌管理、備份與恢復MySql
- MySQL日誌管理，備份和恢復MySql
- openGauss-非同步備升主資料找回能力非同步
- 部署otter實現mysql主備資料同步（下）MySql
- 部署otter實現mysql主備資料同步（上）MySql
- MySQL重做日誌恢復資料的流程MySql
- 世界備份日｜資料安全 有“備”無患
- win10自動修復無法修復你的電腦 華碩win10自動修復無法開機Win10
- oracle DG 日誌傳輸小結Oracle
- 【DG】Oracle之級聯DG--(cascade dg) --(一主一備一級聯)Oracle
- DG修復：異常關庫導致的資料庫啟動失敗ORA-01110及GAP修復資料庫
- StarRocks-FE無法啟動，日誌：
- 資料庫修復資料恢復資料庫資料恢復
- ghost win10無法啟動修復失敗怎麼修復_ghost win10無法啟動修復失敗如何解決Win10
- Win10無法開機提示“自動修復無法修復你的電腦”的解決方法Win10
- 【DG】Data Guard主備庫Failove切換AI
- 【DG】Data Guard主備庫Switchover切換
- win10無法訪問smb共享資料夾的具體修復方法Win10
- win10資料夾加密內容選項無法選擇如何修復Win10加密
- 用增量備份來快速恢復dg
- ORACLE DG從庫 Rman備份恢復Oracle
- win10主題打不開怎麼辦_win10主題無法使用修復方法Win10
- redo損壞修復啟動資料庫辦法資料庫