测试验证11.2.0.4 data guard如何在物理备库及快照备库处理 archive gap小记

数据库版本

[oracle@xinao from_xinao_arch]$ sqlplus '/as sysdba' SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 12 00:39:27 2014 Copyright (c) 1982, 2013, Oracle.  All rights reserved.

1,切换物理备库为快照备库模式

SQL> startup mount ORACLE instance started. Total System Global Area  588746752 bytes Fixed Size                  2255472 bytes Variable Size             226493840 bytes Database Buffers          356515840 bytes Redo Buffers                3481600 bytes Database mounted. SQL> alter database recover managed standby database using current logfile disconnect from session; Database altered. SQL> alter system set db_recovery_file_dest_size=10g; System altered. SQL> alter system set db_recovery_file_dest='/home/oracle/fast_reco'; System altered. SQL> alter database convert to snapshot standby; alter database convert to snapshot standby * ERROR at line 1: ORA-38784: Cannot create restore point 'SNAPSHOT_STANDBY_REQUIRED_12/11/2014 21:43:15'. ORA-01153: an incompatible media recovery is active SQL> alter database recover managed standby database cancel; Database altered. SQL> alter database convert to snapshot standby; Database altered.

2,查看快照备库的归档信息

SQL>  alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; Session altered. SQL> select sequence#,first_time,next_time from v$archived_log order by 1;  SEQUENCE# FIRST_TIME          NEXT_TIME ---------- ------------------- -------------------         18 2014-12-11 20:32:31 2014-12-11 21:25:01         19 2014-12-11 21:25:01 2014-12-11 21:25:35         20 2014-12-11 21:25:35 2014-12-11 21:31:02         21 2014-12-11 21:31:02 2014-12-11 21:31:09         22 2014-12-11 21:31:09 2014-12-11 21:39:35

3,快照备库仍可继续接受主库归档

SQL> /  SEQUENCE# FIRST_TIME          NEXT_TIME ---------- ------------------- -------------------         18 2014-12-11 20:32:31 2014-12-11 21:25:01         19 2014-12-11 21:25:01 2014-12-11 21:25:35         20 2014-12-11 21:25:35 2014-12-11 21:31:02         21 2014-12-11 21:31:02 2014-12-11 21:31:09         22 2014-12-11 21:31:09 2014-12-11 21:39:35         23 2014-12-11 21:39:35 2014-12-11 21:48:12         24 2014-12-11 21:48:12 2014-12-11 21:48:35         25 2014-12-11 21:48:35 2014-12-11 21:49:39

4，主备库网络正常情况下，验证主备库归档gap

SQL> select thread#,low_sequence#,high_sequence# from v$archive_gap; no rows selected

5,模拟主备库网络中断

停止备库监听 [oracle@xinao dbs]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-DEC-2014 21:55:58 Copyright (c) 1991, 2013, Oracle.  All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.4)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date                11-DEC-2014 20:59:10 Uptime                    0 days 0 hr. 56 min. 48 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File         /oracle/diag/tnslsnr/xinao/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.4)(PORT=1521))) Services Summary... Service "xinao" has 2 instance(s).   Instance "xinao", status UNKNOWN, has 1 handler(s) for this service...   Instance "xinao", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@xinao dbs]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-DEC-2014 21:56:01 Copyright (c) 1991, 2013, Oracle.  All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.4)(PORT=1521))) The command completed successfully 可见仅在备库停备库监听，仍未达到主备网络中断之用 SQL> /  SEQUENCE# FIRST_TIME          NEXT_TIME ---------- ------------------- -------------------         18 2014-12-11 20:32:31 2014-12-11 21:25:01         19 2014-12-11 21:25:01 2014-12-11 21:25:35         20 2014-12-11 21:25:35 2014-12-11 21:31:02         21 2014-12-11 21:31:02 2014-12-11 21:31:09         22 2014-12-11 21:31:09 2014-12-11 21:39:35         23 2014-12-11 21:39:35 2014-12-11 21:48:12         24 2014-12-11 21:48:12 2014-12-11 21:48:35         25 2014-12-11 21:48:35 2014-12-11 21:49:39         26 2014-12-11 21:49:39 2014-12-11 21:56:54         27 2014-12-11 21:56:54 2014-12-11 21:56:56         28 2014-12-11 21:56:56 2014-12-11 21:56:58  SEQUENCE# FIRST_TIME          NEXT_TIME ---------- ------------------- -------------------         29 2014-12-11 21:56:58 2014-12-11 21:57:00         30 2014-12-11 21:57:00 2014-12-11 21:57:01         31 2014-12-11 21:57:01 2014-12-11 21:58:41 14 rows selected. 暂禁备库网卡 [root@xinao ~]# ifconfig eth0 down 主备多次切换日志 SQL> alter system switch logfile; System altered. System altered. SQL> / System altered. SQL> / System altered. SQL> / System altered. 备库验证并未接收主库归档日志

