Oracle 通過ADR工具 收集ORA-600錯誤資訊

 問題描述：

2014-06-10 在點檢資料庫預警檔案時，出現Ora -00600 錯誤，並且Rman L1 備份失敗，查詢相關資料，得知是Bug:9835218。於是，提SR尋求Oracle 官方支援人員。

Oracle回複如下:

Your Service Request has been submitted as anORA-600/ORA-7445 issue based on the problem type you chose when logging the SR. 

Additional diagnostic data is needed. 
Execute the action plan described in [Doc ID1638904.1] "ORA-600 / ORA-7445: Checklist of Evidence to Supply" andupload the collected information to ensure rapid resolution. 

If this information was already provided at SRcreation, please ignore this action request. 

The SR will be assigned to a technicalengineer after: 

1. The requested information is provided 
OR 
2. Your Service Request is updated asking forreview and assignment 

The engineer will need the diagnostic data toproceed with resolution steps even if assignment is requested. 

If you receive a notification that this SR hasbeen updated, un-check the "Hide System Messages" box to seeadditional information. 

參考文檔:  Doc ID1638904.1 和Note:443529.1

Oracle 要求收集相關異常資料，並上傳到sr,現將收集過程介紹如下：以便大家在遇到同樣問題時，作為參考：1.異常資料收集ADR 路徑

查看參數: diagnostic_dest   +diag/<product_type>/<prod_id>/<instance_id>. 

也可以查詢檢視: V$DIAG_INFO:

執行過程:輸入adrci$ adrci

ADRCI:Release 11.2.0.3.0 - Production on Thu Jun 12 09:52:25 2014

Copyright(c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

ADR base= "/u01/app/oracle"

adrci>

查看$ORACLE_BASE

adrci> show home
--show home willlist all the ADR homes. Set the proper database ADR home for use with ADRCI.
adrci> sethomepath database_home

查看問題：

adrci> show problem

 

ADR Home =/u01/app/oracle/diag/rdbms/XXXdb/XXXDB2:

*************************************************************************

PROBLEM_ID           PROBLEM_KEY                                                LAST_INCIDENT        LASTINC_TIME                            

-------------------- ------------------------------------------------------------------------------- ----------------------------------------

1                    ORA 7445[lsfcln2()+52]                                    161345               2013-04-3014:02:25.311000 +08:00      

2                    ORA 7445 [kkqstfppu()+150]                                  311712               2014-02-19 09:11:17.274000+08:00      

3                    ORA 7445[qecinisub()+50]                                   311344               2014-03-03 17:31:50.828000+08:00      

4                    ORA 600 [krbbsThrottle_zero_total_size]                   453579               2014-06-1009:57:18.828000 +08:00      

4 rows fetched

 

adrci>

分析問題

Checkfor the incidents reported for the problem which needs to be packaged

Each occurrence of the problem is called an 'incident'. The instance alert filewill show all the incidents reported. Each incident will be associated with aunique incident id in the ADR.

From the ADRCI prompt, execute the SHOW INCIDENT command forthe problem to be investigated, by specifying the associated problem key. Youcan get the problem key from the SHOW PROBLEM command:

adrci> showincident -p "problem_key='ORA 1578'"

ADR Home = /opt/oracle/diag/rdbms/db11g/db11g:
*************************************************************************
INCIDENT_ID     PROBLEM_KEY              CREATE_TIME
--------------- ------------------------ ----------------------------------
18147           ORA1578                 2009-06-0122:02:08.805002 +10:00
1 rows fetched

打包trace 檔案

Packagethe trace files invoking IPS.

Generate the package using the IPS PACK command and store thegenerated package in a directory of your choice. The example below shows thepackage for the incident will be created in the /tmp directory.

adrci> ips pack incident 18147 in /tmp
Generated package 9 in file /tmp/ORA1578_20090602113045_COM_1.zip, modecomplete

上傳到Oracle Support尋求解決方案