故障现象: 1、主库日志报错 Sun Nov 27 12:31:34 2011 Errors in file /home/oracle/admin/zjtv/bdump/zjtv1_arc0_803242.trc: ORA-16055: FAL request rejected ARCH: FAL archive failed. Archiver continuing Sun Nov 27 12:31:34 2011 ORACLE Instance zjtv1 - Archival Error. Archiver continuing. Sun Nov 27 12:36:34 2011 Errors in file /home/oracle/admin/zjtv/bdump/zjtv1_arc2_709010.trc: ORA-00270: error creating archive log Sun Nov 27 12:36:34 2011 FAL[server, ARC2]: FAL archive failed, see trace file. 2、从库日志草错,显示归档文件没有权限创建 Sun Nov 27 13:26:59 2011 Errors in file /home/oracle/admin/standby/udump/standby_rfs_450640.trc: ORA-00270: error creating archive log /archivelog/arch_2_22493_614088933.arc ORA-19504: failed to create file "/archivelog/arch_2_22493_614088933.arc" ORA-27040: file create error, unable to create file IBM AIX RISC System/6000 Error: 13: Permission denied 故障分析: 该从库上周刚刚重新调整归档目录/archivelog条带化到hdisk0\hdisk1, 故障发生前从库刚刚进行过重启动作,重启后就出现如上错误。 怀疑是没有设置自动MOUNT,根据如下思路有如下具体排查经过: 1、首先查看目录是否存在 P560A:/archivelog#df -g Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/hd4 2.00 0.56 73% 2135 2% / /dev/hd2 4.00 1.66 59% 50260 12% /usr /dev/hd9var 1.00 0.27 74% 3219 5% /var /dev/hd3 10.00 5.62 44% 141687 10% /tmp /dev/hd1 1.00 0.54 47% 865 1% /home /proc - - - - - /proc /dev/hd10opt 2.00 1.53 24% 7221 2% /opt /dev/weblogiclv 10.00 9.47 6% 47 1% /weblogic /dev/weblogic9lv 10.00 1.85 82% 93440 18% /weblogic9 /dev/tsmdb 7.50 2.92 62% 7918 2% /tsmdb /dev/oraclelv 10.00 2.08 80% 27758 6% /home/oracle /dev/oradata_lv 300.00 138.46 54% 94 1% /oradata /dev/fslv00 150.00 26.45 83% 25 1% /backup 发现/archivelog未挂载 2、尝试挂载,出现错误 P560A:/#mount /archivelog mount: 0506-351 The log device and fs device must be in the same volume group. 显然原因是日志设备和你要挂载的文件系统不在一个卷组里 3、查看archive_lv在哪个VG上,结果是rootvg P560A:/archivelog#lslv archive_lv LOGICAL VOLUME: archive_lv VOLUME GROUP: rootvg LV IDENTIFIER: 00c3ee9e00004c000000011c74979ab0.16 PERMISSION: read/write VG STATE: active/complete LV STATE: opened/syncd TYPE: jfs2 WRITE VERIFY: off MAX LPs: 512 PP SIZE: 256 megabyte(s) COPIES: 1 SCHED POLICY: striped LPs: 400 PPs: 400 STALE PPs: 0 BB POLICY: relocatable INTER-POLICY: maximum RELOCATABLE: no INTRA-POLICY: middle UPPER BOUND: 2 MOUNT POINT: /archivelog LABEL: /archivelog MIRROR WRITE CONSISTENCY: on/ACTIVE EACH LP COPY ON A SEPARATE PV ?: yes (superstrict) Serialize IO ?: NO STRIPE WIDTH: 2 STRIPE SIZE: 128K P560A:/archivelog# 4、查看rootvg的日志设备jfs2log在hd8上 P560A:/archivelog#lsvg -l rootvg rootvg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT hd5 boot 1 2 2 closed/syncd N/A hd6 paging 32 64 2 open/syncd N/A hd8 jfs2log 1 2 2 open/syncd N/A hd4 jfs2 8 16 2 open/syncd / hd2 jfs2 16 32 2 open/syncd /usr hd9var jfs2 4 8 2 open/syncd /var hd3 jfs2 40 80 2 open/syncd /tmp hd1 jfs2 4 8 2 open/syncd /home hd10opt jfs2 8 16 2 open/syncd /opt lg_dumplv sysdump 8 8 1 open/syncd N/A fwdump jfs2 2 2 1 closed/syncd /var/adm/ras/platform oraclelv jfs2 40 40 1 open/syncd /home/oracle tsmdb jfs2 30 60 2 open/syncd /tsmdb archive_lv jfs2 400 400 2 closed/syncd /archivelog 5、查看/etc/filesystems文件的/archivelog的LOG属性在/dev/loglv00,而正常的应该是/dev/hd8 6、修改/archivelog的LOG属性 vi /etc/filesystems /oradata: dev = /dev/oradata_lv vfs = jfs2 log = /dev/loglv00 mount = true options = rw account = false /archivelog: dev = /dev/archive_lv vfs = jfs2 log = /dev/loglv00 --> hd8 mount = true options = rw account = false 7、mount成功 mount /archivelog 8、P560A:/archivelog#df -g发现已经挂载 Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/hd4 2.00 0.56 73% 2135 2% / /dev/hd2 4.00 1.66 59% 50260 12% /usr /dev/hd9var 1.00 0.27 74% 3219 5% /var /dev/hd3 10.00 5.62 44% 141687 10% /tmp /dev/hd1 1.00 0.54 47% 865 1% /home /proc - - - - - /proc /dev/hd10opt 2.00 1.53 24% 7221 2% /opt /dev/weblogiclv 10.00 9.47 6% 47 1% /weblogic /dev/weblogic9lv 10.00 1.85 82% 93440 18% /weblogic9 /dev/tsmdb 7.50 2.92 62% 7918 2% /tsmdb /dev/oraclelv 10.00 2.08 80% 27758 6% /home/oracle /dev/oradata_lv 300.00 138.46 54% 94 1% /oradata /dev/fslv00 150.00 26.45 83% 25 1% /backup /dev/archive_lv 100.00 80.91 20% 59 1% /archivelog
本文出自 “麦地坞” 博客,请务必保留此出处http://yunlongzheng.blog.51cto.com/788996/727219
以上是小编为您精心准备的的内容,在的博客、问答、公众号、人物、课程等栏目也有的相关内容,欢迎继续使用右上角搜索按钮进行搜索weblogic
, dev
, open
, home
, mount
archivelog
,以便于您获取更多的相关知识。
时间: 2024-10-31 16:40:05