Pular para o conteúdo

O que o ADRCI pode me ajudar: A ferramenta essencial para gerenciar erros do banco de dados Oracle

O que o ADRCI pode me ajudar no meu dia a dia ?

Introduzido no Oracle 11.1.0.6 o ADRCI (Automatic Diagnostic Repository) é uma ferramenta desenvolvida pela própria Oracle que ajuda o DBA a gerenciar os erros que são gerados pelo o banco de dados. Além de visualizar os erros, podemos até mesmo definir uma janela de expurgo de traces sem a necessidade de criarmos um script na crontab ou job interno do Oracle.

Para utiliza-lo não há segredo, ele já vem instalado, basta executar:

[oracle@marte ~]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Mon Oct 19 17:52:17 2015 

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

ADR base = "/u01/app/oracle"

Com as variáveis exportadas ele irá se basear no seu ORACLE_BASE para encontrar ORACLE_HOMES que possua utilizar:

adrci> show homes

ADR Homes:

diag/clients/user_oracle/host_1710563632_82

diag/rdbms/orclp/ORCLP

diag/tnslsnr/marte/listener

diag/tnslsnr/marte/listener_02

Selecione o home desejado:

adrci> set home diag/rdbms/orclp/ORCLP

O comando show alert faz o mesmo que um vi alert_ORCLP.log faria:

adrci> show alert

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

Output the results to file: /tmp/alert_2840_14010_ORCLP_1.ado

2015-10-03 10:54:53.287000 -03:00

Starting ORACLE instance (normal) (OS id: 2615)

CLI notifier numLatches:3 maxDescs:519

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

Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

 Per process system memlock (soft) limit = 128G

 Expected per process system memlock (soft) limit to lock

 SHARED GLOBAL AREA (SGA) into memory: 468M

Mostra as últimas 20 linhas do alert.log

adrci> show alert -tail 20

2015-10-19 17:53:51.874000 -02:00

TNS-00513: Destination host unreachable

    nt secondary err code: 113

    nt OS err code: 0

2015-10-19 17:53:54.879000 -02:00

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

Fatal NI connect error 12543, connecting to:

 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=saturno.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCLSTB)(UR=A)(CID=(PROGRAM=oracle)(HOST=marte.localdomain)(USER=oracle))))

  VERSION INFORMATION:

TNS for Linux: Version 12.1.0.2.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production

  Time: 19-OCT-2015 17:53:54

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12543


TNS-12543: TNS:destination host unreachable

    ns secondary err code: 12560

    nt main err code: 513

TNS-00513: Destination host unreachable

    nt secondary err code: 113

    nt OS err code: 0

2015-10-19 17:53:57.885000 -02:00

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

Fatal NI connect error 12543, connecting to:

 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=saturno.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCLSTB)(UR=A)(CID=(PROGRAM=oracle)(HOST=marte.localdomain)(USER=oracle))))

  VERSION INFORMATION:

TNS for Linux: Version 12.1.0.2.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production

  Time: 19-OCT-2015 17:53:57

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12543

TNS-12543: TNS:destination host unreachable

    ns secondary err code: 12560

    nt main err code: 513

TNS-00513: Destination host unreachable

    nt secondary err code: 113

    nt OS err code: 0

Error 12543 received logging on to the standby

Executa um “loop” no alert.log aguardando novas entradas:

adrci> show alert -tail -f

2015-10-19 17:59:06.936000 -02:00

    ns main err code: 12543

TNS-12543: TNS:destination host unreachable

    ns secondary err code: 12560

    nt main err code: 513

TNS-00513: Destination host unreachable

    nt secondary err code: 113

    nt OS err code: 0

2015-10-19 17:59:09.942000 -02:00

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

Fatal NI connect error 12543, connecting to:

 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=saturno.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCLSTB)(UR=A)(CID=(PROGRAM=oracle)(HOST=marte.localdomain)(USER=oracle))))

  VERSION INFORMATION:

TNS for Linux: Version 12.1.0.2.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production

  Time: 19-OCT-2015 17:59:09

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12543

