When a critical error occurs, it is assigned an incident number, and diagnostic data for the error (such as trace files) are immediately captured and tagged with this number. It is therefore available for problem diagnosis when the database is down. The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. Structure, Contents, and Location of the Automatic Diagnostic Repository.The fault diagnosability infrastructure consists of several components, including the Automatic Diagnostic Repository (ADR), various logs, trace files, the Enterprise Manager Support Workbench, and the ADRCI Command-Line Utility. Fault Diagnosability Infrastructure Components.An incident is a single occurrence of a problem. The problems that are targeted in particular are critical errors such as those caused by code bugs, metadata corruption, and customer data corruption.Ī problem is a critical error in a database instance, Oracle Automatic Storage Management (Oracle ASM) instance, or other Oracle product or component. The fault diagnosability infrastructure aids in preventing, detecting, diagnosing, and resolving problems. Fault Diagnosability Infrastructure Overview.This section describes how to resolve database problems using advisor tools, such as SQL Repair Advisor and Data Recovery Advisor, and the resource management tools, such as the Resource Manager and related APIs. With custom incident packages, you have fine control over the diagnostic data that you send to Oracle Support. Using the Enterprise Manager Support Workbench (Support Workbench), you can create, edit, and upload custom incident packages. This section describes various methods to diagnose problems in an Oracle database. You can use a "roadmap" that summarizes the typical set of tasks that you must perform. You can use the Enterprise Manager Support Workbench (Support Workbench) to investigate and report a problem (critical error), and in some cases, resolve the problem.
0 Comments
Leave a Reply. |