All technological notes.
Automatic Diagnostic Repository (ADR)Automatic Diagnostic Repository (ADR):
Data Recovery AdvisorIt is automatically maintained to hold diagnostic information about critical error events.
Data Recovery Advisor and also to create incident packages for Oracle Support Services.Characteristics:
Oracle Database server, Automatic Storage Management (ASM), Cluster Ready Services (CRS),and other Oracle products or componentsReal Application Clusters environment with shared storage and ASM, each database instance and each ASM instance have a home directory within the ADR.
DIAGNOSTIC_DEST initialization parameter:
ADR base / ADR root directoryORACLE_BASE is set, DIAGNOSTIC_DEST = $ORACLE_BASE.DIAGNOSTIC_DEST is set to $ORACLE_HOME/log.ADR Command-Line Tool (ADRCI)
Oracle SupportADRCI can be used in:
ADRCI can execute scripts of ADRCI commands.
# example adrci
adrci
# listing all open incidents stored in ADR.
show incident
Security:
| View | Description |
|---|---|
V$DIAG_INFO |
lists all important ADR locations |
V$DIAG_INFO
ADR Base: Path of the ADR baseADR Home: Path of the ADR home for the current database instance
Diag Trace: Location of the text alert log and background/foreground process trace filesDiag Alert: Location of an XML version of the alert logDiag Incident: Incident logs are written here.Diag Cdump: Diagnostic core files are written to this directory.Health Monitor: Location of logs from Health Monitor runsDefault Trace File: Path to the trace file for your session. SQL trace files are written here.