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