oracle rac 問(wèn)題解決

創(chuàng)新互聯(lián)建站是一家專(zhuān)業(yè)提供周至企業(yè)網(wǎng)站建設(shè),專(zhuān)注與成都做網(wǎng)站、成都網(wǎng)站制作、成都h5網(wǎng)站建設(shè)、小程序制作等業(yè)務(wù)。10年已為周至眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專(zhuān)業(yè)網(wǎng)站建設(shè)公司優(yōu)惠進(jìn)行中。

1查看相關(guān)日志

[root@rac1 rac1]# pwd

/u01/app/grid/11.2.0/log/rac1

[root@rac1 rac1]# ls

acfs acfsrepl acfssec agentclientcrfmondcssdcvuevmd gnsd mDNSdracg

acfslog acfsreplrootadmin alertrac1.log crflogdcrsd ctssd diskmon gipcd gpnpd ohasd srvm

admin=> 記錄一些概要信息 

alertgnd-rac01.log=>記錄節(jié)點(diǎn)crs狀態(tài)變化時(shí)候的一些概要信息，詳細(xì)還是要看css log 

client=>記錄crs初始化，ocr application including: CLSCFG, CSS, OCRCHECK, OCRCONFIG, OCRDUMP and OIFCFG 

crsd=>記錄crsd的相關(guān)日志，crs等待css進(jìn)入fatal模式后，啟動(dòng)crsd然后啟動(dòng)相關(guān)的resource 

cssd=>記錄cssd的相關(guān)日志，節(jié)點(diǎn)停止，啟動(dòng)，reconfig等，所有問(wèn)題都會(huì)記錄，最重要的日志 

evmd=>記錄evmd的日志 

racg=>記錄ons，vip的相關(guān)日志 

2. 在Oracle集群環(huán)境的"$ORA_CRS_HOME/bin"目錄下提供了diagcollection.pl腳本，以root用戶(hù)身份執(zhí)行該腳本便可以完成搜集必要的診斷信息的目的。

執(zhí)行采集腳本diagcollection.pl

[root@rac1 ~]# cd $ORA_CRS_HOME/bin

[root@rac1 bin]# ./diagcollection.pl --help

Production Copyright 2004, 2010, Oracle. All rights reserved

Cluster Ready Services (CRS) diagnostic collection tool

diagcollection

--collect

[--crs] For collecting crs diagnostic information

[--adr] For collecting diagnostic information for ADR; specify ADR location

[--chmos] For collecting Cluster Health Monitor (OS) data

[--acfs] Unix only. For collecting ACFS diagnostic information

[--all] Default.For collecting all diagnostic information.

[--core] UNIX only. Package core files with CRS data

[--afterdate] UNIX only. Collects archives from the specified date. Specify in mm/dd/yyyy format

[--aftertime] Supported with -adr option. Collects archives after the specified time. Specify in YYYYMMDDHHMISS24 format

[--beforetime] Supported with -adr option. Collects archives before the specified date. Specify in YYYYMMDDHHMISS24 format

[--crshome] Argument that specifies the CRS Home location

[--incidenttime] Collects Cluster Health Monitor (OS) data from the specified time. Specify in MM/DD/YYYYHH24:MM:SS format

If not specified, Cluster Health Monitor (OS) data generated in the past 24 hours are collected

[--incidentduration] Collects Cluster Health Monitor (OS) data for the duration after the specified time. Specify in HH:MM format.

If not specified, all Cluster Health Monitor (OS) data after incidenttime are collected

NOTE:

1. You can also do the following

./diagcollection.pl --collect --crs --crshome

--clean cleans up the diagnosability

information gathered by this script

--coreanalyze UNIX only. Extracts information from core files

and stores it in a text file

[root@rac1 bin]# ./diagcollection.pl --collect --all --crshome $ORA_CRS_HOME

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.tar.gz -> logs,traces and cores from CRS home. Note: core files will be packaged only with the -core option.

ocrData_rac1.tar.gz -> ocrdump, ocrcheck etc

coreData_rac1.tar.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

No corefiles found

The following Oracle Home diagnostic archives will be created in the local directory.

oraData_rac1.tar.gz -> logs, traces and cores from Oracle Home

Collecting oracle home data

/bin/tar: Removing leading `/' from member names

本次生成的打包文件如下：

[root@rac1 bin]# ls -l *tar.gz

-rw-r--r-- 1 root root 138 Nov 18 22:38 coreData_rac1.tar.gz

-rw-r--r-- 1 root root 234507 Nov 18 22:38 crsData_rac1.tar.gz

-rw-r--r-- 1 root root 8000 Nov 18 22:38 ocrData_rac1.tar.gz

-rw-r--r-- 1 root root 81851 Nov 18 22:38 oraData_rac1.tar.gz

使用Oracle提供的diagcollection.pl腳本可以很方便的對(duì)診斷信息進(jìn)行批量打包。簡(jiǎn)化了采集故障信息的繁瑣流程。

如需要將診斷信息提交給Oracle技術(shù)支持人員，使用該方法效率會(huì)比較高效。

3.使用cluvfy工具

[grid@rac1 ~]$ cluvfy -help

USAGE:

cluvfy [-help|-version]

cluvfy stage {-list|-help}

cluvfy stage {-pre|-post} [-verbose]

cluvfy comp {-list|-help}

cluvfy comp [-verbose]

例如

[grid@rac1 ~]$ cluvfy comp crs -n all -verbose

Verifying CRS integrity

Checking CRS integrity...

Clusterware version consistency passed

The Oracle Clusterware is healthy on node "rac2"

The Oracle Clusterware is healthy on node "rac1"

CRS integrity check passed

Verification of CRS integrity was successful.

分享名稱(chēng)：oraclerac問(wèn)題解決
本文鏈接：http://sd-ha.com/article10/jossdo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站策劃、關(guān)鍵詞優(yōu)化、網(wǎng)站收錄、企業(yè)建站、Google、手機(jī)網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)