- 请手动重启获得进程与应用进程
2013年6月21日
[Streams]因为网络问题造成信息传输延迟时
M
mac
Author
7 min
Read Time
12
Views
[可能发生的现象]
由于网络断线造成网络故障,恢复前,信息交换受到阻碍,直到重新开始传输信息为止,需要一定时间。
以下是发生这种情况时,警报日志的输出例。
- 源数据库 : CAPTURE01(获得进程)
-目标数据库 : APPLY011(应用进程)
源数据库 目标数据库
--------------------------- ---------------------------
-- 开始应用进程
Streams APPLY AP01 for APPLY01 started with pid=18, OS id=1048746
-- 开始获得进程
Streams CAPTURE CP01 for CAPTURE01 with pid=36, OS id=1233122 is in combined capture and apply mode.
Starting persistent Logminer Session with sid = 24 for Streams Capture CAPTURE01
-- 开始接收
Propagation Receiver (CCA) for Streams Capture CAPTURE01 and Apply APPLY01 with pid=30, OS id=348380 started.
********** 发生网络故障 ******
-- 重新尝试开始获得进程
CP01: Restarting Capture CAPTURE01 due to ORA-3135 in combined capture and apply
CP01: Restarting Capture CAPTURE01 due to ORA-448 in combined capture and apply
Streams CAPTURE CP01 for CAPTURE01 started with pid=41, OS id=1253604
Streams CAPTURE CP01 for CAPTURE01 with pid=36, OS id=1233122 stopped
********** 修复网络 **********
-- 开始获得进程
Streams CAPTURE CP01 for CAPTURE01 with pid=41, OS id=1253604 is in combined capture and apply mode.
Starting persistent Logminer Session with sid = 24 for Streams Capture CAPTURE01
-- 开始接收信息
Propagation Receiver (CCA) for Streams Capture CAPTURE01 and Apply APPLY01 with pid=40, OS id=483474 started.
-- 重启应用进程(终止,启动) <----- (*1)
Streams APPLY AP01 for APPLY01 with pid=18, OS id=1048746 stopped
Streams APPLY AP01 for APPLY01 started with pid=25, OS id=1003714
-----------------------------------
:
这段时间的信息交换终止
:
-----------------------------------
-- 检测获得进程中的错误 <----- (*2)
CP01: Restarting Capture CAPTURE01 due to ORA-26804 in combined capture and apply
CP01: Restarting Capture CAPTURE01 due to ORA-448 in combined capture and apply
-- 重启获得进程 <----- (*3)
Streams CAPTURE CP01 for CAPTURE01 started with pid=36, OS id=643324
Streams CAPTURE CP01 for CAPTURE01 with pid=41, OS id=1253604 stopped
Streams CAPTURE CP01 for CAPTURE01 with pid=36, OS id=643324 is in combined capture and apply mode.
-- 开始接收
Propagation Receiver (CCA) for Streams Capture CAPTURE01 and Apply APPLY01 with pid=30, OS id=348394 started.
--------------------------- ---------------------------
执行重启应用进程(终止、开始)后,到检测到应用进程无效化,需要一定时间。
通过获得进程检测到错误后,马上重启获得进程 (*3)。
[对象版本]
发生问题的版本 :Oracle Database 11g Release 2(11.2.0)
Oracle Database 11g Release 2(11.1.0)
修复了问题的版本 :无
预定修复问题的版本:未定
已修复问题的PSR :无
预计修复问题的PSR :未定
[目标平台]
所有平台
[可能发生的条件]
满足以下条件的话就可能发生。
- 获得与应用的复合 (CCA)有效
- 发生网络故障后,已修复的状态
[原因]
开发部还在研究。
根据研究情况,依次会反映在 KROWN 中
[发生故障时的对策]
1.直到信息交换自动重启为止一直待机。