1:10:44 2015
Archived Log entry 10 added for thread 1 sequence 3 ID 0x81b3f444 dest 1:
Fri Apr 24 11:10:44 2015
Thread 1 advanced to log sequence 14 (LGWR switch)
? Current log# 3 seq# 14 mem# 0: /oradba/data/test/redo03.log
Fri Apr 24 11:15:44 2015
Archived Log entry 11 added for thread 1 sequence 4 ID 0x81b3f444 dest 1:
?
注意这里11:05:43 2015进行了一次归档，然后我大量的进行切换，观察到ALTER SYSTEM switchlog HANG住，
观察到日志：
Checkpoint not complete
? Current log# 2 seq# 13 mem# 0: /oradba/data/test/redo02.log
ORACLE Instance test - Can not allocate log, archival required
而等待到Fri Apr 24 11:10:44 2015 日志进行了归档
Archived Log entry 10 added for thread 1 sequence 3 ID 0x81b3f444 dest 1
而Fri Apr 24 11:15:44 2015 有进行了一个日志的归档
Archived Log entry 11 added for thread 1 sequence 4 ID 0x81b3f444 dest 1:
而对于RFS 进程来说即使STANDBY LOG 不够也会接受进行到FLASHBACK AREA中
如下也能够证明：
SQL> select COMPLETION_TIME,SEQUENCE#,NAME FROM v$archived_log;
COMPLETION_TIME? ? ? SEQUENCE# NAME
------------------- ---------- ---------------------------------------------------------------------
2015-04-23 17:58:08? ? ? ? 802 /oradba/archive/1_802_863273736.dbf
2015-04-23 18:06:16? ? ? ? 803 /oradba/archive/1_803_863273736.dbf
2015-04-24 09:57:08? ? ? ? 804 /oradba/archive/1_804_863273736.dbf
2015-04-24 10:31:07? ? ? ? 805 /oradba/archive/1_805_863273736.dbf
2015-04-24 10:40:40? ? ? ? 806 /oradba/archive/1_806_863273736.dbf
2015-04-24 10:55:42? ? ? ? ? 1 /oradba/archive/1_1_877862036.dbf
2015-04-24 10:59:41? ? ? ? 811 /home/oradba/flash_area/TESTDG1/archivelog/2015_04_24/o1_mf_1_811_bmm
2015-04-24 11:00:42? ? ? ? ? 2 /oradba/archive/1_2_877862036.dbf
2015-04-24 11:05:43? ? ? ? 807 /oradba/archive/1_807_863273736.dbf
2015-04-24 11:10:44? ? ? ? ? 3 /oradba/archive/1_3_877862036.dbf
2015-04-24 11:15:44? ? ? ? ? 4 /oradba/archive/1_4_877862036.dbf
o1_mf_1_811_bmm就是接受过来的LOGFILE。
不管怎么说snapshot standby 产生自身的归档日志和snapshot standby 确实会接受来自主库的日志是成立的
二、回到主备模式
1、shutdown immediate;
2、startup mount;
3、ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
4、shutdown immediate;
5、startup
6、ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;