TNS-12543: TNS:destination host unreachable

    ns secondary err code: 12560

    nt main err code: 513

TNS-00513: Destination host unreachable

    nt secondary err code: 113

    nt OS err code: 0

Error 12543 received logging on to the standby 

Procura uma entrada com base em uma string

adrci> show alert -p "message_text like '%ORA-600%'"

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

No alert log in selected home

adrci> show alert -p "message_text like '%ERRO%'"

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

Output the results to file: /tmp/alert_2840_14010_ORCLP_3.ado

2015-10-03 10:54:53.294000 -03:00

  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)

2015-10-03 12:06:24.990000 -03:00

  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)

2015-10-03 13:00:18.752000 -03:00

  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)

2015-10-03 16:21:58.019000 -03:00

  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)

2015-10-05 11:25:55.411000 -03:00

Ver os incidentes gerados no banco de dados:

adrci> show incident

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME

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

185                  ORA 4031                                                    2015-10-03 11:19:12.449000 -03:00

153                  ORA 4031                                                    2015-10-03 11:19:13.337000 -03:00

313                  ORA 4031                                                    2015-10-03 11:19:20.097000 -03:00

305                  ORA 4031                                                    2015-10-03 11:19:21.792000 -03:00

186                  ORA 4031                                                    2015-10-03 11:19:22.096000 -03:00

127300               ORA 700 [kskvmstatact: excessive swapping observed]         2015-10-19 07:06:14.352000 -02:00

129700               ORA 700 [kskvmstatact: excessive swapping observed]         2015-10-19 08:56:26.789000 -02:00

7 rows fetched

Mostra os incidentes em modo BRIEF

adrci> show incident -mode brief

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

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

INCIDENT INFO RECORD 1

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

   INCIDENT_ID                   313

   STATUS                        ready

   CREATE_TIME                   2015-10-03 11:19:20.097000 -03:00

   PROBLEM_ID                    1

   CLOSE_TIME                    <NULL>

   FLOOD_CONTROLLED              none

   ERROR_FACILITY                ORA

   ERROR_NUMBER                  4031

   ERROR_ARG1                    12312

   ERROR_ARG2                    shared pool

   ERROR_ARG3                    unknown object

   ERROR_ARG4                    KKSSP^57

   ERROR_ARG5                    kglseshtTable

   ERROR_ARG6                    <NULL>

   ERROR_ARG7                    <NULL>

   ERROR_ARG8                    <NULL>

   ERROR_ARG9                    <NULL>

   ERROR_ARG10                   <NULL>

   ERROR_ARG11                   <NULL>

   ERROR_ARG12                   <NULL>

   SIGNALLING_COMPONENT          KGH

   SIGNALLING_SUBCOMPONENT       <NULL>

   SUSPECT_COMPONENT             <NULL>

   SUSPECT_SUBCOMPONENT          <NULL>

   ECID                          <NULL>

   IMPACTS                       0

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

INCIDENT INFO RECORD 2

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

   INCIDENT_ID                   305

   STATUS                        ready

   CREATE_TIME                   2015-10-03 11:19:21.792000 -03:00

   PROBLEM_ID                    1

   CLOSE_TIME                    <NULL>

   FLOOD_CONTROLLED              none

   ERROR_FACILITY                ORA

   ERROR_NUMBER                  4031

   ERROR_ARG1                    40

   ERROR_ARG2                    shared pool

   ERROR_ARG3                    java/util/Hashtable$1

   ERROR_ARG4                    KGLH0^6529442c

   ERROR_ARG5                    kglHeapInitialize:temp

   ERROR_ARG6                    <NULL>

   ERROR_ARG7                    <NULL>

   ERROR_ARG8                    <NULL>

   ERROR_ARG9                    <NULL>

   ERROR_ARG10                   <NULL>

   ERROR_ARG11                   <NULL>

   ERROR_ARG12                   <NULL>

   SIGNALLING_COMPONENT          KGH

   SIGNALLING_SUBCOMPONENT       <NULL>

   SUSPECT_COMPONENT             <NULL>

   SUSPECT_SUBCOMPONENT          <NULL>

   ECID                          <NULL>

   IMPACTS                       0