6，主库多次日志切换，模拟归档gap

可见不会产生archive gap SQL>  select thread#,low_sequence#,high_sequence# from v$archive_gap; no rows selected

8，恢复主备网络

9，主库多次日志切换，生成新的归档日志

SQL> alter system switch logfile; System altered. SQL> / System altered.

10，主备库重新恢复网络正常情况下，验证主备库归档gap

可见主备网络恢复，自动获取中断的主库归档日志 SQL>  select sequence#,first_time,next_time from v$archived_log order by 1;  SEQUENCE# FIRST_TIME          NEXT_TIME ---------- ------------------- -------------------         18 2014-12-11 20:32:31 2014-12-11 21:25:01         19 2014-12-11 21:25:01 2014-12-11 21:25:35         20 2014-12-11 21:25:35 2014-12-11 21:31:02         21 2014-12-11 21:31:02 2014-12-11 21:31:09         22 2014-12-11 21:31:09 2014-12-11 21:39:35         23 2014-12-11 21:39:35 2014-12-11 21:48:12         24 2014-12-11 21:48:12 2014-12-11 21:48:35         25 2014-12-11 21:48:35 2014-12-11 21:49:39         26 2014-12-11 21:49:39 2014-12-11 21:56:54         27 2014-12-11 21:56:54 2014-12-11 21:56:56         28 2014-12-11 21:56:56 2014-12-11 21:56:58  SEQUENCE# FIRST_TIME          NEXT_TIME ---------- ------------------- -------------------         29 2014-12-11 21:56:58 2014-12-11 21:57:00         30 2014-12-11 21:57:00 2014-12-11 21:57:01         31 2014-12-11 21:57:01 2014-12-11 21:58:41         32 2014-12-11 21:58:41 2014-12-11 22:04:19         33 2014-12-11 22:04:19 2014-12-11 22:04:37          34 2014-12-11 22:04:37 2014-12-11 22:08:33         35 2014-12-11 22:08:33 2014-12-11 22:08:41 18 rows selected.

11，恢复主备库网络，若此时继续生成主库新的归档日志，此时切换主库日志，速即识别主库至备库监听已关闭

[oracle@langfang trace]$ tail -f alert_langfang.log     TNS-00511: No listener     nt secondary err code: 111     nt OS err code: 0 Error 12541 received logging on to the standby Check whether the listener is up and running. FAL[server, ARC3]: Error 12541 creating remote archivelog file 'xinao' FAL[server, ARC3]: FAL archive failed, see trace file. ARCH: FAL archive failed. Archiver continuing ORACLE Instance langfang - Archival Error. Archiver continuing.

12，启动备库监听

[oracle@xinao ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-DEC-2014 22:19:03 Copyright (c) 1991, 2013, Oracle.  All rights reserved. Starting /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/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /oracle/diag/tnslsnr/xinao/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.4)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.4)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date                11-DEC-2014 22:19:03 Uptime                    0 days 0 hr. 0 min. 0 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File         /oracle/diag/tnslsnr/xinao/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.4)(PORT=1521))) Services Summary... Service "xinao" has 1 instance(s).   Instance "xinao", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully

13，持续观察主库告警日志，新生成的归档传送到备库

