[可能发生的现象] 由于网络断线造成网络故障,恢复前,信息交换受到阻碍,直到重新开始传输信息为止,需要一定时间。     以下是发生这种情况时,警报日志的输出例。   - 源数据库     : 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.直到信息交换自动重启为止一直待机。
  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>');