-
What is ADR?
- Automatic Diagnostic Repository
- A directory structure for diagnostic files
- Support multiple instances and multiple products
-
Which parameter defines where the ADR resides
DIAGNOSTIC_DEST
-
Which init parameters have been depreciated with arrival of ADR?
BACKGROUND|USER_DUMP_DEST
-
Which view list alls the ADR locations for current Oracle instance?
V$DIAG_INFO
-
Which ADR location contains XML formatted logs?
Diag Alert
-
Which ADR location contains TXT formatted logs?
Diag Trace
-
Which view returns Active Problem Count and Active Incident Count?
V$DIAG_INFO
-
Which tool uploads diagnostic data to Oracle support?
Support Workbench
-
What requires configuration for Support Bench?
Oracle Configuration Manager
-
In support Workbench, what is a "Problem"?
- A critical error
- ORA-00600 ORA-07445 ORA-04031
-
In support Workbench, what is a "Incident"?
A single occurrence of a problem
-
What happens when an incident is generated?
- An entry is made in the alert log
- Incident alert is sent to OEM
- Diagnostic data is stored in dump files
-
Where are incident dumps stored?
In the ADR in subdirectory created for that incident
-
What is flood control?
A mechanism to prevent a single problem generating hundreds of incidents
-
How are the thresholds for incident flood control adjusted?
They can't be changed
-
What happens if five incidents of the same problem key occur in one hour?
Subsequent incidents are flood controlled
-
What happens if 25 incidents of the same problem key occur in one day?
Subsequent incidents are flood controlled
-
What happens after 50 incidents/hr or 250 incidents/day f the same problem key occur?
No further information is recorded. A message is written to the alertlog indictating this.
-
By default, how long is ADR metadata retained?
One year
-
By default, how long are incident and dump files kept?
One month
-
What is an incident package?
A collection of metadata stored in the ADR pointing to files relating to a given incident.
-
By default, what incidents for A PROBLEM are added to an incident package?
First and last three
-
What is ADRCI
- Automatic Diagnostic Repository Command Interpreter
- A command-line utility
-
What does ADRCI allow?
- Viewing of diagnostic data in ADR
- Viewing of Health Monitor reports
- Packaging incident and problem information for Oracle Support.
-
How is ADRCI secured?
At OS Level
-
What is the ADRCI homepath?
The root directory of all diagnostic data for a particular instance of a given Oracle product or component.
-
Which alert log does the ADRCI use?
The XML version without tags
-
How are scripts run in ADRCI?
@scriptname - same as SQLPLUS
-
Which ADRCI command lists all files in the trace directory?
SHOW TRACEFILE
-
Which ADRCI command displays information about open incidents
SHOW INCIDENT
-
What are the three steps in packaging an incident?
- Create a logical incident package
- Add diagnostic info to the incident package
- Generate physical incident package
-
Which tools are available to generate an incident package?
-
Which ADRCI command creates a package incident?
IPS CREATE PACKAGE INCIDENT incident_number
-
Which ADRCI command creates a package problem?
IPS CREATE PACKAGE PROBLEM problem_ID
-
Which ADRCI command creates a package problemkey?
IPS CREATE PACKAGE PROBLEMKEY problem_key
-
What does IPS CREATE PACKAGE SECONDS do?
Create a package including all diagnostics that have occurred from sec seconds until now
-
what does IPS CREATE PACKAGE without additional information do?
Creates and empty package
-
How is an incident added to a package?
IPS ADD INCIDENT incident_number PACKAGE package_number
-
How is a file added to a package?
- IPS ADD FILE filespec PACKAGE package_number
- where filespec = path/filename
-
What is the limitation on files added to a package?
The file must come from within the ADR base directory hierarchy
-
In what form are physical incident packages?
ZIP
-
What IPS command generates a physical incident package
IPS GENERATE PACKAGE package_number
-
What is an IPS incremental package?
Only contains incidents for a package since the last package generation.
-
What IPS command generates an incremental physical incident package
IPS GENERATE PACKAGE package_number INCREMENTAL
-
Of what Oracle feature is Heath Monitor a part of?
DATABASE FAULT DIAGNOSABILITY INFRASTRUCTURE
-
Where does Heath Monitor store its findings?
AUTOMATIC DIAGNOSTIC REPOSITORY
-
How are heath checks run manually?
Using DBMS_HM or OEM
-
What are the two modes for running heath checks?
-
In what state is the database when the DB-offline heath check is run?
nomount
-
What health checks can be run in DB-online mode?
All
-
What health checks can be run in DB-offline mode?
- Redo Integrity Check
- DB Structure Integrity Check
-
What does DB Structure Integrity Check do?
Integrity of database files inaccessible, corrupt or inconsistent
-
What does DB Block Integrity Check do?
Block corruption
-
What does Redo Integrity Check do?
Contents of redo logs and archived logs for accessibility and corruption
-
What does Undo Segment Integrity Check do?
Checks for undo corruption
-
If corruption is found in Undo segment, what memory structures does Oracle use to recover the corrupted transaction?
PMON and SMON
-
What does Transaction Integrity Check do?
Same as undo, but for a single transaction
-
What does Dictionary Integrity Check do?
Examines the integrity of core dictionary objects (ie tab$ and col$)
-
How is DBMS_HM package used?
DBMS_HM.RUN_CHECK('CHECKNAME1', 'CHECKNAME2')
-
Which view contains a list of available health checks?
V$HM_CHECK
-
If a health check requires a parameter, in which view are those parameter names found?
V$HM_CHECK_PARAM...NOT V$HM_CHECK, which only list the CHECK NAME
-
What triggers a reactive health check?
A critical error
-
What types of health check are there?
-
What are the possible values for STATUS in an incident?
|
|