Mostra os incidentes em modo detalhado

adrci> show incident -mode detail

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

INCIDENT INFO RECORD 34

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

   INCIDENT_ID                   153

   STATUS                        ready

   CREATE_TIME                   2015-10-03 11:19:13.337000 -03:00

   PROBLEM_ID                    1

   CLOSE_TIME                    <NULL>

   FLOOD_CONTROLLED              none

   ERROR_FACILITY                ORA

   ERROR_NUMBER                  4031

   ERROR_ARG1                    8480

   ERROR_ARG2                    shared pool

   ERROR_ARG3                    unknown object

   ERROR_ARG4                    sga heap(1,0)

   ERROR_ARG5                    KQR X PO

   ERROR_ARG6                    <NULL>

   ERROR_ARG7                    <NULL>

   ERROR_ARG8                    <NULL>

   ERROR_ARG9                    <NULL>

   ERROR_ARG10                   <NULL>

   ERROR_ARG11                   <NULL>

   ERROR_ARG12                   <NULL>

   SIGNALLING_COMPONENT          KGH

   SIGNALLING_SUBCOMPONENT       <NULL>

   SUSPECT_COMPONENT             <NULL>

   SUSPECT_SUBCOMPONENT          <NULL>

   ECID                          <NULL>

   IMPACTS                       0

   PROBLEM_KEY                   ORA 4031

   FIRST_INCIDENT                185

   FIRSTINC_TIME                 2015-10-03 11:19:12.449000 -03:00

   LAST_INCIDENT                 2416

   LASTINC_TIME                  2015-10-03 11:33:42.558000 -03:00

   IMPACT1                       34668547

   IMPACT2                       34668546

   IMPACT3                       0

   IMPACT4                       0

   KEY_NAME                      Client ProcId

   KEY_VALUE                     oracle@marte.localdomain.2655_140494029107808

   KEY_NAME                      Service

   KEY_VALUE                     SYS$BACKGROUND

   KEY_NAME                      ProcId

   KEY_VALUE                     19.1

   KEY_NAME                      SID

   KEY_VALUE                     19.13037

   OWNER_ID                      1

   INCIDENT_FILE                 /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_mmon_2655.trc

   OWNER_ID                      1

   INCIDENT_FILE                 /u01/app/oracle/diag/rdbms/orclp/ORCLP/incident/incdir_153/ORCLP_mmon_2655_i153.trc

Mostra os problemas para aquele ORACLE_HOME

adrci> show problems

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME

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

1                    ORA 4031                                                    2416                 2015-10-03 11:33:42.558000 -03:00

2                    ORA 700 [kskvmstatact: excessive swapping observed]         129700               2015-10-19 08:56:26.789000 -02:00

2 rows fetched

Mostra apenas um incidente específico em modo detalhado


