Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor

Overview/Description
recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
2.1

Lesson Objectives

Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor

recognize the scope and capabilities of the Automatic Diagnostic Repository (ADR) feature in Oracle Database 11g.

identify the tasks that can be performed, using the Support Workbench wizard, to handle critical errors in Oracle Database 11g.

identify the steps for configuring incident packages and for creating, manipulating, and modifying custom packages.

identify the steps for dealing with critical errors in Oracle Database 11g, using the Health Monitor and SQL Repair Advisor tools.

recognize your options for assessing data failures in Oracle Database 11g, using the Data Recovery Advisor.

identify the steps for getting advice on repairing data failures, executing these repairs using RMAN data repair commands, and setting parameters to detect further corruption.

repair a down database via Enterprise Manager.