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 日志信息

1. 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"
2. 2016-01-20 09:00:37.526: 
   
3. [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博客 ” ，链接：http://blog.itpub.net/30220976/viewspace-1979676/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30220976/viewspace-1979676/