ADR

From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽

ADR (Automatic Diagnostic Repository) is part of the Oracle database's fault diagnosability infrastructure, first introduced with Oracle 11g, to reduce time for resolving problems (round trip time between DBA's and Oracle Support).

DBA's can change the ADR directory by changing the DIAGNOSTIC_DEST initialization parameter.

The following subdirectories are present in the ADR home directory:

  • alert - The XML formatted alert log file (called log.xml)
  • trace - files and text alert.log file
  • cdump - core files

Also see

  • adrci - ADR Command Interface
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #