诊断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