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歸檔日誌缺失恢復
- DG日誌不應用，GAP,主備切換解決思路與辦法
- SQLServer 2000日誌檔案缺失只有MDF恢復資料庫的辦法SQLServer資料庫
- win10日誌檔案缺了怎麼辦_win10日誌缺失如何修復Win10
- 無歸檔日誌恢復rman資料
- dataguard主備資料同步與時鐘無關
- 引數檔案丟失無法啟動_ 利用alert日誌修復
- SQL Server無日誌資料庫恢復模式SQLServer資料庫模式
- 【DG】三張經典圖片展示Data Guard主備之間日誌傳輸及恢復
- 備份與恢復--從備份的歸檔日誌中恢復資料
- 11.2.0.3.2 RMAN無法恢復歸檔日誌
- NBU備份windows系統資料庫無法產生備份日誌情況解決Windows資料庫
- oracle dg 歸檔日誌恢復情況Oracle
- ORA-00279異常處理_offline資料檔案缺失日誌檔案問題一鍵修復
- 刪除redo所有日誌,資料庫無法啟動資料庫
- DG-在主庫/備庫刪除已經應用過的日誌.txt
- RMAN備份及恢復歸檔日誌的語法
- 【DG】利用閃回資料庫（flashback）修復Failover後的DG環境資料庫AI
- 日誌檔案的修復小結
- 非歸檔模式 無法用備份修復新建的表模式
- win10缺失dll檔案怎麼修復 win10一鍵修復dll缺失Win10
- data guard中增加與刪除主備資料庫中的聯機重做日誌與備重做日誌檔案資料庫
- dg主庫建立檔案備庫未同步解決方法
- PostgreSQL 恢復大法 - 恢復部分資料庫、跳過壞塊、修復無法啟動的資料庫SQL資料庫
- oracle dg 延遲120分鐘主庫同步資料到備份庫Oracle
- 邏輯dg刪除主庫過期歸檔日誌
- win10剪下板無法同步如何解決_win10剪下板無法跨平臺同步怎麼修復Win10
- 主備域之間無法同步截圖及解決說明
- win10自動修復無法修復你的電腦 華碩win10自動修復無法開機Win10
- 歸檔日誌無法歸檔導致資料庫hang住資料庫
- Mysql主主同步-配置資料同步MySql
- INACTIVE日誌組損壞的修復
- DG保護模式與備用聯機日誌檔案模式
- DG-備庫日誌的應用遲時檢查
- MySQL日誌管理，備份和恢復MySql
- MySQL 日誌管理、備份與恢復MySql
- 【北亞資料恢復】IBM DS系列儲存伺服器熱備盤同步資料故障導致卷無法掛載的資料恢復資料恢復IBM伺服器
- DG同步異常恢復文件