使用 ADRCI 收集问题信息

adrci> help dde create incident
Usage: DDE CREATE INCIDENT TYPE

SQL> BEGIN
  DBMS_HM.RUN_CHECK('Data Block Integrity Check', 'my_run2');
END;
/  2    3    4  
BEGIN
*
ERROR at line 1:
ORA-48615: Parameter [BLC_DF_NUM] value not specified
ORA-06512: at "SYS.DBMS_HM", line 191
ORA-06512: at line 2

必须知道block，不能整个库检查，遗憾！

生成 incident 的包

adrci> set homepath diag/rdbms/short/short1
adrci> ips generate package 1 in /tmp
Generated package 1 in file /tmp/ORA700ksk_20201106113411_COM_2.zip, mode complete
[oracle@rac1 diag]$ ll /tmp/ORA700ksk_20201106113411_COM_2.zip
-rw-r--r-- 1 oracle oinstall 13056412 Nov  6 12:12 /tmp/ORA700ksk_20201106113411_COM_2.zip

生成problem 的包

adrci> set homepath diag/rdbms/short/short1
adrci> ips generate package 2 in /tmp
Generated package 2 in file /tmp/IPSPKG_20201106134338_COM_1.zip, mode complete

[oracle@rac1 ~]$ unzip /tmp/IPSPKG_20201106134338_COM_1.zip
Archive:  /tmp/IPSPKG_20201106134338_COM_1.zip
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/IPS_CONFIGURATION.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/IPS_PACKAGE.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/IPS_PACKAGE_INCIDENT.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/IPS_PACKAGE_FILE.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/IPS_PACKAGE_HISTORY.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/IPS_FILE_METADATA.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/IPS_FILE_COPY_LOG.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/DDE_USER_ACTION_DEF.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/DDE_USER_ACTION_PARAMETER_DEF.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/DDE_USER_ACTION.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/DDE_USER_ACTION_PARAMETER.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/DDE_USER_INCIDENT_TYPE.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/DDE_USER_INCIDENT_ACTION_MAP.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/INCIDENT.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/INCCKEY.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/INCIDENT_FILE.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/PROBLEM.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/HM_RUN.dmp  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/export/EM_USER_ACTIVITY.dmp  
  inflating: diag/rdbms/short/short1/trace/alert_short1.log  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/config.xml  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/crs/crsdiag.log  
 extracting: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/crs/alertrac1.log  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/opatch/opatch.xml  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/opatch/opatch.log  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/metadata.xml  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/manifest_2_1.xml  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/manifest_2_1.html  
  inflating: diag/rdbms/short/short1/incpkg/pkg_2/seq_1/manifest_2_1.txt  
  inflating: metadata.xml            
[oracle@rac1 ~]$ vi diag/rdbms/short/short1/incpkg/pkg_2/seq_1/crs/crsdiag.log  
Production Copyright 2004, 2010, Oracle.  All rights reserved
Cluster Ready Services (CRS) diagnostic collection tool wrapper script
Production Copyright 2004, 2010, Oracle.  All rights reserved
Cluster Ready Services (CRS) diagnostic collection tool
Warning: Script executed while not logged in as as root
         Some diagnostic data may not be collected
Done.

需要用 root 用户进入收集信息

[root@rac1 oracle]# /u01/app/oracle/product/12.1.0/db_1/bin/adrci
adrci> set base  /u01/app/oracle 
adrci> show homes
ADR Homes: 
diag/tnslsnr/rac1/listener
diag/clients/user_root/host_3726161224_82
diag/clients/user_oracle/host_3726161224_82
diag/diagtool/user_oracle/adrci_3726161224_82
diag/rdbms/nopl_pitr_jrsdb/nopl
diag/rdbms/jbsf_pitr_class_school/jbsf
diag/rdbms/davo_pitr_jrsdb/Davo
diag/rdbms/mydb/mydb1
diag/rdbms/wvse_pitr_longdb/wvsE
diag/rdbms/short/short1
diag/rdbms/eddi_pitr_pdbjrs1_jrsdb/Eddi
diag/rdbms/eago_pitr_class_school/eago
diag/rdbms/nbwd_pitr_jrsdb/nbwD
adrci>
adrci> set homepath diag/rdbms/short/short1
adrci> IPS CREATE PACKAGE PROBLEM 2
Created package 3 based on problem id 2, correlation level typical
adrci>  ips generate package 3 in /tmp
Generated package 3 in file /tmp/IPSPKG_20201106140248_COM_1.zip, mode complete
adrci>  

crs 的日志： /u01/app/grid/diag/crs/rac1/crs/trace/alert.log