流复制同步中断

今天发现流复制同步中断了。传播和应用都不报错。估计就是捕获进程异常，想停了重启。

 

begin                                                                 

  DBMS_CAPTURE_ADM.STOP_CAPTURE(capture_name  => 'STREAM_CAPTURE');  

end;                                                                   

/                             

 

ERROR at line 1:

ORA-26672: timeout occurred while stopping STREAMS process STREAM_CAPTURE

ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 626

ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 59

ORA-06512: at line 2

 

看来只有强制启动了。

begin                                                                 

  DBMS_CAPTURE_ADM.STOP_CAPTURE(capture_name  => 'STREAM_CAPTURE',force =>TRUE);  

end;                                                                  

/                                                                      

 

再启动捕获进程

begin                                                                 

  DBMS_CAPTURE_ADM.START_CAPTURE(capture_name  => 'STREAM_CAPTURE');  

end;                                                                   

/                                                                     

 

再看LOG

Mon Dec  1 11:53:09 2008

Streams CAPTURE C001 with pid=51, OS id=22884 stopped

Mon Dec  1 11:53:44 2008

Streams CAPTURE C001 started with pid=56, OS id=10666

Mon Dec  1 11:56:38 2008

LOGMINER: Parameters summary for session# = 301

LOGMINER: Number of processes = 3, Transaction Chunk Size = 1

LOGMINER: Memory Size = 10M, Checkpoint interval = 10M

LOGMINER: session# = 301, reader process P000 started with pid=74 OS id=25051

LOGMINER: session# = 301, builder process P001 started with pid=93 OS id=25076

LOGMINER: session# = 301, preparer process P002 started with pid=110 OS id=25086

Mon Dec  1 12:02:43 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101847_634298105.dbf

Mon Dec  1 12:02:43 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/2_66182_634298105.dbf

Mon Dec  1 12:06:31 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101847_634298105.dbf

Mon Dec  1 12:06:31 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101848_634298105.dbf

Mon Dec  1 12:06:31 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/2_66182_634298105.dbf

Mon Dec  1 12:06:32 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/2_66183_634298105.dbf

Mon Dec  1 12:06:43 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101848_634298105.dbf

Mon Dec  1 12:06:44 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101849_634298105.dbf

Mon Dec  1 12:08:44 2008

Thread 2 advanced to log sequence 66326

  Current log# 4 seq# 66326 mem# 0: +DG_DATA_01/billbj/onlinelog/group_4.827.634298157

Mon Dec  1 12:11:14 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101849_634298105.dbf

Mon Dec  1 12:11:17 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101850_634298105.dbf

Mon Dec  1 12:14:26 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101850_634298105.dbf

Mon Dec  1 12:14:27 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101851_634298105.dbf

Mon Dec  1 12:14:28 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/2_66183_634298105.dbf

Mon Dec  1 12:14:28 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/2_66184_634298105.dbf

Mon Dec  1 12:16:43 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101851_634298105.dbf

Mon Dec  1 12:16:43 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101852_634298105.dbf

Mon Dec  1 12:23:39 2008

Thread 2 advanced to log sequence 66327

  Current log# 3 seq# 66327 mem# 0: +DG_DATA_01/billbj/onlinelog/group_3.831.634298155

Mon Dec  1 12:24:20 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101852_634298105.dbf

Mon Dec  1 12:24:20 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101853_634298105.dbf

Mon Dec  1 12:28:06 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101853_634298105.dbf

Mon Dec  1 12:28:07 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101854_634298105.dbf

Mon Dec  1 12:28:08 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/2_66184_634298105.dbf

Mon Dec  1 12:28:08 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/2_66185_634298105.dbf

Mon Dec  1 12:32:43 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101854_634298105.dbf

Mon Dec  1 12:32:43 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101855_634298105.dbf

Mon Dec  1 12:32:58 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101855_634298105.dbf

Mon Dec  1 12:32:58 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101856_634298105.dbf

Mon Dec  1 12:33:06 2008

Thread 2 advanced to log sequence 66328

  Current log# 4 seq# 66328 mem# 0: +DG_DATA_01/billbj/onlinelog/group_4.827.634298157

Mon Dec  1 12:33:12 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101856_634298105.dbf

Mon Dec  1 12:33:18 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101857_634298105.dbf

Mon Dec  1 12:33:19 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/2_66185_634298105.dbf

Mon Dec  1 12:33:19 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/2_66186_634298105.dbf

Mon Dec  1 12:33:32 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101857_634298105.dbf

Mon Dec  1 12:33:32 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101858_634298105.dbf

Mon Dec  1 12:33:47 2008

LOGMINER: End mining logfile: +DG_DATA_02/billbj/1_101858_634298105.dbf

Mon Dec  1 12:33:47 2008

LOGMINER: Begin mining logfile: +DG_DATA_02/billbj/1_101859_634298105.dbf

Mon Dec  1 12:34:05 2008

 

。。。。。。

 

又开始复制了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9375/viewspace-504201/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9375/viewspace-504201/