Thu Dec 11 22:22:37 2014 Thread 1 advanced to log sequence 40 (LGWR switch)   Current log# 1 seq# 40 mem# 0: /oracle/langfang/redo01.log Thu Dec 11 22:22:37 2014 Archived Log entry 234 added for thread 1 sequence 39 ID 0x781d0691 dest 1: Thu Dec 11 22:22:37 2014 ****************************************************************** LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2 ****************************************************************** Thu Dec 11 22:22:37 2014 ARC4: Standby redo logfile selected for thread 1 sequence 39 for destination LOG_ARCHIVE_DEST_2 LNS: Standby redo logfile selected for thread 1 sequence 40 for destination LOG_ARCHIVE_DEST_2

14，重命名备库归档文件，模拟归档gap

[oracle@xinao from_xinao_arch]$ ls -lrht total 8.2M -rw-r-----. 1 oracle oinstall 4.7M Dec 11 21:25 1_18_853777039.dbf -rw-r-----. 1 oracle oinstall 271K Dec 11 21:25 1_19_853777039.dbf -rw-r-----. 1 oracle oinstall 162K Dec 11 21:31 1_20_853777039.dbf -rw-r-----. 1 oracle oinstall 4.5K Dec 11 21:31 1_21_853777039.dbf -rw-r-----. 1 oracle oinstall 254K Dec 11 21:39 1_22_853777039.dbf -rw-r-----. 1 oracle oinstall 268K Dec 11 21:49 1_23_853777039.dbf -rw-r-----. 1 oracle oinstall  33K Dec 11 21:49 1_25_853777039.dbf -rw-r-----. 1 oracle oinstall 222K Dec 11 21:56 1_26_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:56 1_27_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:56 1_28_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:57 1_29_853777039.dbf -rw-r-----. 1 oracle oinstall 1.5K Dec 11 21:57 1_30_853777039.dbf -rw-r-----. 1 oracle oinstall  51K Dec 11 21:58 1_31_853777039.dbf -rw-r-----. 1 oracle oinstall 1.9M Dec 11 22:04 1_32_853777039.dbf -rw-r-----. 1 oracle oinstall 9.5K Dec 11 22:04 1_33_853777039.dbf -rw-r-----. 1 oracle oinstall 4.5K Dec 11 22:11 1_35_853777039.dbf -rw-r-----. 1 oracle oinstall 154K Dec 11 22:11 1_34_853777039.dbf -rw-r-----. 1 oracle oinstall 176K Dec 11 22:22 1_39_853777039.dbf [oracle@xinao from_xinao_arch]$ mv 1_34_853777039.dbf 1_34_853777039.dbf.rename

15,可见即便备库模拟重命名归档文件，主库不会重传对应归档文件

主库切换日志 SQL> alter system switch logfile; System altered. 备库验证 [oracle@xinao from_xinao_arch]$ ls -lrht total 8.4M -rw-r-----. 1 oracle oinstall 4.7M Dec 11 21:25 1_18_853777039.dbf -rw-r-----. 1 oracle oinstall 271K Dec 11 21:25 1_19_853777039.dbf -rw-r-----. 1 oracle oinstall 162K Dec 11 21:31 1_20_853777039.dbf -rw-r-----. 1 oracle oinstall 4.5K Dec 11 21:31 1_21_853777039.dbf -rw-r-----. 1 oracle oinstall 254K Dec 11 21:39 1_22_853777039.dbf -rw-r-----. 1 oracle oinstall 268K Dec 11 21:49 1_23_853777039.dbf -rw-r-----. 1 oracle oinstall  33K Dec 11 21:49 1_25_853777039.dbf -rw-r-----. 1 oracle oinstall 222K Dec 11 21:56 1_26_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:56 1_27_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:56 1_28_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:57 1_29_853777039.dbf -rw-r-----. 1 oracle oinstall 1.5K Dec 11 21:57 1_30_853777039.dbf -rw-r-----. 1 oracle oinstall  51K Dec 11 21:58 1_31_853777039.dbf -rw-r-----. 1 oracle oinstall 1.9M Dec 11 22:04 1_32_853777039.dbf -rw-r-----. 1 oracle oinstall 9.5K Dec 11 22:04 1_33_853777039.dbf -rw-r-----. 1 oracle oinstall 4.5K Dec 11 22:11 1_35_853777039.dbf -rw-r-----. 1 oracle oinstall 154K Dec 11 22:11 1_34_853777039.dbf.rename -rw-r-----. 1 oracle oinstall 176K Dec 11 22:22 1_39_853777039.dbf -rw-r-----. 1 oracle oinstall 227K Dec 11 22:30 1_40_853777039.dbf

