LSP0: rolling back apply server 1 是做什麼 ?
發現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
不知道什麼導致的 ? 後來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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Java是什麼_Java是做什麼的?Java
- 什麼是Web serverWebServer
- 什麼是Web ServerWebServer
- JavaEE是做什麼的?Java
- history.go()和history.back()的區別是什麼Go
- heredoc是什麼?它能為PHP做什麼?PHP
- 例項恢復(Instance Recovery)之前滾(Rolling Forward)和回滾(Rolling Back)Forward
- 運維工程師是什麼?做什麼?運維工程師
- 科普遊戲:是什麼?怎樣做?遊戲
- 區塊鏈是做什麼的?區塊鏈
- Docker(1)- 什麼是 DockerDocker
- 1、AngularJS是什麼?AngularJS
- 什麼是大資料?大資料開發是做什麼的?大資料
- 什麼是資料運營?資料運營是做什麼的?
- Kali Linux是什麼?可以用來做什麼?Linux
- 機器學習可解釋性系列 - 是什麼&為什麼&怎麼做機器學習
- 網路交換機是做什麼的
- 技術長:CTO是做什麼的
- 在 Google 做實習生是什麼樣的Go
- 第 38 題:apply、call 和 bind 是什麼?哪些區別?APP
- 伺服器遷移中心SMC是什麼?SMC是做什麼用的伺服器
- 什麼是web前端?前端可以做什麼?html5有什麼用?Web前端HTML
- Java到底是什麼?學習java可以做什麼呢?Java
- SVN管理是什麼?SVN安裝教程,SVN可以做什麼
- 為什麼 call 比 apply 快?APP
- web前端是做什麼的?UI設計又是做什麼的?看完別選錯行!Web前端UI
- 技術美術師是做什麼的?
- 物聯網路卡是做什麼用的
- 軟體開發是什麼、如何做
- ASM Buffer Cache是用來做什麼的!ASM
- IO優化是怎麼做的,使用 SharedPreferences為什麼這麼卡,mmkv原理是什麼優化
- 新媒體運營工作是什麼?新媒體運營是做什麼的?
- webgl入門(1)-什麼是webglWeb
- 什麼是 T+1 資料?
- SRE工程師到底是做什麼的?工程師
- 精益管理顧問是做什麼的工作?
- 做網站的"伺服器"是什麼意思?網站伺服器
- Web前端是做什麼的?就業前景如何?Web前端就業