Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to use oracle11g ADR. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1.ADR description

ORACLE11G starts all diagnostic data (rdbms,listener,asm,crs,etc.) Are stored in ADR.

The ADR directory is located at $ORACLE_BASE/diag/

two。 Fault type

(1) problem

Any serious error in the database is defined as a problem, and each problem is assigned a problem key

(2) incident

Refers to a single occurrence of a particular problem, and if it occurs multiple times, a problem and multiple unexpected events are used to represent the multiple occurrence of the problem.

Each incident has its own id

Incident metadata is retained for one year by default

Incident files and dumps are retained for one month by default

3. Catalog description

ADR assigns a separate home directory to each instance of each ORACLE product, and a single ADR base directory can contain multiple ADR home directories, each pointing to a different ORACLE instance.

Each ADR home directory is the root of all diagnostic files for a database instance or any other ORACLE product or build.

-alert: the alert log of the instance

-cdump: core file

-hm: Health Monitor report

-incident: the subdirectory of each accident, and the subdirectory of each accident also contains all trace dumps for that accident

-incpkg: unexpected event package

-ir: unexpected event report created by each instance

-trace: stores user session tracking files

4.adrci usage

(1)。 Use adrci as a script or batch

Adrci exec= "command [; command]"

(2)。 Set up the home directory

Adrci > show base View the ADR base directory

Adrci > show home displays all home directories, so the command executed will be applied to all home directories

Adrci > set homepath diag/clients/user_oracle/host_1874443374_107 select home directory

Adrci > show homepath

ADR Homes:

Diag/clients/user_oracle/host_1874443374_107

Adrci > show incident

ADR Home = / oracle/app/oracle/diag/clients/user_oracle/host_1874443374_107:

*

0 rows fetched

(3)。 View the warning log

Adrci > show alert

Choose the home from which to view the alert log:

1: diag/clients/user_oracle/host_1874443374_107

2: diag/rdbms/racdb12c/racdb12c1

Q: to quit

Please select option:

Show alert-p "message_text like'% TNS-12535%'"

Show alert-tail 20

Record alert.log content

Spool xxxx.log

Show alert

Spool off

(4)。 View incident events

Show incident-mode detail-p "INCIDENT_ID=176121"

(5). Incident event packaging

-create a new logical package

Adrci > ips create package

-add incident and problem to the package

Adrci > ips add incident 176121 package 1

-generate package

Adrci > ips generate package 1 in / tmp/wwj

Adrci > ips generate package 1 in / tmp/wwj incremental

(6)。 Clear

When there is no adrci, we have to clean up all the directories separately. But with the help of adrci's purge command and control configuration, it can be easily sorted out.

Adrci > help purge

Usage: PURGE [[- I |] |

[[- age] |

[- size] |

[- type {ALERT | INCIDENT | TRACE | CDUMP | HM | UTSCDMP | LOG}]]

Purpose: Purge the diagnostic data in the current ADR home. If no

Option is specified, the default purging policy will be used.

Purge

Purge-I 123 456

Purge-age 60-type incident

Purge-size 10000000

Thank you for reading! This is the end of the article on "how to use oracle11g ADR". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.