DataGuard - ORA-00261错误[1]

[入库:2005年8月18日] [更新:2007年3月24日]

本文简介:选择自 kamus 的 blog

以下是在作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

本文关键:DataGuard - ORA-00261错误
 

本站最佳浏览方式为 分辨率 1024x768 IE 6.0(或更高版本的 IE浏览器)

go top