ADRCI automatic diagnostic repository utility

From Robs_Wiki
Jump to: navigation, search

set and check the ADR purging policies

-- Step 1: set the environment

[oracle@exa-dm1dbadm01 ~]$ adrci
ADRCI: Release 12.2.0.1.0 - Production on Fri Aug 10 08:17:33 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
ADR base = "/u01/app/oracle"
adrci> set homepath diag/rdbms/prod/prod1

 
-- Step 2: set the size policy to 1 GB

adrci> set control (sizep_policy = 1073741824)

 
-- Step 3: View current settings

adrci> select shortp_policy, longp_policy from adr_control;
ADR Home = /u01/app/oracle/diag/rdbms/prod/prod1:
*************************************************************************
SHORTP_POLICY        LONGP_POLICY
-------------------- --------------------
720                  8760
1 row fetched
-- value in hours

adrci> select sizep_policy FROM adr_control_aux;
ADR Home = /u01/app/oracle/diag/rdbms/prod/prod1:
*************************************************************************
SIZEP_POLICY
--------------------
10737418240
1 row fetched

purge the ADR manually

USAGE: adrci> PURGE [[-i id1 | start_id end_id] | [-age mins [-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP]

EXAMPLES:
adrci> set home diag/rdbms/prod/prod1
adrci> purge
adrci> purge -age 15
adrci> purge -i 123 456
adrci> purge -age 600 -type incident
adrci> purge –age 720 –type alert

Use ADR to package an incident

Reference: ADR Different Methods to Create IPS Package (Doc ID 411.1)  

[oracle@exa-dm1dbadm01 trace]$ db
[oracle@exa-dm1dbadm01 trace]$ prod
[oracle@exa-dm1dbadm01 trace]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Tue May 2 15:09:21 2017

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

ADR base = "/u01/app/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/prod/prod1
adrci> set home diag/rdbms/prod/prod1

adrci> show incident

ADR Home = /u01/app/oracle/diag/rdbms/prod/prod1:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
16913                ORA 600 [klaprs_11]                                         2017-03-07 07:24:12.246000 +00:00
280319               ORA 4031                                                    2017-04-05 10:56:42.720000 +01:00
361303               ORA 600 [kupclsCB_02]                                       2017-04-26 17:26:44.982000 +01:00

3 rows fetched

adrci> IPS CREATE PACKAGE INCIDENT 361303
Created package 1 based on incident id 361303, correlation level typical

adrci> IPS GENERATE PACKAGE 1 IN /tmp
Generated package 1 in file /tmp/ORA600kup_20170502151142_COM_1.zip, mode complete

Create an Incident Package

Reference: ADR Different Methods to Create IPS Package (Doc ID 411.1)  

[oracle@cdf-dm1dbadm01 trace]$ . oraenv
[oracle@cdf-dm1dbadm01 trace]$ prod
[oracle@cdf-dm1dbadm01 trace]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Tue May 2 15:09:21 2017

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

ADR base = "/u01/app/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/prod/prod
adrci> set home diag/rdbms/prod/prod

adrci> show incident

ADR Home = /u01/app/oracle/diag/rdbms/prod/prod:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
16913                ORA 600 [klaprs_11]                                         2017-03-07 07:24:12.246000 +00:00
280319               ORA 4031                                                    2017-04-05 10:56:42.720000 +01:00
361303               ORA 600 [kupclsCB_02]                                       2017-04-26 17:26:44.982000 +01:00

3 rows fetched

adrci> IPS CREATE PACKAGE INCIDENT 361303
Created package 1 based on incident id 361303, correlation level typical

adrci> IPS GENERATE PACKAGE 1 IN /tmp
Generated package 1 in file /tmp/ORA600kup_20170502151142_COM_1.zip, mode complete