诊断Oracle Clusterware和RAC组件

诊断Oracle Clusterware和RAC组件

RAC 调试中的一个黄金规则  
1.请始终确保各个节点具有完全相同的系统时间，这样才能实现以下目标：  
 – 便于进行日志信息分析  
 – 确保读取 GV$ 视图时获得准确结果  
 – 避免实例被过早逐出  
2. 最好的建议是使用网络时间协议对各节点进行同步。  

Oracle Clusterware 主要日志文件

诊断收集脚本  
1.用于收集所有重要日志文件的脚本应满足以下条件：  
 – 必须以 root 身份执行  
 – 位于 $ORA_CRS_HOME/bin/ 中  
 – 名为 diagcollection.pl  
2.将在本地目录中生成以下文件：  
 – basData_<hostname>.tar.gz
 - coreData_<hostname>.tar.gz
 – crsData _<hostname>. tar.gz
 – ocrData _<hostname>. tar.gz  
 – oraData _<hostname>. tar.gz  
 

示例：

root@rac1 /oracle/backup$ /u01/crs1020/bin/diagcollection.pl -collect
Production Copyright 2004, 2005, Oracle.  All rights reserved
Cluster Ready Services (CRS) diagnostic collection tool
The following CRS diagnostic archives will be created in the local directory.
crsData_rac1.gz -> logs,traces and cores from CRS home
ocrData_rac1.gz -> ocrdump, ocrcheck etc
coreData_rac1.gz -> contents of CRS core files in text format

Collecting crs data
/bin/tar: Removing leading `/' from member names
Collecting OCR data
Collecting information from core files
/usr/bin/gdb: option `--bat' is ambiguous
Use `/usr/bin/gdb --help' for a complete list of options.
/usr/bin/gdb: option `--bat' is ambiguous
Use `/usr/bin/gdb --help' for a complete list of options.
/usr/bin/gdb: option `--bat' is ambiguous
Use `/usr/bin/gdb --help' for a complete list of options.
/usr/bin/gdb: option `--bat' is ambiguous
Use `/usr/bin/gdb --help' for a complete list of options.
/usr/bin/gdb: option `--bat' is ambiguous
Use `/usr/bin/gdb --help' for a complete list of options.
The following Oracle Home diagnostic archives will be created in the local directory.
oraData_rac1.gz -> logs, traces and cores from Oracle Home
Collecting oracle home data
/bin/tar: Removing leading `/' from member names
/bin/tar: /u01/app/oracle/product/10.2.0/db_1/admin/*: Cannot stat: No such file or directory
/bin/tar: Error exit delayed from previous errors
The following Oracle Base diagnostic archives will be created in the local directory.
basData_rac1.gz -> logs,traces from Oracle base
Collecting oracle base data
/bin/tar: Removing leading `/' from member names
root@rac1 /oracle/backup$ ll | grep tar
-rw-r--r-- 1 root   root      13233982 Feb 28 22:37 basData_rac1.tar.gz
-rw-r--r-- 1 root   root           232 Feb 28 22:36 coreData_rac1.tar.gz
-rw-r--r-- 1 root   root      40923089 Feb 28 22:35 crsData_rac1.tar.gz
-rw-r--r-- 1 root   root          7921 Feb 28 22:36 ocrData_rac1.tar.gz
-rw-r--r-- 1 root   root        164183 Feb 28 22:36 oraData_rac1.tar.gz

集群诊断与集群验证详细可以参考 ：
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide ->A Troubleshooting
http://docs.oracle.com/cd/B19306_01/rac.102/b14197/appsupport.htm#i632140