adrci> show incident -mode detail -p "INCIDENT_ID=185" ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP: ************************************************************************* ********************************************************** INCIDENT INFO RECORD 1 **********************************************************   INCIDENT_ID                   185   STATUS                        ready   CREATE_TIME                   2015-10-03 11:19:12.449000 -03:00   PROBLEM_ID                    1   CLOSE_TIME                    <NULL>   FLOOD_CONTROLLED              none   ERROR_FACILITY                ORA   ERROR_NUMBER                  4031   ERROR_ARG1                    40   ERROR_ARG2                    shared pool   ERROR_ARG3                    select policy#, action# from...   ERROR_ARG4                    KGLH0^f05ac4e6   ERROR_ARG5                    kglHeapInitialize:temp   ERROR_ARG6                    <NULL>   ERROR_ARG7                    <NULL>   ERROR_ARG8                    <NULL>   ERROR_ARG9                    <NULL>   ERROR_ARG10                   <NULL>   ERROR_ARG11                   <NULL>   ERROR_ARG12                   <NULL>   SIGNALLING_COMPONENT          KGH   SIGNALLING_SUBCOMPONENT       <NULL>   SUSPECT_COMPONENT             <NULL>   SUSPECT_SUBCOMPONENT          <NULL>   ECID                          <NULL>   IMPACTS                       0   PROBLEM_KEY                   ORA 4031   FIRST_INCIDENT                185   FIRSTINC_TIME                 2015-10-03 11:19:12.449000 -03:00   LAST_INCIDENT                 2416   LASTINC_TIME                  2015-10-03 11:33:42.558000 -03:00   IMPACT1                       34668547   IMPACT2                       34668546   IMPACT3                       0   IMPACT4                       0   KEY_NAME                      ProcId   KEY_VALUE                     23.8   KEY_NAME                      Client ProcId   KEY_VALUE                     oracle@marte.localdomain (TNS V1-V3).2898_140464977424992   KEY_NAME                      Module   KEY_VALUE                     sqlplus@marte.localdomain (TNS V1-V3)   KEY_NAME                      Service   KEY_VALUE                     SYS$USERS   KEY_NAME                      PQ   KEY_VALUE                     (0, 1443881948)   KEY_NAME                      SID   KEY_VALUE                     30.39763   OWNER_ID                      1   INCIDENT_FILE                 /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_ora_2898.trc   OWNER_ID                      1   INCIDENT_FILE                 /u01/app/oracle/diag/rdbms/orclp/ORCLP/incident/incdir_185/ORCLP_ora_2898_i185.trc 1 rows fetched

Mostra o conteúdo de um trace:


adrci> show trace /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_ora_2898.trc Output the results to file: /tmp/utsout_2840_140105_7.ado /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_ora_2898.trc ---------------------------------------------------------- LEVEL PAYLOAD ----- ------------------------------------------------------------------------------------------------------------------------------------------------      Trace file /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_ora_2898.trc      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options      ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/dbhome_1      System name:      Linux      Node name:        marte.localdomain      Release:  3.8.13-98.4.1.el6uek.x86_64      Version:  #2 SMP Wed Sep 23 18:46:01 PDT 2015      Machine:  x86_64      Instance name: ORCLP      Redo thread mounted by this instance: 1      Oracle process number: 23      Unix process pid: 2898, image: oracle@marte.localdomain (TNS V1-V3)      *** 2015-10-03 11:15:55.943      *** SESSION ID:(30.39763) 2015-10-03 11:15:55.943      *** CLIENT ID:() 2015-10-03 11:15:55.943      *** SERVICE NAME:(SYS$USERS) 2015-10-03 11:15:55.943      *** MODULE NAME:(sqlplus@marte.localdomain (TNS V1-V3)) 2015-10-03 11:15:55.943      *** CLIENT DRIVER:(SQL*PLUS) 2015-10-03 11:15:55.943      *** ACTION NAME:() 2015-10-03 11:15:55.943      arguments: '-kprb' '-v' '-r' '-grant' 'PUBLIC' '-s' 'rdbms/jlib/servlet.jar'

Cria um IPS (Incident Packaging Service) com base em um incidente específico para ser usada em uma SR na Oracle.

adrci> ips create package incident 185


Created package 1 based on incident id 185, correlation level typical

Cria um IPS para todos os incidentes

adrci> ips create package

Created package 2 without any contents, correlation level typical

Cria um IPS para um determinado período, esse é útil quando ocorrem vários erros facilitando a criação do IPS rapidamente sem ter que criar um por um:

adrci> ips create package time '2015-10-10 00:00:00 -03:00' to '2015-10-19 22:00:00 -03:00'

Created package 3 based on time range 2015-10-10 00:00:00.000000 -03:00 to 2015-10-19 22:00:00.000000 -03:00, correlation level typical

Cria um IPS em um determinado diretório:

adrci> ips generate package 1 in /home/oracle

Generated package 1 in file /home/oracle/ORA4031_20151019181428_COM_1.zip, mode complete

Cria uma IPS com base em um problem key

adrci> show problem

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME

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

1                    ORA 4031                                                    2416                 2015-10-03 11:33:42.558000 -03:00

2                    ORA 700 [kskvmstatact: excessive swapping observed]         129700               2015-10-19 08:56:26.789000 -02:00

