LSP0: rolling back apply server 1 是做什麼 ?

tolywang發表於2009-11-23
發現Oracle 10.2.0.4 Logical Standby中報如下的資訊,然後有大量 LOGSTDBY Apply process P011 pid=79 OS id=9720 stopped 的資訊。
不知道什麼導致的 ?  後來stop sql apply , 重新開啟後正常 。  



LSP0: rolling back apply server 1   
LSP0: apply server 1 rolled back   
LSP0: can't recover from rollback of multi-chunk txn, aborting..





Thu Nov 19 14:50:40 2009  
RFS[1]: Archived Log: '/data1/mxdell/arch2/1_4201_702393373.arc'
Thu Nov 19 14:50:40 2009  
RFS LogMiner: Registered logfile [/data1/mxdell/arch2/1_4201_702393373.arc] to LogMiner session id [1]  
Thu Nov 19 14:50:40 2009  
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 4201, /data1/mxdell/arch2/1_4201_702393373.arc
Thu Nov 19 14:50:41 2009
LOGMINER: End mining logfile: /data1/mxdell/arch2/1_4201_702393373.arc
Thu Nov 19 14:51:35 2009
RFS[1]: Archived Log: '/data1/mxdell/arch2/1_4202_702393373.arc'
Thu Nov 19 14:51:35 2009
RFS LogMiner: Registered logfile [/data1/mxdell/arch2/1_4202_702393373.arc] to LogMiner session id [1]
Thu Nov 19 14:51:35 2009
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 4202, /data1/mxdell/arch2/1_4202_702393373.arc
Thu Nov 19 14:51:35 2009
Thread 1 advanced to log sequence 4392 (LGWR switch)
  Current log# 7 seq# 4392 mem# 0: /u01/product/oradata/mxdell/redo07.log
  Current log# 7 seq# 4392 mem# 1: /data1/mxdell/redo07b.log
Thu Nov 19 14:51:35 2009
LOGMINER: End mining logfile: /data1/mxdell/arch2/1_4202_702393373.arc
Thu Nov 19 14:51:48 2009  

LSP0: rolling back apply server 1   
LSP0: apply server 1 rolled back   
LSP0: can't recover from rollback of multi-chunk txn, aborting..

LOGSTDBY Analyzer process P003 pid=71 OS id=9704 stopped
LOGSTDBY Apply process P005 pid=73 OS id=9708 stopped
LOGSTDBY Apply process P009 pid=77 OS id=9716 stopped  
LOGSTDBY Apply process P014 pid=88 OS id=9726 stopped
LOGSTDBY Apply process P007 pid=75 OS id=9712 stopped
LOGSTDBY Apply process P011 pid=79 OS id=9720 stopped
LOGSTDBY Apply process P022 pid=97 OS id=9742 stopped
LOGSTDBY Apply process P019 pid=94 OS id=9736 stopped
LOGSTDBY Apply process P021 pid=96 OS id=9740 stopped
LOGSTDBY Apply process P010 pid=78 OS id=9718 stopped
LOGSTDBY Apply process P017 pid=92 OS id=9732 stopped
LOGSTDBY Apply process P008 pid=76 OS id=9714 stopped
LOGSTDBY Apply process P013 pid=87 OS id=9724 stopped
LOGSTDBY Apply process P016 pid=90 OS id=9730 stopped
LOGSTDBY Apply process P023 pid=98 OS id=9744 stopped
LOGSTDBY Apply process P015 pid=89 OS id=9728 stopped
LOGSTDBY Apply process P012 pid=86 OS id=9722 stopped
LOGSTDBY Apply process P018 pid=93 OS id=9734 stopped
LOGSTDBY Apply process P020 pid=95 OS id=9738 stopped
LOGSTDBY Apply process P006 pid=74 OS id=9710 stopped   
Thu Nov 19 14:51:48 2009
Thread 1 advanced to log sequence 4393 (LGWR switch)
  Current log# 4 seq# 4393 mem# 0: /u01/product/oradata/mxdell/redo04.log
  Current log# 4 seq# 4393 mem# 1: /data1/mxdell/redo04b.log
Thu Nov 19 14:51:49 2009
Thread 1 advanced to log sequence 4394 (LGWR switch)
  Current log# 5 seq# 4394 mem# 0: /u01/product/oradata/mxdell/redo05.log
  Current log# 5 seq# 4394 mem# 1: /data1/mxdell/redo05b.log
Thu Nov 19 14:51:51 2009
Thread 1 advanced to log sequence 4395 (LGWR switch)
  Current log# 1 seq# 4395 mem# 0: /data1/mxdell/redo01b.log
  Current log# 1 seq# 4395 mem# 1: /u01/product/oradata/mxdell/redo01.log
LOGSTDBY Apply process P011 pid=92 OS id=10744 stopped
Thu Nov 19 14:51:52 2009
Thread 1 advanced to log sequence 4396 (LGWR switch)
  Current log# 2 seq# 4396 mem# 0: /u01/product/oradata/mxdell/redo02.log
  Current log# 2 seq# 4396 mem# 1: /data1/mxdell/redo02b.log

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-620322/,如需轉載,請註明出處,否則將追究法律責任。

相關文章