Replicat 程序報 OGG-01091 錯誤 Abended,無法正常啟動,詳情如下:
GGSCI (cqstzjdbjc01) 3> view report RCQSTJC1
Source Context :
SourceModule : [ggapp.util.pcs]
SourceID :[/scratch/aime1/adestore/views/aime1_staxj16/oggcore/OpenSys/src/gglib/ggapp/pcsutl.c]
SourceFunction : [processCreateStatus(char *,process_file_handle_def *)]
SourceLine : [583]
2013-04-22 09:18:37 ERROR OGG-01091 Unable to open file"/goldengate/ggs/dirpcs/RCQSTJC1.pcr" (error 89, Invalid file systemcontrol data detected).
2013-04-22 09:18:37 ERROR OGG-01668 PROCESS ABENDING.
error 89, Invalid file system control datadetected 一般是指作業系統層面的錯誤,可以通過在該目錄下建立一個檔案來測試檔案系統是否完好。本例中 replicat 程序無法在/goldengate/ggs/dirpcs/ 目錄下建立RCQSTJC1.pcr 檔案而 abended。
cqstzjdbjc01:/home/oracle/ggs$cd /goldengate/ggs/dirpcs/
cqstzjdbjc01:/goldengate/ggs/dirpcs$ls
MGR.pcm
cqstzjdbjc01:/goldengate/ggs/dirpcs$touch1.pcr
touch: 0652-046 Cannot create1.pcr.
通過上面的報錯資訊、測試以及搜尋網絡上的相關錯誤,可以判斷應該是存放 ggs 執行個體的 /goldengate 檔案系統損壞,需要進行修複。
切換到 root 下,嘗試修複該檔案系統
cqstzjdbjc01:/goldengate/ggs/dirpcs$su-
root's Password:
cqstzjdbjc01:/$pwd
/
cqstzjdbjc01:/$df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 5.00 4.76 5% 10584 1% /
/dev/hd2 20.00 16.91 16% 55561 2% /usr
/dev/hd9var 10.00 9.59 5% 8446 1% /var
/dev/hd3 10.00 5.11 49% 3154 1% /tmp
/dev/hd1 10.00 3.77 63% 4077 1% /home
/dev/hd11admin 5.00 5.00 1% 5 1% /admin
/proc - - - - - /proc
/dev/hd10opt 10.00 9.62 4% 10829 1% /opt
/dev/livedump 0.50 0.50 1% 4 1% /var/adm/ras/livedump
/dev/fslv00 80.00 33.97 58% 188622 3% /u01
/dev/fslv01 199.00 198.41 1% 562 1% /goldengate
嘗試執行 fsck 修複/goldengate 檔案系統:
cqstzjdbjc01:/$fsck –y /goldengate
The current volume is:/dev/fslv01
File system is currentlymounted.
Primary superblock is valid.
fsck: Performing read-onlyprocessing does not produce dependable results.
*** Phase 1 - Initial inode scan
*** Phase 2 - Process remainingdirectories
*** Phase 3 - Process remainingfiles
*** Phase 4 - Check inodeallocation map
*** Phase 5 - Check blockallocation map
Filesystem is currently mounted.
fsck: Performing read-onlyprocessing does not produce dependable results.
cqstzjdbjc01:/$lsvg -
rootvg
ggvg
cqstzjdbjc01:/$lsvg -l ggvg
ggvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
loglv00 jfs2log 1 1 1 open/syncd N/A
fslv01 jfs2 796 796 1 open/syncd /goldengate
提示目前 /goldengate 檔案系統處于 mount 狀态,需先解除安裝 /goldengate 檔案系統才能執行 fsck 修複操作。
cqstzjdbjc01:/$umount /goldengate
umount: 0506-349 Cannot unmount/dev/fslv01: The requested resource is busy.
提示目前有程序正在占用 /goldengate 檔案系統的資源,找出正在使用 /goldengate 檔案系統的程序:
cqstzjdbjc01:/$fuser -kux /goldengate
/goldengate: 26411162c(oracle) 40894512c(oracle)61473164c(oracle)
殺掉該程序後嘗試重新解除安裝 /goldengate 檔案系統
cqstzjdbjc01:/$fuser -u/goldengate
/goldengate:
cqstzjdbjc01:/$umount/goldengate
cqstzjdbjc01:/$lsvg -l ggvg
ggvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
loglv00 jfs2log 1 1 1 closed/syncd N/A
fslv01 jfs2 796 796 1 closed/syncd /goldengate
執行 fsck 修複/goldengate 檔案系統
cqstzjdbjc01:/$fsck -y /goldengate
The current volume is:/dev/fslv01
Primary superblock is valid.
J2_LOGREDO:log redo processingfor /dev/fslv01
Primary superblock is valid.
*** Phase 1 - Initial inodescan
*** Phase 2 - Process remainingdirectories
*** Phase 3 - Process remainingfiles
*** Phase 4 - Check and repairinode allocation map
*** Phase 5 - Check and repairblock allocation map
File system is clean.
Superblock is marked dirty(FIXED)
All observed inconsistencieshave been repaired.
修複完成後,重新挂載 /goldengate 檔案系統
cqstzjdbjc01:/$df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 5.00 4.76 5% 10584 1% /
/dev/hd2 20.00 16.91 16% 55561 2% /usr
/dev/hd9var 10.00 9.59 5% 8446 1% /var
/dev/hd3 10.00 5.11 49% 3152 1% /tmp
/dev/hd1 10.00 3.77 63% 4077 1% /home
/dev/hd11admin 5.00 5.00 1% 5 1% /admin
/proc - - - - - /proc
/dev/hd10opt 10.00 9.62 4% 10829 1% /opt
/dev/livedump 0.50 0.50 1% 4 1% /var/adm/ras/livedump
/dev/fslv00 80.00 33.97 58% 188672 3% /u01
cqstzjdbjc01:/$mount
node mounted mounted over vfs date options
-------- --------------- --------------- ------ ------------ ---------------
/dev/hd4 / jfs2 Feb 01 16:51 rw,log=/dev/hd8
/dev/hd2 /usr jfs2 Feb 01 16:51 rw,log=/dev/hd8
/dev/hd9var /var jfs2 Feb 01 16:51 rw,log=/dev/hd8
/dev/hd3 /tmp jfs2 Feb 01 16:51 rw,log=/dev/hd8
/dev/hd1 /home jfs2 Feb 01 16:52 rw,log=/dev/hd8
/dev/hd11admin /admin jfs2 Feb 01 16:52 rw,log=/dev/hd8
/proc /proc procfs Feb 01 16:52 rw
/dev/hd10opt /opt jfs2 Feb 01 16:52 rw,log=/dev/hd8
/dev/livedump /var/adm/ras/livedump jfs2 Feb 01 16:52 rw,log=/dev/hd8
/dev/fslv00 /u01 jfs2 Feb 01 16:52 rw,log=/dev/hd8
cqstzjdbjc01:/$mount /goldengate
cqstzjdbjc01:/$df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 5.00 4.76 5% 10584 1% /
/dev/hd2 20.00 16.91 16% 55561 2% /usr
/dev/hd9var 10.00 9.59 5% 8446 1% /var
/dev/hd3 10.00 5.11 49% 3152 1% /tmp
/dev/hd1 10.00 3.77 63% 4077 1% /home
/dev/hd11admin 5.00 5.00 1% 5 1% /admin
/proc - - - - - /proc
/dev/hd10opt 10.00 9.62 4% 10829 1% /opt
/dev/livedump 0.50 0.50 1% 4 1% /var/adm/ras/livedump
/dev/fslv00 80.00 33.97 58% 188605 3% /u01
/dev/fslv01 199.00 198.41 1% 563 1% /goldengate
再次嘗試在該目錄下touch檔案,執行成功。
cqstzjdbjc01:/home/oracle/ggs$cd /goldengate/ggs/dirpcs/
cqstzjdbjc01:/goldengate/ggs/dirpcs$touch1.pcr
這時便可以成功啟動該 replicat 程序了。
轉載請注明作者出處及原文連結:
http://blog.csdn.net/xiangsir/article/details/8837198