16，回切备库为物理备库

自快照模式切为物理备库，须先关闭库，然后打开库，再启库至MOUNT，然后切为物理备库 SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area  588746752 bytes Fixed Size                  2255472 bytes Variable Size             226493840 bytes Database Buffers          356515840 bytes Redo Buffers                3481600 bytes Database mounted. SQL>  alter database convert to physical standby;  alter database convert to physical standby * ERROR at line 1: ORA-16433: The database must be opened in read/write mode. SQL> alter database open; Database altered. SQL> alter database convert to physical standby; alter database convert to physical standby * ERROR at line 1: ORA-01126: database must be mounted in this instance and not open in any instance SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup  mount ORACLE instance started. Total System Global Area  588746752 bytes Fixed Size                  2255472 bytes Variable Size             226493840 bytes Database Buffers          356515840 bytes Redo Buffers                3481600 bytes Database mounted. SQL> alter database convert to physical standby; Database altered.

17,可见自快照备库模式回切为物理备库，之前重命名或MISSING的主库归档，会自动自主库传到备库

[oracle@xinao from_xinao_arch]$ ls -lrht total 8.9M -rw-r-----. 1 oracle oinstall 4.7M Dec 11 21:25 1_18_853777039.dbf -rw-r-----. 1 oracle oinstall 271K Dec 11 21:25 1_19_853777039.dbf -rw-r-----. 1 oracle oinstall 162K Dec 11 21:31 1_20_853777039.dbf -rw-r-----. 1 oracle oinstall 4.5K Dec 11 21:31 1_21_853777039.dbf -rw-r-----. 1 oracle oinstall 254K Dec 11 21:39 1_22_853777039.dbf -rw-r-----. 1 oracle oinstall 268K Dec 11 21:49 1_23_853777039.dbf -rw-r-----. 1 oracle oinstall  33K Dec 11 21:49 1_25_853777039.dbf -rw-r-----. 1 oracle oinstall 222K Dec 11 21:56 1_26_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:56 1_27_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:56 1_28_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:57 1_29_853777039.dbf -rw-r-----. 1 oracle oinstall 1.5K Dec 11 21:57 1_30_853777039.dbf -rw-r-----. 1 oracle oinstall  51K Dec 11 21:58 1_31_853777039.dbf -rw-r-----. 1 oracle oinstall 1.9M Dec 11 22:04 1_32_853777039.dbf -rw-r-----. 1 oracle oinstall 9.5K Dec 11 22:04 1_33_853777039.dbf -rw-r-----. 1 oracle oinstall 4.5K Dec 11 22:11 1_35_853777039.dbf -rw-r-----. 1 oracle oinstall 154K Dec 11 22:11 1_34_853777039.dbf.rename -rw-r-----. 1 oracle oinstall 176K Dec 11 22:22 1_39_853777039.dbf -rw-r-----. 1 oracle oinstall 227K Dec 11 22:30 1_40_853777039.dbf -rw-r-----. 1 oracle oinstall  31K Dec 11 22:36 1_1_866065432.dbf -rw-r-----. 1 oracle oinstall 325K Dec 11 22:40 1_41_853777039.dbf -rw-r-----. 1 oracle oinstall 154K Dec 11 22:41 1_34_853777039.dbf -rw-r-----. 1 oracle oinstall  47K Dec 11 22:41 1_42_853777039.dbf

18,物理备库下，重命名已自主库接受的归档文件

[oracle@xinao from_xinao_arch]$ mv 1_28_853777039.dbf 1_28_853777039.dbf.rename [oracle@xinao from_xinao_arch]$

