DG備庫斷檔問題

備庫斷檔問題出現的原因：主庫歸檔日誌丟失（指定歸檔目錄）；如果是網路問題，網路恢復後會自動再次傳輸未傳輸的歸檔檔案；

主庫歸檔日誌丟失或者找不到，則需透過主庫的備份恢復丟失的歸檔日誌；

實驗準備環境：

1.前提備庫停止應用日誌：

SQL> recover managed standby database cancel;

Media recovery complete.

2.主庫操作：（產生歸檔日誌，並且已經透過LSN程式將日誌傳輸到備庫，只要網路正常的情況下）

SYS@ORA11GR2>alter system switch logfile;

System altered.

SYS@ORA11GR2>/

System altered.

SYS@ORA11GR2>/

System altered.

——檢視主庫生成了幾個新的歸檔檔案：

SYS@ORA11GR2>select sequence#,applied from v$archived_log order by 1;

SEQUENCE# APPLIED

---------- ---------

14 YES

15 YES

16 YES

17 YES

18 YES

19 YES

20 YES

21 YES

SEQUENCE# APPLIED

---------- ---------

21 YES

22 YES

23 YES

24 YES

25 YES

26 YES

27 YES

28 NO

SEQUENCE# APPLIED

---------- ---------

28 YES

29 NO

29 YES

30 YES

30 NO

30 YES

31 YES

31 NO

32 NO

33 NO

SEQUENCE# APPLIED

---------- ---------

33 NO

34 NO

34 NO（因為現在是主庫不需要應用日誌）

36 rows selected.

3.檢視備庫：（32、33、34日誌未應用，說明是剛傳輸過來的，前面已經停了應用）

select sequence#,applied from v$archived_log order by 1;

SEQUENCE# APPLIED

---------- ---------

18 YES

19 YES

20 YES

21 YES

22 YES

23 YES

24 YES

25 YES

26 YES

SEQUENCE# APPLIED

---------- ---------

27 YES

27 NO

28 YES

29 YES

30 NO

30 YES

31 YES

32 NO

33 NO

34 NO

21 rows selected.（32、33、34日誌未應用）

4.模擬故障：

主庫：

[oracle@wang ORA11GR2]$ pwd

/u01/arch1/ORA11GR2

[oracle@wang ORA11GR2]$ ls

1_15_921272292.arc 1_22_921272292.arc 1_29_921272292.arc

1_16_921272292.arc 1_23_921272292.arc 1_30_921272292.arc

1_17_921272292.arc 1_24_921272292.arc 1_31_921272292.arc

1_18_921272292.arc 1_25_921272292.arc 1_32_921272292.arc

1_19_921272292.arc 1_26_921272292.arc 1_33_921272292.arc

1_20_921272292.arc 1_27_921272292.arc 1_34_921272292.arc

1_21_921272292.arc 1_28_921272292.arc

[oracle@wang ORA11GR2]$ mv 1_32_921272292.arc 1_32_921272292.arc.bak

[oracle@wang ORA11GR2]$ ls

1_15_921272292.arc 1_22_921272292.arc 1_29_921272292.arc

1_16_921272292.arc 1_23_921272292.arc 1_30_921272292.arc

1_17_921272292.arc 1_24_921272292.arc 1_31_921272292.arc

1_18_921272292.arc 1_25_921272292.arc 1_32_921272292.arc.bak

1_19_921272292.arc 1_26_921272292.arc 1_33_921272292.arc

1_20_921272292.arc 1_27_921272292.arc 1_34_921272292.arc

1_21_921272292.arc 1_28_921272292.arc

備庫：

[oracle@bing OCMU]$ pwd

/u01/arch1/OCMU

[oracle@bing OCMU]$

[oracle@bing OCMU]$ mv 1_32_921272292.arc back

[oracle@bing OCMU ]$ ls (沒有32號日誌了)

1_18_921272292.arc 1_24_921272292.arc 1_30_921272292.arc

1_19_921272292.arc 1_25_921272292.arc 1_31_921272292.arc

1_20_921272292.arc 1_26_921272292.arc 1_33_921272292.arc

1_21_921272292.arc 1_27_921272292.arc 1_34_921272292.arc

1_22_921272292.arc 1_28_921272292.arc back

1_23_921272292.arc 1_29_921272292.arc

5.再次在備庫操作：備庫應用日誌

SQL> recover managed standby database using current logfile disconnect from session;

Media recovery complete.

——查詢：

SQL> select sequence#,applied from v$archived_log order by 1;

SEQUENCE# APPLIED

---------- ---------

18 YES

19 YES

20 YES

21 YES

22 YES

23 YES

24 YES

25 YES

26 YES

SEQUENCE# APPLIED

---------- ---------

27 YES

27 NO

28 YES

29 YES

30 NO

30 YES

31 YES

32 NO

33 NO

34 NO

21 rows selected.

32、33、34日誌還是沒有被應用；

6.解決：（備庫操作）

[oracle@bing OCMU]$ pwd

/u01/arch1/ OCMU

[oracle@bing OCMU]$ cd back/

[oracle@bing back]$ ls

1_32_921272292.arc

[oracle@bing back]$ mv 1_32_921272292.arc /u01/arch1/ORA11GR2

[oracle@bing back]$ cd ..

[oracle@bing OCMU]$ ls

1_18_921272292.arc 1_24_921272292.arc 1_30_921272292.arc

1_19_921272292.arc 1_25_921272292.arc 1_31_921272292.arc

1_20_921272292.arc 1_26_921272292.arc 1_32_921272292.arc

1_21_921272292.arc 1_27_921272292.arc 1_33_921272292.arc

1_22_921272292.arc 1_28_921272292.arc 1_34_921272292.arc

1_23_921272292.arc 1_29_921272292.arc back

[oracle@bing OCMU]$

——再在備庫register一下剛剛找回來的歸檔日誌：

SQL> alter database register physical logfile '/u01/arch1/ORA11GR2/1_32_921272292.arc';

Database altered.

8.再次在備庫檢視是否應用日誌（已經應用了，因為應用日誌命令一直開著，沒有關閉。如果應用日誌已經關閉，重新應用一下日誌後在檢視日誌時候應用的狀態）

SQL> select sequence#,applied from v$archived_log order by 1;

SEQUENCE# APPLIED

---------- ---------

18 YES

19 YES

20 YES

21 YES

22 YES

23 YES

24 YES

25 YES

26 YES

SEQUENCE# APPLIED

---------- ---------

27 YES

27 NO

28 YES

29 YES

30 NO

30 YES

31 YES

32 YES

33 YES

34 YES

22 rows selected.

斷檔問題解決！！！！！！！！！

【DG】備庫斷檔問題

DG備庫斷檔問題

相關文章