[可能发生的现象]
由于网络断线造成网络故障，恢复前，信息交换受到阻碍，直到重新开始传输信息为止，需要一定时间。
以下是发生这种情况时，警报日志的输出例。
– 源数据库 : 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.直到信息交换自动重启为止一直待机。
- 请手动重启获得进程与应用进程
终止获得进程 ->终止应用进程 ->开始应用进程-> 开始获得进程
例)
源数据库 目标数据库
SQL> exec dbms_capture_adm.stop_capture(‘<capture_name>’);
SQL> exec dbms_apply_adm.stop_apply(‘<apply_name>’);
SQL> exec dbms_apply_adm.start_apply(‘<apply_name>’);
SQL> exec dbms_capture_adm.start_capture(‘<capture_name>’);
Leave a Reply