Note_Tech

All technological notes.

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

Diagnosis - `Automatic Diagnostic Repository (ADR)`

Automatic Diagnostic Repository (ADR):
- a special repository used by Data Recovery Advisor
- a file-based repository for database diagnostic data such as traces, incident dumps and packages, the alert log, Health Monitor reports, core dumps, and more.
- has a unified directory structure across multiple instances and multiple products-stored outside of any database.
  - available for problem diagnosis when the database is down.
It is automatically maintained to hold diagnostic information about critical error events.
- This information can be used by the Data Recovery Advisor and also to create incident packages for Oracle Support Services.
Characteristics:
- ADR store all diagnostic data for:
  - Oracle Database server, Automatic Storage Management (ASM), Cluster Ready Services (CRS),and other Oracle products or components
- Each instance of each product stores diagnostic data underneath its own ADR home directory. 每个产品的每个实例都有其自己的 ADR,并存储各自的数据
  - e.g., in a Real Application Clusters environment with shared storage and ASM, each database instance and each ASM instance have a home directory within the ADR.
- ADR’s unified directory structure, consistent diagnostic data formats across products and instances, and a unified set of tools enable customers and Oracle Support to correlate and analyze diagnostic data across multiple instances.文件夹结构统一

adr

DIAGNOSTIC_DEST initialization parameter:
- ADR base / ADR root directory
- If this parameter is omitted or left null, it will be set upon startup as follows
  - If the environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST = $ORACLE_BASE.
  - Otherwise, DIAGNOSTIC_DEST is set to $ORACLE_HOME/log.

ADR Command-Line Tool (ADRCI)
- a command-line tool that is part of the database fault diagnosability infrastructure.
- enables you to:
  - View diagnostic data within the ADR
  - Package incident and problem information into a ZIP file for transmission to Oracle Support
ADRCI can be used in:
- interactive mode
- scripts mode
ADRCI can execute scripts of ADRCI commands.

# example adrci
adrci

# listing all open incidents stored in ADR.
show incident

Security:
- There is no need to log in to ADRCI, because the data in the ADR is not intended to be secure.
- ADR data is secured only by operating system permissions on the ADR directories.

View	Description
`V$DIAG_INFO`	lists all important ADR locations