日期:2014-05-16  浏览次数:20365 次

ORACLE 11G涓殑ADR浠嬬粛锛?
鐩村埌浠婂ぉ锛屾垜鎵嶅紑濮嬫帴瑙racle 11g锛屽厛浜嗚В鍏舵柊鐗规€э紝浠ヤ笅杩欎簺鏄垜鐨勬柊鐗规€ц涔︾瑪璁帮細
绗竴閮ㄥ垎锛?/span>(Automatic Diagnostic Repository)ADR
鍦╫racle 11g涓紝浣犱笉鑳藉湪鐩綍$ORACLE_BASE/diag/rdbms/$INSTANCE_NAME/$ORACLE_SID/alert涓洿鎺ヨ鍙朼lert鏃ュ織銆傝€屾槸璇诲彇鍏朵腑鐨刲og.xml鏂囦欢銆傝鏂囦欢涓嶆槸鏂囨湰鏂囦欢銆傞櫎浜嗘墍鏈夋爣鍑嗙殑鏁版嵁搴撴搷浣滀俊鎭锛宎lert鏃ュ織閲屼篃鍖呭惈鍏充簬浜嬩欢鐨勪俊鎭€備綘涔熷彲浠ヤ粠鐩綍 $ORACLE_BASE/diag/rdbms/$INSTANCE_NAME/$ORACLE_SID/trace涓鍙栦互鍓嶇増鏈殑alert鏃ュ織銆?/div>

problems鍜宨ncidents 锛堥棶棰樺拰浜嬩欢锛?/strong>

鍥寸粫鐫€oracle 11g閿欒璇婃柇缁撴瀯鏈変袱绉嶆柊鐨勬蹇碉細problems鍜宨ncidents銆?/div>
problems锛?/div>
浠讳綍涓ラ噸閿欒绉颁箣涓簆roblems锛屾瘮濡侽RA-600閿欒锛孫RA-04031閿欒銆傛墍鏈夋秹鍙婃暟鎹簱problems鐨勬簮鏁版嵁閮藉瓨鍌ㄥ湪ADR涓€傛瘡涓€涓棶棰樺垎閰嶄竴涓叧閿瓧锛屼互渚夸簬鏍囪瘑鍜屾弿杩伴棶棰樸€傞棶棰樺叧閿瓧鍖呮嫭oracle閿欒鍙峰拰閿欒鍙橀噺鍊笺€?/div>
incidents锛?/div>
鏄竴娆¢棶棰樼殑浜х敓銆備竴涓棶棰樺彲鑳戒細浜х敓澶氭銆傛瘡涓€娆″氨鏄竴涓簨浠躲€傛瘡涓簨浠舵湁瀹冭嚜宸辩殑浜嬩欢ID.
姣斿锛?/div>
INCIDENT_ID PROBLEM_KEY CREATE_TIME
------------ ------------------ ---------------------------
8801 ORA 600 [4899] 27-MAR-07 06.14.41.04-05:00

褰撴煇涓€涓簨浠朵骇鐢熸椂銆傚湪鏁版嵁搴撻噷鍋氫笁浠朵簨鎯咃細

  • 涓鸿浜嬩欢鍒涘缓涓€涓憡璀︽棩蹇楄骞跺垎閰嶅悎閫傚畨鍏ㄥ憡璀︺€?/li>
  • 鍦╝lert鏃ュ織閲屽垱寤虹浉鍏虫潯鐩€?/li>
  • 鏀堕泦鍜屽瓨鍌ㄨ瘖鏂暟鎹斁缃湪ADR缁撴瀯涓悎閫傚瓙鐩綍涓€?/li>

涓嶈兘澶熺姝㈣嚜鍔ㄥ垱寤轰弗閲嶉敊璇簨浠躲€?/p>

浜嬩欢鍦ˋDR涓湁淇濈暀绛栫暐:

浜嬩欢鍏冩暟鎹繚鐣欏湪ADR涓粯璁や竴骞淬€?br> 浜嬩欢鏂囦欢鍜宒ump淇濈暀鍦ˋDR涓粯璁ゆ槸涓€涓湀銆?br>鍙互浣跨敤浜嬩欢package configuration鏇存敼杩欎簺淇濈暀绛栫暐銆傚悗鍙拌繘绋婱MON鑷姩娓呮礂杩囨湡鐨凙DR鏁版嵁銆?/div>

incident packaging service锛?br>

鍦╫racle 11g涓紝浣犲彲浠ヤ娇鐢↖PS鏉ユ悳瀵诲叧浜庢煇涓€涓簨浠舵垨閿欒鐨勭浉鍏硉race file锛宒ump file鍜屽憡璀︽棩蹇楀苟灏嗗叾鎵撳寘鎴愬帇缂╂枃浠躲€?br>杩欎釜鐗规€хО涔嬩负锛坕ncident packaging service锛塈PS銆?/p>