2 rows fetched

adrci> IPS CREATE PACKAGE PROBLEMKEY "ORA 4031"

Created package 4 based on problem key ORA 4031, correlation level typical

Adiciona um incidente em uma package já criada:

adrci> ips add incident 153 package 1

Added incident 153 to package 1

Mostra a política de retenção dos traces e incidentes:

adrci> show control

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME                            LAST_AUTOPRG_TIME                        LAST_MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION      ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME

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

2342799286           720                  8760                 2015-10-03 10:54:50.871975 -03:00                                                                                          1                    2                    82                   1                    2015-10-03 10:54:50.871975 -03:00

1 rows fetched

SHOTP_POLICY: O valor defaul é de 720 horas (30 dias) e é responsável pela retenção de arquivos de trc e trm.

LONGP_POLICY: o valor defaul é 8760 (1 ano) e é responsável pela retenção de incidentes.

Caso você queira alterar a retenção:

adrci> set control (SHORTP_POLICY = 240)

adrci> set control (LONGP_POLICY = 1095)

adrci> show control

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME                            LAST_AUTOPRG_TIME                        LAST_MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION      ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME

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

2342799286           240                  1095                 2015-10-19 18:30:20.270167 -02:00                                                                                          1                    2                    82                   1                    2015-10-03 10:54:50.871975 -03:00

1 rows fetched

Expurgo manual:

adrci> purge -age 10080 -type ALERT (também exclui o log do Listener)

adrci> purge -age 10080 -type TRACE

adrci> purge -age 10080 -type incident

adrci> purge -age 10080 -type hm

adrci> purge -age 10080 -type utscdmp

adrci> purge -age 10080 -type cdump

Obs: No purge o tempo é em minutos

[oracle@marte trace]$ ls –l

...

-rw-r-----. 1 oracle oinstall     885 Oct 19 17:47 orclp_ora_2547.trc

-rw-r-----. 1 oracle oinstall      88 Oct 19 17:47 ORCLP_vktm_2555.trm

-rw-r-----. 1 oracle oinstall    1195 Oct 19 17:47 ORCLP_vktm_2555.trc

-rw-r-----. 1 oracle oinstall     106 Oct 19 17:47 ORCLP_dbw0_2573.trm

-rw-r-----. 1 oracle oinstall     964 Oct 19 17:47 ORCLP_dbw0_2573.trc

-rw-r-----. 1 oracle oinstall     192 Oct 19 17:47 ORCLP_ora_2547.trm

-rw-r-----. 1 oracle oinstall    4321 Oct 19 17:47 ORCLP_ora_2547.trc

-rw-r-----. 1 oracle oinstall     117 Oct 19 17:47 ORCLP_ckpt_2577.trm

-rw-r-----. 1 oracle oinstall    1125 Oct 19 17:47 ORCLP_ckpt_2577.trc

-rw-r-----. 1 oracle oinstall     201 Oct 19 17:47 ORCLP_ora_2598.trm

-rw-r-----. 1 oracle oinstall    1977 Oct 19 17:47 ORCLP_ora_2598.trc

-rw-r-----. 1 oracle oinstall      71 Oct 19 17:47 ORCLP_arc1_2610.trm

-rw-r-----. 1 oracle oinstall     959 Oct 19 17:47 ORCLP_arc1_2610.trc

-rw-r-----. 1 oracle oinstall      70 Oct 19 17:47 ORCLP_tt01_2618.trm

-rw-r-----. 1 oracle oinstall     940 Oct 19 17:47 ORCLP_tt01_2618.trc

-rw-r-----. 1 oracle oinstall      81 Oct 19 17:47 ORCLP_vkrm_2569.trm

-rw-r-----. 1 oracle oinstall    1119 Oct 19 17:47 ORCLP_vkrm_2569.trc

-rw-r-----. 1 oracle oinstall     132 Oct 19 17:47 ORCLP_arc0_2608.trm

-rw-r-----. 1 oracle oinstall    2066 Oct 19 17:47 ORCLP_arc0_2608.trc

