数据库版本
[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/