ORACLE Database ADRCI



ADRCI is Automatic Diagnostic Repository Command Interpreter. Its command line tool to manage diagnostic data. Diagnostic data include alert log, trace file, dump, HM report and more.

Automatic Diagnostic Repository
ADR is file based repository for Oracle database diagnostic data. It stores alert log, core dump, health monitor reports. The same directory structure is used across multiple products of Oracle database like listener, CRS, ASM.

ADRCI provide interactive mode, to launch it use adrci command. Make sure Set ORACLE_HOME and PATH variable properly. The relative location from where adrci launched that define behavior of it. If you launch adrci utility from perticular database diagnostic destination then home path set to that database by default. Using show control purge policy can be found.

adrci> show control;
ADR Home = /oracle/app/oracle/diag/rdbms/testdb/testdb: *************************************************************************
ADRID  SHORTP_POLICY   LONGP_POLICY   LAST_MOD_TIME   LAST_AUTOPRG_TIME   LAST_MANUPRG_TIME   ADRDIR_VERSION   ADRSCHM_VERSION   ADRSCHMV_SUMMARY   ADRALERT_VERSION   CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
333787895   24   24   2018-10-08 13:41:37.435752 +01:00   2018-10-15 07:51:10.564017 +01:00   1   2   82   1   2017-02-14 20:38:07.899851 +00:00

Diagnostic components included in LONGP_POLICY are alert log, incident, sweep, stage, HM. Where as diagnostic components included in SHORTP_POLICY are trace, CDUMP, IPS, UTSCDMP. Value to LONGP_POLICY and SHORTP_POLICY are provided in hours. Default value of LONGP_POLICY is 8760 which evaluates to 1 year. Default value of SHORTP_POLICY is 720 which evaluates to 1 month. Using set control retention period of these policies can be changed.

adrci> set control (SHORTP_POLICY=128)
adrci> set control (LONGP_POLICY=710)

MMON background process responsible for ADRCI policies. It purges diagnostic data according to policy. It execute after every seven days. If you want to store diagnostic data of less than 7 days, then purge it manually. To schedule purge execution using crontab, use below code.

https://github.com/dtdhirajt/ORACLE-ADRCI-schedular-script/blob/master/ORACLE_ADRCI_Purge.sh

Listener and clusterware diagnostic data can be managed by using ADRCI. If you want to store cluster, listener and asm diagnostic data of less than 7 days, then schedule purge execution using crontab, use below code.

https://github.com/dtdhirajt/ORACLE-ADRCI-schedular-script/blob/master/GRID_ADRCI_Purge.sh

Comments

Post a Comment

Popular posts from this blog

Oracle RAC Database QUIESCE Mode

Image
Oracle RAC database quiesce mode is only privileged user can login to database and perform operation. It is restricted mode for DBA operations only. To put RAC database in quiesce mode, use ALTER SYSTEM QUIESCE RESTRICTED Above statement affect all instances in RAC. Database Resource Manager feature must be activated. After all non-DBA session become inactive then database considered as quiesced. The instance from which you put RAC database in quiesce mode, from same instance you have to unquiesce database, using ALTER SYSTEM UNQUIESCE If you have executed ALTER SYSTEM QUIESCE RESTRICTED statement, and oracle database has not finished processing it, then you cannot open database. WE cannot open database if it is already quiesced. ALTER SYSTEM QUIESCE RESTRICTED and ALTER SYSTEM UNQUIESCE statement affect all instances in RAC database. Cold backup cannot be taken when databas
Read more

OMS 13c Port Requirement

  Recently I was working on OEM13c configuration. I was facing problem with which ports need to be open and that unidirectional or bidirectional. So I thought to write blog post on this. While working on OMS configuration and setup, we will come across many ports.  All the list of ports which used in OMS configuration and monitoring setup can be found in portlist.ini file. [oracle@############ ~]$ cat /u01/app/oracle/oemec2/middleware/install/portlist.ini Enterprise Manager Upload Http Port=4889 Managed Server Http Port=7202 Node Manager Http SSL Port=7403 OHS Http Port=9788 Enterprise Manager Upload Http SSL Port=4903 OHS Http SSL Port=9851 BI Publisher Http SSL Port=9803 Oracle Management Agent Port=3872 Enterprise Manager Central Console Http Port=7788 Admin Server Http SSL Port=7102 Managed Server Http SSL Port=7301 BI Publisher Http Port=9701 Enterprise Manager Central Console Http SSL Port=7803 These ports may vary for different OEM versions. Above port list is
Read more

PostgreSQL pg_controldata utility

Image
Hello Guys, In this post we are going see a utility provided by PostgreSQL to find information about database cluster.  If we want know information about PostgreSQL cluster like database block size, catalog information,  checkpoint information, WAL segment size, etc. we will use pg_controdata utility. the location of pg_controldata utility will be same as your postgresql installation then bin directory. to execute this utility we have to provide data directory location as parameter. The sample output is attached here. #############################!!! Happy Learning !!!################################
Read more