-rw-r-----. 1 oracle oinstall     123 Oct 19 17:47 ORCLP_tt00_2616.trm

-rw-r-----. 1 oracle oinstall    2097 Oct 19 17:47 ORCLP_tt00_2616.trc

-rw-r-----. 1 oracle oinstall     122 Oct 19 17:48 ORCLP_aqpc_2626.trm

-rw-r-----. 1 oracle oinstall    1030 Oct 19 17:48 ORCLP_aqpc_2626.trc

-rw-r-----. 1 oracle oinstall     123 Oct 19 17:52 ORCLP_ora_2604.trm

[oracle@marte trace]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Mon Oct 19 18:35:10 2015

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

ADR base = "/u01/app/oracle"

adrci> purge -age 10 -type TRACE

adrci> exit

[oracle@marte trace]$ ls -l

total 2724

-rw-r-----. 1 oracle oinstall 2674657 Oct 19 18:40 alert_ORCLP.log

drwxr-xr-x. 2 oracle oinstall    4096 Oct 10 07:30 cdmp_20151010073008

drwxr-xr-x. 2 oracle oinstall    4096 Oct 10 07:31 cdmp_20151010073101

drwxr-xr-x. 2 oracle oinstall    4096 Oct 10 07:32 cdmp_20151010073245

drwxr-xr-x. 2 oracle oinstall    4096 Oct 10 07:35 cdmp_20151010073534

drwxr-xr-x. 2 oracle oinstall    4096 Oct 10 08:03 cdmp_20151010080322

drwxr-xr-x. 2 oracle oinstall   12288 Oct 19 07:06 cdmp_20151019070653

drwxr-xr-x. 2 oracle oinstall   12288 Oct 19 08:56 cdmp_20151019085646

-rw-r-----. 1 oracle oinstall   12350 Oct 19 18:40 ORCLP_arc2_2612.trc

-rw-r-----. 1 oracle oinstall     591 Oct 19 18:40 ORCLP_arc2_2612.trm

-rw-r-----. 1 oracle oinstall    2122 Oct 19 18:30 ORCLP_cjq0_2638.trc

-rw-r-----. 1 oracle oinstall     195 Oct 19 18:30 ORCLP_cjq0_2638.trm

-rw-r-----. 1 oracle oinstall   24042 Oct 19 18:44 ORCLP_dbrm_2567.trc

-rw-r-----. 1 oracle oinstall    1483 Oct 19 18:44 ORCLP_dbrm_2567.trm

-rw-r-----. 1 oracle oinstall    2487 Oct 19 18:43 ORCLP_mmon_2587.trc

-rw-r-----. 1 oracle oinstall     215 Oct 19 18:43 ORCLP_mmon_2587.trm

O melhor de tudo, ele não precisa que a instancia esteja no ar para ser usado:

[oracle@marte trace]$ s

SQL*Plus: Release 12.1.0.2.0 Production on Mon Oct 19 18:47:12 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@marte trace]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Mon Oct 19 18:47:39 2015

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

ADR base = "/u01/app/oracle"

adrci> show alert

ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:

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

Output the results to file: /tmp/alert_3534_13967_ORCLP_1.ado

...

Successful close of redo thread 1

2015-10-19 18:47:22.203000 -02:00

Completed: ALTER DATABASE CLOSE NORMAL

Espero ter facilitado o seu dia a dia.

Até logo!

Gabriel Comenale

Gabriel Comenale

Gabriel Comenale, formado em banco de dados pela FIAP possui 6 anos de experiência na área de técnologia trabalhando com ambientes de pequeno, médio e grande porte nas plataformas Linux e Windows de segmentos variados de clientes como Odebrecht, Livraria Cultura, AES Eletropaulo, Renner, Sindicato dos Comerciários, Tigre – Tubos e Conexões, Unimed Seguros, Fidelity Investments, Alelo entre outros. Possui as certificações OCA 11g e ITIL V3 além de já ter estudado no Canadá e ministrado treinamentos em banco de dados Oracle. Atualmente trabalha como DBA Oracle na TIVIT.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Marcações:
plugins premium WordPress