RAC日志不轮循清理Bug解决方案
问题背景：
临近春节，对DB进行全方位巡检，发现在节点一GRID日志/u01/11.2.0/grid/log/mgr-rac1/alert_rac1.log内容几乎为如下内容系统版本：Oracle Linux 6.5 64-bit (3.8.13-16.2.1.el6uek.x86 64)
RAC DB版本：11.2.0.4标准版
节点一 GRID 日志信息
-
2016-01-20 08:50:37.490:
[client(60326)]CRS-0009:log file "/u01/11.2.0/grid/log/rac1/client/olsnodes.log" reopened
2016-01-20 08:50:37.490:
[client(60326)]CRS-0019:file rotation terminated. log file: "/u01/11.2.0/grid/log/rac1/client/olsnodes.log"
2016-01-20 08:55:37.526:
[client(60928)]CRS-0014:An error occurred while attempting to delete file "/u01/11.2.0/grid/log/rac1/client/olsnodes.l03" during log file rotation. Additional diagnostics: LFI-00142: Unable to delete an existing file [olsnodes][l03] not owned by Oracle.
2016-01-20 08:55:37.526:
[client(60928)]CRS-0009:log file "/u01/11.2.0/grid/log/rac1/client/olsnodes.log" reopened
2016-01-20 08:55:37.526:
[client(60928)]CRS-0019:file rotation terminated. log file: "/u01/11.2.0/grid/log/rac1/client/olsnodes.log" -
2016-01-20 09:00:37.526:
-
[client(60928)]CRS-0014:An error occurred while attempting to delete file "/u01/11.2.0/grid/log/rac1/client/olsnodes.l03" during log file rotation. Additional diagnostics: LFI-00142: Unable to delete an existing file [olsnodes][l03] not owned by Oracle.
......
之后进入目录/u01/11.2.0/grid/log/rac1/client发现olsnodes.log生成的“归档日志”为如下：
-rw-rw-rw- 1 root root 14M Jan 20 09:15 olsnodes.l01
-rw-rw-rw- 1 root root 14M Jan 20 09:15 olsnodes.l02
-rw-rw-rw- 1 grid oinstall 10M Jan 20 09:15 olsnodes.l03
-rw-rw-rw- 1 root root 15M Jan 20 16:25 olsnodes.log
可以发现因为权限问题导致RAC日志不能轮循清理，这可能是BUG_9595783导致的，后来发现节点二也有这个情况，因为刚好有down time，所以采取如下解决方案：
--节点一
[root@rac1 ~]# cd /u01/11.2.0/grid/bin
[root@rac1 bin]# ./crsctl stop crs
[root@rac1 ~]# cd /u01/11.2.0/grid/log/rac1/client
[root@rac1 client]#chown root:root olsnodes.l03
[root@rac1 client]# cd /u01/11.2.0/grid/bin
[root@rac1 bin]# ./crsctl start crs
--节点二
[root@rac2 ~]# cd /u01/11.2.0/grid/bin
[root@rac2 bin]# ./crsctl stop crs
[root@rac2 ~]# cd /u01/11.2.0/grid/log/rac2/client
[root@rac2 client]#chown root:root olsnodes.l03
[root@rac2 client]# cd /u01/11.2.0/grid/bin
[root@rac2 bin]# ./crsctl start crs
参考：http://www.th7.cn/db/Oracle/201505/104375.shtml
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30220976/viewspace-1979676/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
记一次RAC节点连接共享存储失败重启问题
下一篇：
innobackupex的备份和恢复
请登录后发表评论
登录
全部评论
