Oracle Automatic Diagnostic archives (ADR), automatic diagnostic workflows, and ADRCI tools. Automatic diagnosis workflow:
With a memory tracking tool that is always on, the database component can capture diagnostic data when a serious error occurs
From OracleDatabase11gR1, the traditional hellip; _ DUMP_DEST initialization parameters are ignored. The ADR root directory is also called the ADR base Directory, which is located by DIAGNOSTIC _
Starting from Oracle Database11g R1, the traditional
1. Automated Diagnostics Workflow:With an in-memory tracing tool that is always turned on, the database component can capture diagnostic data the first time a critical error failure occurs. A special repository, called an automated diagnostic
Path of the trace file under the ADR Management in 11g
A 11G development library, intends to open the trace of sqlplus, check the connection information of sqlplus login, but configure sqlnet. ora did not find the trace file, and one day it was
The Automated diagnostics information Base (ADR) is introduced in Oracle 11g, which provides a uniform and consistent mechanism for storing, formatting, and locating all database diagnostics (EASY-TO-USE file structures). ADR associates errors with
IPs simple Use Method:
IPS (Incident packaging service) is a new feature of 11G that is designed to view all dump and trace files associated with an error and can be easily typed into a package, which I think is extremely convenient for DBAs to
The log system of the Oracle 1gR2 database changes a lot. The following describes the changes in the parameter file and adr.1. parameter fileAfter converting the spfile to pfile, we can see that the original bdump, adump, cdump, and udump settings
1 descriptionIn 11g, view the log of the grid and enter $oracle_hom/log.[[email protected] ~]$ cd $ORACLE _home/log/[[email protected] log]$ lscrs diag rac1[[email protected] log]$ cd rac1[[email protected]
1. Data Recovery Advisor (DRA) Description 1.1 DRA description
DRA automatically collects data fault information when an error occurs. In addition, it can check faults in advance. In this mode, it can detect and analyze data faults before the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.