datafile 16: '/global/oradata/ctsdb/stk_his_ind_data4_01.dbf'
starting datafile 17 recovery in thread 1 sequence 8390
datafile 17: '/global/oradata/ctsdb/stk_his_ts01.dbf'
starting datafile 18 recovery in thread 1 sequence 8390
datafile 18: '/global/oradata/ctsdb/stk_his_ts02.dbf'
starting datafile 19 recovery in thread 1 sequence 8390
datafile 19: '/global/oradata/ctsdb/stk_inx_ts01.dbf'
starting datafile 20 recovery in thread 1 sequence 8390
datafile 20: '/global/oradata/ctsdb/stk_inx_ts02.dbf'
starting datafile 21 recovery in thread 1 sequence 8390
datafile 21: '/global/oradata/ctsdb/stk_ts01.dbf'
starting datafile 22 recovery in thread 1 sequence 8390
datafile 22: '/global/oradata/ctsdb/stk_ts02.dbf'
starting datafile 23 recovery in thread 1 sequence 8390
datafile 23: '/global/oradata/ctsdb/logmnrts01.dbf'
starting datafile 24 recovery in thread 1 sequence 8390
datafile 24: '/global/oradata/ctsdb/ts_test01.dbf'
starting datafile 25 recovery in thread 1 sequence 8390
datafile 25: '/global/oradata/ctsdb/ts_test02.dbf'
starting datafile 26 recovery in thread 1 sequence 8390
datafile 26: '/global/oradata/ctsdb/stk_his_ind_ts02.dbf'
starting datafile 27 recovery in thread 1 sequence 8390
datafile 27: '/global/oradata/ctsdb/stk_ts03.dbf'
media recovery waiting for thread 1 seq# 8390
tue aug 31 20:04:24 2004
completed: alter database recover managed standby database di
--用skip standby logfile选项作failover
tue aug 31 20:04:40 2004
alter database recover managed standby database finish skip standby logfile
tue aug 31 20:04:40 2004
database not recovered through end-of-redo
terminal incomplete recovery: request posted
tue aug 31 20:04:54 2004
terminal incomplete recovery: until change 3592753
terminal incomplete recovery: end-of-redo log allocation
terminal incomplete recovery: log 4 reserved for thread 1 seq# 8390
terminal recovery changing datafile format version from 8.0.0.0.0 to 9.0.0.0.0
switching logfile format version from 8.0.0.0.0 to 9.0.0.0.0
terminal incomplete recovery: clearing standby redo logs.
terminal incomplete recovery: thread 1 seq# 8390 redo required
terminal incomplete recovery: end-of-redo log /global/oradata/ctsdb/stdby_redo04.log
identified end-of-redo for thread 1 sequence 8390
terminal incomplete recovery: end checkpoint scn 3592754
mrp0: media recovery complete
switching logfile format version from 9.0.0.0.0 to 8.0.0.0.0
terminal incomplete recovery: successful completion
begin: wait for standby logfiles to be archived
tue aug 31 20:04:55 2004
arc0: evaluating archive log 4 thread 1 sequence 8390
arc0: beginning to archive log 4 thread 1 sequence 8390
tue aug 31 20:04:55 2004
arc1: evaluating archive log 4 thread 1 sequence 8390
tue aug 31 20:04:55 2004
creating archive destination log_archive_dest_1: '/global/oradata/ctsdb/archive/arch1_8390.log'
tue aug 31 20:04:55 2004
arc1: unable to archive log 4 thread 1 sequence 8390
log actively being archived by another process
tue aug 31 20:04:55 2004
arc0: completed archiving log 4 thread 1 sequence 8390
tue aug 31 20:05:10 2004
end: all standby logfiles have been archived
resetting standby activation id 4038461969 (0xf0b60a11)
mrp0: background media recovery process shutdown
tue aug 31 20:05:10 2004
terminal incomplete recovery: completion detected
completed: alter database recover managed standby database fi
--failover成功，但是可以看到数据库作了resetlogs，这并不是我们希望的，而且由于skip了当前的standby redo log，所以肯定有相当的数据损失。
tue aug 31 20:05:12 2004
alter database commit to switchover to primary
alter database commit to switchover to primary
resetlogs after incomplete recovery until change 3592754
resetting resetlogs activation id 0 (0x0)
online log 3 of thread 1 was previously cleared
online log 5 of thread 0 was previously cleared
online log 6 of thread 0 was previously cleared
online log 7 of thread 0 was previously cleared
resetlogs changing datafile format version from 9.0.0.0.0 to 8.0.0.0.0
switchover: complete - database shutdown required
