教程(视频,书籍)下载:  ASP.NET AutoCAD 数据库 C# ASP java photoshop 网页设计 delphi 3dmax Flash C++ VB 张孝祥 实例   更多请进入BIBIDU搜索

　　以下是在作failover时standby端的alertlog内容，情况时拔掉Primary的网线，模拟Primary数据库网络环境突然损坏。
　　
　　--下行表示standby端的standby redo log已经启用
　　
　　RFS: Successfully opened standby logfile 4: '/global/oradata/ctsdb/stdby_redo04.log'
　　Tue Aug 31 19:54:30 2004
　　Media Recovery Log /global/oradata/ctsdb/archive/arch1_8389.log
　　Media Recovery Waiting for thread 1 seq# 8390 (in transit)
　　Tue Aug 31 19:54:57 2004
　　Restarting dead background process QMN0
　　QMN0 started with pid=12
　　Tue Aug 31 19:55:19 2004
　　
　　--开始failover，第一步
　　ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
　　Tue Aug 31 19:55:19 2004
　　Terminal Recovery: request posted
　　Tue Aug 31 19:55:48 2004
　　
　　--在SQLPLUS端finish命令没有报错，正常结束，但是下面几行显示standby redo file并没有被正确recover
　　Warning: log 4 of thread 1 is being archived or modified
　　MRP0: Background Media Recovery terminated with error 261
　　Tue Aug 31 19:55:48 2004
　　Errors in file /export/home/oracle/app/oracle/admin/ctsdb/bdump/ctsdb_mrp0_2201.trc:
　　ORA-00261: log 4 of thread 1 is being archived or modified
　　ORA-00312: online log 4 thread 1: '/global/oradata/ctsdb/stdby_redo04.log'
　　Recovery interrupted.
　　MRP0: Background Media Recovery process shutdown
　　Tue Aug 31 19:55:48 2004
　　Terminal Recovery: completion detected
　　Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FI
　　
　　--failover第二步，执行switchover
　　Tue Aug 31 19:56:01 2004
　　ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
　　Tue Aug 31 19:56:01 2004
　　ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
　　Database not recovered through End-Of-REDO
　　Database not recovered through End-Of-REDO
　　
　　--switchover报错，无法将standby转为primary
　　Switchover: Media recovery required - standby not in limbo
　　ORA-16139 signalled during: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY...
　　
　　--尝试使用activate命令，同样报ORA-00261错误
　　Tue Aug 31 19:57:16 2004
　　ALTER DATABASE ACTIVATE STANDBY DATABASE
　　Tue Aug 31 19:57:16 2004
　　ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE
　　Tue Aug 31 19:57:31 2004
　　Warning: log 4 of thread 1 is being archived or modified
　　Activate standby database received error 261
　　ORA-261 signalled during: ALTER DATABASE ACTIVATE STANDBY DATABASE...
　　Tue Aug 31 19:58:18 2004
　　ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
　　Tue Aug 31 19:58:18 2004
　　ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
　　Database not recovered through End-Of-REDO
　　Database not recovered through End-Of-REDO
　　Switchover: Media recovery required - standby not in limbo
　　ORA-16139 signalled during: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY...
　　
　　--重新将standby置为管理恢复模式
　　Tue Aug 31 20:04:18 2004
　　ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
　　Attempt to start background Managed Standby Recovery process
　　MRP0 started with pid=12
　　MRP0: Background Managed Standby Recovery process started
　　Tue Aug 31 20:04:22 2004
　　RFS: Possible network disconnect with primary database
　　Tue Aug 31 20:04:24 2004
　　Starting datafile 1 recovery in thread 1 sequence 8390
　　Datafile 1: '/global/oradata/ctsdb/system01.dbf'
　　Starting datafile 2 recovery in thread 1 sequence 8390
　　Datafile 2: '/global/oradata/ctsdb/undotbs01.dbf'
　　Starting datafile 3 recovery in thread 1 sequence 8390
　　Datafile 3: '/global/oradata/ctsdb/indx01.dbf'
　　Starting datafile 4 recovery in thread 1 sequence 8390
　　Datafile 4: '/global/oradata/ctsdb/tools01.dbf'
　　Starting datafile 5 recovery in thread 1 sequence 8390
　　Datafile 5: '/global/oradata/ctsdb/users01.dbf'
　　Starting datafile 6 recovery in thread 1 sequence 8390
　　Datafile 6: '/global/oradata/ctsdb/perfstat.dbf'
　　Starting datafile 7 recovery in thread 1 sequence 8390
　　Datafile 7: '/global/oradata/ctsdb/stk_his_data1_01.dbf'
　　Starting datafile 8 recovery in thread 1 sequence 8390
　　Datafile 8: '/global/oradata/ctsdb/stk_his_data2_01.dbf'
　　Starting datafile 9 recovery in thread 1 sequence 8390
　　Datafile 9: '/global/oradata/ctsdb/stk_his_data3_01.dbf'
　　Starting datafile 10 recovery in thread 1 sequence 8390
　　Datafile 10: '/global/oradata/ctsdb/stk_his_data4_01.dbf'
　　Starting datafile 11 recovery in thread 1 sequence 8390
　　Datafile 11: '/global/oradata/ctsdb/stk_his_ind_ts01.dbf'
　　Starting datafile 12 recovery in thread 1 sequence 8390
　　Datafile 12: '/global/oradata/ctsdb/stk_his_ind_ts03.dbf'
　　Starting datafile 13 recovery in thread 1 sequence 8390
　　Datafile 13: '/global/oradata/ctsdb/stk_his_ind_data1_01.dbf'
　　Starting datafile 14 recovery in thread 1 sequence 8390
　　Datafile 14: '/global/oradata/ctsdb/stk_his_ind_data2_01.dbf'
　　Starting datafile 15 recovery in thread 1 sequence 8390
　　Datafile 15: '/global/oradata/ctsdb/stk_his_ind_data3_01.dbf'
　　Starting datafile 16 recovery in thread 1 sequence 8390
　　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