Oracle9I Database Backup & Recovery – DBA II Course

One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This course presents all the standard failure scenarios and the best recovery strategies for each. Backup strategies for cold backups, on-line backups, complete and partial backups are discussed. Extensive exercises allow students to simulate failures and perform actual recovery within the workshop.

This course is designed for Oracle database administrators.

Upon completion of this course, the participant will be able to:
>Utilize the various archive modes that the database may operate in and the effect on recovery capabilities of each mode.
>Utilize advanced database configuration options that assist recovery of lost data.
>Build a backup and recovery strategy with user-managed techniques.
>Build a backup and recovery strategy with server-managed techniques and the RMAN tool.
>Configure standby databases as part of disaster recovery using Oracle Data Guard.
>Apply techniques that not only recover lost data but endeavor to do so efficiently and rapidly, allowing a quick return to normal operations

Database Recovery Structures
The Mechanisms For Recovery
SQL Statement Execution 
Examining The Recovery Components
Identifying The Data Structures
Data Structures Within The Database
Identifying The Tablespaces
Identifying The Control Files
Identifying The Alert & Trace Files
Identifying The Redo Log Files

Archiving
Development Of Backup & Recovery Strategies
Managing The Archive Options
User-Managed Physical Backups
Backup Characteristics
Performing A Full Backup
Performing An Offline Tablespace Backup
Performing An Online Tablespace Backup
Performing Suspend Mode Backups
Performing A Control File Backup
An Overview To Database Recovery
The Recovery
Identifying The Type Of Failure

Instance Recovery & Fast-Start
User-Managed Complete Media Recovery
Media Failure Concepts
Complete Closed Recovery
Complete Open Recovery
Handling Special Situations
User-Managed Incomplete Media Recovery
About Incomplete Recovery
Point-In-Time Based Recovery
Handling Special Situations
User-Managed Incomplete Media Recovery
About Incomplete Recovery
Point-In-Time Based Recovery
Handling & Anticipating Stuck Recoveries
About Stuck Recoveries
Handling Corruption Of Data
Performing Trial Recovery
User-Managed Recovery Troubleshooting
Move Data File Location
Recovery With No Data File Backup
Handling Read Only Tablespaces
Handling The Loss Of Control Files

Using The Recovery Manager (RMAN)
Using The Recovery Catalog
Confirming Registration & Other Operations
Using Run Blocks & Scripts
Allocating Channels
Accessing RMAN Via OEM

Server-Managed Backups With RMAN
Performing Full Backups
Performing Incremental Backups
Exploring Enhanced RMAN Capabilities
Resume Failed Backup Operations
Establishing A Backup Retention Policy
Show All Configuration Settings
Generate Catalog Reports
Report Schema
List Incarnation
Server-Managed Recovery With RMAN
Recovery Manager Recovery
Performing Restoration & File Media Recovery
Performing Block Media Recovery
Standby Databases With Oracle Data Guard
About The Data Guard Architecture
Data Guard Interfaces
Data Guard Configuration & Operation
Configuring Log Transport
Configuring Log Apply
Database Switchover Operations
Database Failover Operation
Monitoring The Standby Database

Oracle9i SQL (RT 262)
Oracle9i Advanced SQL (RT 258)
Oracle9i PL/SQL Language (RT 275)
Oracle9i Database Administration - DBA I (RT 264)