RAC
调试中的一个黄金规则
1.请始终确保各个节点具有完全相同的
系统时间,这样才能实现以下目标:
– 便于进行
日志信息分析 – 确保读取 GV$
视图时获得准确结果
– 避免
实例被过早逐出
2. 最好的
建议是使用
网络时间协议对各节点进行
同步。
Oracle Clusterware 主要日志
文件
诊断收集脚本
1.用于收集所有重要日志文件的脚本应满足以下条件:
– 必须以 root 身份执行
– 位于 $ORA_CRS_HOME/bin/ 中
– 名为 diagcollection.pl
2.将在本地目录中生成以下文件:
– basData_.tar.gz
- coreData_.tar.gz
– crsData _. tar.gz
– ocrData _. tar.gz
– oraData _. 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 JS的BDD/TDD诊断库 Chai
iis7站长之家 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.ht
m#i632140