Oracle Database 11g: High Availability Self-Study Course

The following lessons show how the new and enhanced features of the Oracle Database 11g support highly available databases:
Using Data Recovery Advisor
Using Flashback and LogMiner
Online Application Maintenance
Using RMAN Enhancements
Using RMAN and Data Guard Integration Enhancements
Using Data Guard Enhancements
Using Data Guard Fast-Start Failover

Please check the OBEs for step-by-step examples of some of these topics.

Audience

• Database Administrators
• Database Designers
• End Users
• Support Engineer
• Technical Administrator

Course Topics Using the Data Recovery Advisor

• Repairing Data Failures
• Data Recovery Advisor
• Assessing Data Failures
• Data Failures
• Data Failure: Examples
• Listing Data Failures
• Executing Repairs
• RMAN Command-Line Interface

Using Flashback and LogMiner

• New and Enhanced Features
• Oracle Total Recall
• Flashback Data Archive
• Preparing Your Database
• Flashback Data Archive: Workflow
• Using Flashback Data Archive
• Viewing Flashback Data Archives
• Prerequisites

Online Application Maintenance

• What You Already Know and What Is New
• Redefinition and Materialized View
• More Precise Dependency Metadata
• Fine-Grain Dependency Management
• Minimizing Dependent PL/SQL Recompilation
• Serializing Locks
• Locking Tables Explicitly
• Sharing Locks

Using RMAN Enhancements

• RMAN: New Features
• More RMAN New Features
• Parallel Backup and Restore for Very Large Files
• Active Database Duplication
• The RMAN DUPLICATE Command
• Archival Backups
• Managing Recovery Catalogs
• The IMPORT CATALOG Command

Using RMAN and Data Guard Integration Enhancements

• Improved Integration of RMAN and Data Guard
• Setting a Persistent Configuration for a Site
• Viewing Persistent Configuration Information
• Viewing Site Information in the Recovery Catalog
• Defining Connect Identifiers for Data Guard Databases
• Associating Metadata with a New Site Name
• Removing Site Information from the Recovery Catalog
• Restoring a Control File

Using Data Guard Enhancements

• Real-Time Query and Physical Standby Databases
• Using Real-Time Query
• Compressing Redo Data
• Querying the Redo Compression Attribute
• Dynamically Setting SQL Apply Parameters
• New Columns in DBA_LOGSTDBY_PARAMETERS
• Logical Standby Database Flash Recovery Area
• Using DGMGRL to Create a Snapshot Standby Database

Using Data Guard Fast-Start Failover Enhancements

• Displaying Fast-Start Failover Information
• Initiating Fast-Start Failover from an Application
• INITIATE_FS_FAILOVER Error Codes
• Determining the Reason for a Fast-Start Failover
• Availability of the Primary Database
• Fast-Start Failover in Maximum Performance Mode
• Is Fast-Start Failover Possible?
• FastStartFailoverThreshold Property

Course Objectives

• Repair data failures
• Use Flashback Archive, Transaction and LogMiner
• Perform online database application maintenance
• Protect your database with enhanced RMAN features
• Use enhanced Data Guard features