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备库断档问题