ADR鐨勭粨鏋勫拰浣嶇疆锛?/strong>
鍒濆鍖栧弬鏁癲iagnostic_dest鎸囧畾浜咥DR鐨勬牴鐩綍銆傚嵆浣夸綘蹇界暐浜嗚鍒濆鍖栧弬鏁般€俹racle涔熶細鍒涘缓ADR銆?br>濡傛灉浣犺缃簡ORACLE_BASE鐜鍙橀噺锛岄偅涔坉iagnostic_dest缂虹渷鍊兼槸璇ョ洰褰曘€傚鏋滀綘娌℃湁璁剧疆ORACLE_BASE鍙橀噺锛岃鍙傛暟鍊间负$ORACLE_HOME/log鐩綍銆?br> ADR瀛樺偍鎵€鏈塷racle浜у搧鐨勮瘖鏂暟鎹€侫DR涓烘瘡涓€涓猳racle浜у搧鍙婂叾瀹炰緥鍒嗛厤涓€涓崟鐙殑home鐩綍銆傚洜姝や竴涓狝DR鐩綍鍖呭惈澶氫釜home鐩綍銆?br> 姣忎竴涓狝DR鐨刪ome鐩綍鏄竴涓负姣忎竴涓暟鎹簱瀹炰緥鎴栧叾瀹僶racle浜у搧鎴栫粍浠跺瓨鍌ㄥ叾璇婃柇鏂囦欢銆傚叾鐩綍缁撴瀯濡備笅锛?/div>
ADR_base/diag/product_type/product_id/instance_id/
姣斿涓€涓?diagnostic_dest鍒濆鍖栧弬鏁颁负 /u05/app/oracle銆傞偅涔堜竴涓猳racle鏁版嵁搴撶殑sid涓簆rod1鐨刪ome鐩綍灏卞涓嬫墍绀猴細
/u05/app/oracle/diag/rdbms/prod1/prod1/
鍦ㄤ竴涓狝DR鐨刪ome鐩綍涓嬫湁寰堝瀛愮洰褰曪細
  • alert锛氫竴涓疄渚嬬殑鍛婅鏃ュ織鏂囦欢锛坸ml鏍煎紡锛夈€?/li>
  • cdump锛歝ore鏂囦欢銆?/li>
  • hm锛氬仴搴锋鏌ユ姤鍛娿€?/li>
  • incident锛氭瘡涓€涓簨浠朵竴涓瓙鐩綍锛屽叾涓寘鍚墍鏈塼race dump鏂囦欢銆?/li>
  • incpkg锛氫綘鍒涘缓鐨勪簨浠跺寘锛岀敤浜庡彂缁檕racle鏀寔鎵€鐢ㄣ€?/li>
  • ir锛氬寘鍚疄渚嬩簨浠舵姤鍛娿€?/li>
  • trace锛氬瓨鍌ㄥ洖璇漷race鏂囦欢銆?br>鍙互閫氳繃瑙嗗浘v$diag_info鏉ユ煡璇㈢洰褰曞強鍏朵綅缃細
    SQL> select name, value from v$diag_info;
    NAME VALUE
    ------------------- ---------------------------
    Diag Enabled TRUE
    ADR Base /u01/app/oracle
    ADR Home /01/app/oracle/diag/rdbms/prod/prod1
    Diag Trace /u01/app/oracle/diag/rdbms/prod/prod1/trace
    Diag Alert /u01/app/oracle/diag/rdbms/ prod/prod1/alert
    Diag Incident /u01/app/oracle/diag/rdbms/prod/prod1/incident
    Diag Cdump /u01/app/oracle/diag/rdbms/ prod/prod1/cdump
    Health Monitor /u01/app/oracle/diag/rdbms/ prod/prod1/hm
    Default Trace File /u01/app/oracle/diag/rdbms/ prod/prod1/
    trace/eleven_ora_9417.trc
    Active Problem Count 3
    Active Incident Count 8
姝e浣犳墍瑙侊紝瑙嗗浘v$diag_info涓寘鎷棶棰樺拰浜嬩欢鏁伴噺銆?/div>
adrci鎺ュ彛锛?/strong>
oracle涓烘垜浠彁渚涗簡涓€涓寲鎺楢DR閲岀殑璇婃柇鏁版嵁鐨勬帴鍙o紝鍙玜drci銆傝繖涓懡浠よ宸ュ叿鎻愪緵寰堝涓板瘜鐨勫姛鑳斤紝姣斿灏嗛棶棰樺拰浜嬩欢鎵撳寘涓轰竴涓獄ip鏂囦欢鍙戠粰oracle鎶€鏈敮鎸併€傝繖浜涜鍘嬬缉鐨勮瘖鏂暟鎹寘鎷瑃race鍙奷ump鏂囦欢锛宎lert log鏉$洰浠ュ強oracle 11g鐨勫仴搴风洃瑙嗘姤鍛娿€傚彲浠ヤ娇鐢╝drci鐨勪氦浜掓ā寮忔垨浣跨敤鎿嶄綔绯荤粺鐨勮剼鏈壒澶勭悊鎵ц杩欎簺鍛戒护銆?/div>
鍦╫racle鐢ㄦ埛鎵цadrci
[oracle@node1 ~]$ adrci
ADRCI: Release 11.1.0.6.0 - Beta on Thu Apr 5 09:23:37 2012
Copyright (c) 1