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