19，手工切换主库，观察上述重命名归档文件可否自主库重传到备库

主库多次切换 SQL> alter system switch logfile; System altered. 44及45序列归档未在备库应用 SQL>select recid,sequence#,name,dest_id,next_time,applied,deleted,status from v$archived_log where dest_id=2 order by 1     RECID  SEQUENCE# NAME               DEST_ID NEXT_TIME    APPLIED   DEL S ---------- ---------- --------------- ---------- ------------ --------- --- -        231         36 xinao                    2 11-DEC-14    YES       NO  A        232         37 xinao                    2 11-DEC-14    YES       NO  A        233         38 xinao                    2 11-DEC-14    YES       NO  A        235         39 xinao                    2 11-DEC-14    YES       NO  A        237         40 xinao                    2 11-DEC-14    YES       NO  A        239         41 xinao                    2 11-DEC-14    YES       NO  A        240         34 xinao                    2 11-DEC-14    YES       NO  A        241         42 xinao                    2 11-DEC-14    YES       NO  A        244         43 xinao                    2 11-DEC-14    YES       NO  A        246         44 xinao                    2 11-DEC-14    NO        NO  A        248         45 xinao                    2 11-DEC-14    NO        NO  A 120 rows selected. 在备库重命名44归档日志 [oracle@xinao from_xinao_arch]$ mv 1_44_853777039.dbf 1_44_853777039.dbf.rename [oracle@xinao from_xinao_arch]$ [oracle@xinao from_xinao_arch]$ ls -lrht total 9.5M -rw-r-----. 1 oracle oinstall 4.7M Dec 11 21:25 1_18_853777039.dbf -rw-r-----. 1 oracle oinstall 271K Dec 11 21:25 1_19_853777039.dbf -rw-r-----. 1 oracle oinstall 162K Dec 11 21:31 1_20_853777039.dbf -rw-r-----. 1 oracle oinstall 4.5K Dec 11 21:31 1_21_853777039.dbf -rw-r-----. 1 oracle oinstall 254K Dec 11 21:39 1_22_853777039.dbf -rw-r-----. 1 oracle oinstall 268K Dec 11 21:49 1_23_853777039.dbf -rw-r-----. 1 oracle oinstall  33K Dec 11 21:49 1_25_853777039.dbf -rw-r-----. 1 oracle oinstall 222K Dec 11 21:56 1_26_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:56 1_27_853777039.dbf -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:56 1_28_853777039.dbf.rename -rw-r-----. 1 oracle oinstall 2.0K Dec 11 21:57 1_29_853777039.dbf -rw-r-----. 1 oracle oinstall 1.5K Dec 11 21:57 1_30_853777039.dbf -rw-r-----. 1 oracle oinstall  51K Dec 11 21:58 1_31_853777039.dbf -rw-r-----. 1 oracle oinstall 1.9M Dec 11 22:04 1_32_853777039.dbf -rw-r-----. 1 oracle oinstall 9.5K Dec 11 22:04 1_33_853777039.dbf -rw-r-----. 1 oracle oinstall 4.5K Dec 11 22:11 1_35_853777039.dbf -rw-r-----. 1 oracle oinstall 154K Dec 11 22:11 1_34_853777039.dbf.rename -rw-r-----. 1 oracle oinstall 176K Dec 11 22:22 1_39_853777039.dbf -rw-r-----. 1 oracle oinstall 227K Dec 11 22:30 1_40_853777039.dbf -rw-r-----. 1 oracle oinstall  31K Dec 11 22:36 1_1_866065432.dbf -rw-r-----. 1 oracle oinstall 325K Dec 11 22:40 1_41_853777039.dbf -rw-r-----. 1 oracle oinstall 154K Dec 11 22:41 1_34_853777039.dbf -rw-r-----. 1 oracle oinstall  47K Dec 11 22:41 1_42_853777039.dbf -rw-r-----. 1 oracle oinstall 139K Dec 11 22:46 1_43_853777039.dbf -rw-r-----. 1 oracle oinstall 319K Dec 11 22:56 1_44_853777039.dbf.rename -rw-r-----. 1 oracle oinstall  67K Dec 11 22:58 1_45_853777039.dbf 再次主库多次切换,发现备库重命名的归档，主库不会重传至备库 SQL> alter system switch logfile;

