故障现象: 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条带化到hdisk0hdisk1, 故障发生前从库刚刚进行过重启动作,重启后就出现如上错误。 怀疑是没有设置自动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未挂载
利用AIX条带化(STRIPE)优化数据库IOMySQL更新语句UPDATE深入探索相关资讯 AIX
- AIX上断开的NFS 挂载点 导致 (02/18/2015 09:27:04)
- 扩展AIX上的LV大小 (05/25/2014 07:30:14)
- AIX下做定时任务注意事项 (04/26/2014 10:46:52)
| - AIX HACMP系统错误--NODE同步配置 (08/06/2014 14:42:53)
- 使用Smitty进行AIX上Logical (05/03/2014 14:32:47)
- 断电导致的AIX上hacmp不能启动的问 (02/10/2014 19:49:10)
|
本文评论 查看全部评论 (0)