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