20,禁用主库网卡，模拟归档gap

查看主库告警日志,主备库网卡不通 移动主库归档文件至新的目录 复启主库网卡 备库查看是否存在archive gap，正好是上述主库重命名的归档文件86 [oracle@xinao trace]$ tail -f alert_xinao.log FAL[client]: Failed to request gap sequence  GAP - thread 1 sequence 86-86  DBID 2014868718 branch 853777039 FAL[client]: All defined FAL servers have been attempted. ------------------------------------------------------------ Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that's sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps. -------------------------- 主库还原上述86归档 [oracle@langfang langfang_arch]$ mv 1_86_853777039.dbf.rename 1_86_853777039.dbf [oracle@langfang langfang_arch]$ 备库可知86 gap马上自动就传至备库(注：标红部分推知备库会自GAP的归档一直恢复至最新的归档日志以行介质恢复） Fri Dec 12 00:31:48 2014 RFS[16]: Assigned to RFS process 7550 RFS[16]: Opened log for thread 1 sequence 86 dbid 2014868718 branch 853777039 Archived Log entry 77 added for thread 1 sequence 86 rlc 853777039 ID 0x781d0691 dest 2: Fri Dec 12 00:31:48 2014 Media Recovery Log /oracle/from_xinao_arch/1_86_853777039.dbf Media Recovery Log /oracle/from_xinao_arch/1_87_853777039.dbf Media Recovery Log /oracle/from_xinao_arch/1_88_853777039.dbf Media Recovery Log /oracle/from_xinao_arch/1_89_853777039.dbf Media Recovery Waiting for thread 1 sequence 90 (in transit) Recovery of Online Redo Log: Thread 1 Group 4 Seq 90 Reading mem 0   Mem# 0: /oracle/xinao/standby_redo04.log 备库再查archive gap不再存在 SQL> select count(*) from v$archive_gap;   COUNT(*) ----------          0

 结论

1,关闭备库监听，主备库归档传输不受影响 2,禁用备库网卡，恢复网络后，备库自动续传中断时的主库归档日志 3,快照备库下若重命名未应用的归档文件，回切至物理备库，会自动重传对应的归档文件 4,恢复备库网卡后，主库即可识别归档不能传至归档，需启动备库监听 5,禁用主库网卡且移动主库log_archive_dest_1产生的部分归档文件，尔后主库产生日志文件，其后恢复主库网卡，即产生archive gap 6,须在备库查询archive gap方可

个人简介

8年oracle从业经验，具备丰富的oracle技能，目前在国内北京某专业oracle服务公司从事高级技术顾问。

   

   服务过的客户：

          中国电信

          中国移动

          中国联通

          中国电通

          国家电网

          四川达州商业银行

          湖南老百姓大药房

          山西省公安厅

          中国邮政

          北京302医院     

          河北廊坊新奥集团公司

  
 项目经验:

           中国电信3G项目AAA系统数据库部署及优化

           中国联通CRM数据库性能优化

           中国移动10086电商平台数据库部署及优化

           湖南老百姓大药房ERR数据库sql优化项目

           四川达州商业银行TCBS核心业务系统数据库模型设计和RAC部署及优化

           四川达州商业银行TCBS核心业务系统后端批处理存储过程功能模块编写及优化

           北京高铁信号监控系统RAC数据库部署及优化

           河南宇通客车数据库性能优化

           中国电信电商平台核心采购模块表模型设计及优化

           中国邮政储蓄系统数据库性能优化及sql优化

           北京302医院数据库迁移实施

           河北廊坊新奥data guard部署及优化

           山西公安厅身份证审计数据库系统故障评估

           国家电网上海灾备项目4 node rac+adg 

 联系方式：

          手机：18201115468

          qq   :   305076427

          qq微博: wisdomone1

          新浪微博：wisdomone9

          qq群：275813900    

          itpub博客名称：wisdomone1    http://blog.itpub.net/9240380/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-1365126/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-1365126/