8 Managing Diagnostic Data

Beginning with Release 11g, Oracle Database includes an advanced fault diagnosability infrastructure for collecting and managing diagnostic data. Diagnostic data includes the trace files, dumps, and core files that are also present in previous releases, plus new types of diagnostic data that enable customers and Oracle Support to identify, investigate, track, and resolve problems quickly and effectively.

This chapter explains how to:

• View and manage diagnostic data generated by the database if a critical error or data corruption occurs.

• Investigate critical errors and data corruptions, and gather additional diagnostic data.

• Use an automated mechanism to upload first-failure diagnostic data to Oracle Support.

• Resolve some critical errors and data corruptions with Oracle advisors and other self-service facilities.

The following topics are covered:

• About the Oracle Database Fault Diagnosability Infrastructure

• Investigating, Reporting, and Resolving a Problem

• Viewing Problems with the Enterprise Manager Support Workbench

• Creating a User-Reported Problem

• Viewing the Alert Log

• Finding Trace Files

• Running HealthChecks with Health Monitor

• Repairing SQL Failures with the SQL Repair Advisor

• Repairing Data Corruptions with the Data Recovery Advisor

• Creating, Editing, and Uploading Custom Incident Packages