rdbms/galt/galt:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ------------------------ ----------------------------------------
129708 ORA 4030 2014-06-21 05:35:06.727000 +08:00
129709 ORA 4030 2014-06-21 05:35:15.598000 +08:00
129710 ORA 4030 2014-06-21 05:35:23.600000 +08:00
129711 ORA 4030 2014-06-21 05:35:31.526000 +08:00
129712 ORA 4030 2014-06-21 05:35:39.611000 +08:00
5 rows fetched
可以看到这里有5次INCIDENT，可以用如下命令查看具体的信息：
adrci> show incident -mode DETAIL -p "incident_id=129708";
ADR Home = /home/oracle/diag/tnslsnr/riserver2/listener:
*************************************************************************
0 rows fetched
ADR Home = /home/oracle/diag/rdbms/galt/galt:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 129708
STATUS ready
CREATE_TIME 2014-06-21 05:35:06.727000 +08:00
PROBLEM_ID 1
CLOSE_TIME
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 4030
ERROR_ARG1 832
ERROR_ARG2 callheap
ERROR_ARG3 temporary memory
ERROR_ARG4
ERROR_ARG5
ERROR_ARG6
ERROR_ARG7
ERROR_ARG8
ERROR_ARG9
ERROR_ARG10
ERROR_ARG11
ERROR_ARG12
SIGNALLING_COMPONENT
SIGNALLING_SUBCOMPONENT
SUSPECT_COMPONENT
SUSPECT_SUBCOMPONENT
ECID
IMPACTS 0
PROBLEM_KEY ORA 4030
FIRST_INCIDENT 129708
FIRSTINC_TIME 2014-06-21 05:35:06.727000 +08:00
LAST_INCIDENT 129757
LASTINC_TIME 2014-06-21 05:35:52.409000 +08:00
IMPACT1 34668547
IMPACT2 34668546
IMPACT3 0
IMPACT4 0
KEY_NAME ProcId
KEY_VALUE 2.1
KEY_NAME Client ProcId
KEY_VALUE oracle@riserver2.3005_140012269696768
KEY_NAME SID
KEY_VALUE 383.1
OWNER_ID 1
INCIDENT_FILE /home/oracle/diag/rdbms/galt/galt/trace/galt_pmon_3005.trc
OWNER_ID 1
INCIDENT_FILE /home/oracle/diag/rdbms/galt/galt/incident/incdir_129708/galt_pmon_3005_i129708.trc
1 rows fetched
可以看到目录下有异常事件的跟踪信息：
[oracle@riserver2 diag]$ cd /home/oracle/diag/rdbms/galt/galt/incident/incdir_129708/
[oracle@riserver2 incdir_129708]$ ls -l
total 7408
-rw-r-----. 1 oracle root 7561282 Jun 21 05:35 galt_pmon_3005_i129708.trc
-rw-r-----. 1 oracle root 19034 Jun 21 05:35 galt_pmon_3005_i129708.trm
下面就使用IPS进行打包：
adrci> set homepath diag/rdbms/galt/galt
adrci> ips create package incident 129708
Created package 1 based on incident id 129708, correlation level typical
adrci> ips generate package 1 in /home/oracle/diag
Generated package 1 in file /home/oracle/diag/ORA4030_20140621184527_COM_1.zip, mode complete
Additional incremental files:
/home/oracle/diag/ORA4030_20140621184527_INC_2.zip
解压缩这两个文件可以看到像alert日志等都打进来了，这里两文件压缩后是17MB左右，但alert日志就有1.7GB，所以压缩效率还很高。