鐩村埌浠婂ぉ锛屾垜鎵嶅紑濮嬫帴瑙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>
浜嬩欢鍏冩暟鎹繚鐣欏湪ADR涓粯璁や竴骞淬€?br> 浜嬩欢鏂囦欢鍜宒ump淇濈暀鍦ˋDR涓粯璁ゆ槸涓€涓湀銆?br>鍙互浣跨敤浜嬩欢package configuration鏇存敼杩欎簺淇濈暀绛栫暐銆傚悗鍙拌繘绋婱MON鑷姩娓呮礂杩囨湡鐨凙DR鏁版嵁銆?/div>
姣斿锛?/div>
INCIDENT_ID PROBLEM_KEY CREATE_TIME
------------ ------------------ ---------------------------
8801 ORA 600 [4899] 27-MAR-07 06.14.41.04-05:00
------------ ------------------ ---------------------------
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鐩綍涓嬫湁寰堝瀛愮洰褰曪細
/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>
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