2 seq# 47 mem# 0: /u01/app/oracle/prod/disk1/redo02.log
Current log# 2 seq# 47 mem# 1: /u01/app/oracle/prod/disk2/log2b.log
Sun Apr 20 16:30:45 2014
LNS: Standby redo logfile selected for thread 1 sequence 47 for destination LOG_ARCHIVE_DEST_2
###
Sun Apr 20 16:33:09 2014
Thread 1 advanced to log sequence 48
Current log# 3 seq# 48 mem# 0: /u01/app/oracle/prod/disk1/redo03.log
Current log# 3 seq# 48 mem# 1: /u01/app/oracle/prod/disk2/log3b.log
Sun Apr 20 16:33:10 2014
LNS: Standby redo logfile selected for thread 1 sequence 48 for destination LOG_ARCHIVE_DEST_2
此期间备库日志：
Sun Apr 20 04:29:32 2014
Completed: alter database recover managed standby database disconnect from session
Sun Apr 20 04:30:01 2014
RFS[9]: Successfully opened standby log 4: '/u01/app/oracle/prod/disk1/standbylog1.log'
Sun Apr 20 04:30:01 2014
Media Recovery Log /u01/app/oracle/prod/arch/1_45_844894247.arc
Media Recovery Waiting for thread 1 sequence 46
Sun Apr 20 04:30:01 2014
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[10]: Assigned to RFS process 12480
RFS[10]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
RFS[10]: Successfully opened standby log 4: '/u01/app/oracle/prod/disk1/standbylog1.log'
Sun Apr 20 04:30:36 2014
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[11]: Assigned to RFS process 12574
RFS[11]: Identified database type as 'physical standby'
Sun Apr 20 04:30:40 2014
Primary database is in MAXIMUM PERFORMANCE mode
RFS[10]: Successfully opened standby log 5: '/u01/app/oracle/prod/disk1/standbylog2.log'
Sun Apr 20 04:30:40 2014
Expanded controlfile section 11 from 28 to 280 records
Requested to grow by 252 records; added 9 blocks of records
Sun Apr 20 04:30:41 2014
Media Recovery Log /u01/app/oracle/prod/arch/1_46_844894247.arc
Media Recovery Waiting for thread 1 sequence 47 (in transit)
###
Sun Apr 20 04:33:04 2014
Primary database is in MAXIMUM PERFORMANCE mode
RFS[10]: Successfully opened standby log 4: '/u01/app/oracle/prod/disk1/standbylog1.log'
Sun Apr 20 04:33:06 2014
Media Recovery Log /u01/app/oracle/prod/arch/1_47_844894247.arc
Media Recovery Waiting for thread 1 sequence 48 (in transit)
#########################
实验6：接上一步，模拟网络中断：--备库上SERVICE NETWORK STOP 主库做归档
16:35:19 SQL>
16:37:37 SQL> alter system switch logfile;
System altered.
16:37:38 SQL> alter system switch logfile;
System altered.
16:39:46 SQL>
16:43:34 SQL> alter system switch logfile;
System altered.
16:43:38 SQL>
16:44:18 SQL> alter system switch logfile;
System altered.
16:44:19 SQL> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
51
备库网络中断期间主库归档时日志：
[oracle@ocm1 ~]$ tail -f alert_PROD.log
Sun Apr 20 16:37:38 2014
Thread 1 advanced to log sequence 49
Current log# 1 seq# 49 mem# 0: /u01/app/oracle/prod/disk1/redo01.log
Current log# 1 seq# 49 mem# 1: /u01/app/oracle/prod/disk2/log1b.log
Sun Apr 20 16:39:43 2014
ARC0: Controlfile enqueue unavailable
Sun Apr 20 16:39:43 2014
Errors in file /u01/app/oracle/product/10.2.0.1/dbhome_1/rdbms/log/prod_arc0_9993.trc:
ORA-16146: standby destination control file enqueue unavailable
LNS1 started with pid=16, OS id=12597
Sun Apr 20 16:39:46 2014
Thread 1 advanced to log sequence 50
Current log# 2 seq# 50 mem# 0: /u01/app/oracle/prod/disk1/r |