Oracle Database 11g: Backup and Recovery Workshop Training

Oracle Database 11g: Backup and Recovery Workshop Training (11g-BU-REC-WKSH)


Oracle Database 11g: Backup and Recovery Workshop Training Course Description

This Oracle Database 11g: Backup and Recovery Workshop Training course will teach you how to evaluate your own recovery requirements. In this Oracle Database 11g: Backup and Recovery Workshop Training course you'll also learn to develop an appropriate strategy for backup and recovery procedures; please note that this course is based on Oracle Database 11g Release 2 Patch Set 1.

Learn To:

Develop appropriate backup and recovery procedures to address your business needs.
Employ Oracle Database recovery procedures to recover from media failure.
Use Flashback Technologies to complement backup and recovery procedures.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

Database Administrators
Technical Administrator
Technical Consultant

Oracle Database 11g: Backup and Recovery Workshop Training (11g-BU-REC-WKSH)Related Courses:

Duration: 3 days

Class Prerequisites:

Knowledge of Oracle Database administration
Knowledge of RMAN and Enterprise Manager

Skills Gained:

Perform tablespace point-in-time recovery
Describe the Oracle Database architecture components related to backup and recovery operations
Describe additional high availability features such as Oracle Data Guard and Oracle Secure Backup
Plan effective backup and recovery procedures
Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure
Configure the database for recoverability
Use Recovery Manager (RMAN) to create backups and perform recovery operations
Use the Data Recovery Advisor to diagnose and repair failures
Use Oracle Flashback Technologies to recover from human error
Perform an encrypted database backup and restore

Course Content:


Assessing Your Recovery Requirements
Data Failures Examples
Failure Categories
Oracle Data Protection Solutions
Oracle Backup and Recovery Solutions
Oracle Maximum Availability Architecture
Oracle Secure Backup (overview only)
Oracle Active Data Guard (overview only)

Using Recovery Manager (RMAN) and Enterprise Manager

Oracle Recovery Manager (architecture overview)
Enterprise Manager (backup and recovery interface overview)
Using the RMAN Command-Line
RMAN Commands (overview)
Configuring RMAN Persistent Settings
Viewing and Managing RMAN Persistent Settings

Configuring for Recoverability

Fast Recovery Area (overview)
Fast Recovery Area Sizing and Configuration
Control File Multiplexing Autobackup
Redo Log Files and the LGWR Process
Redo Log File Multiplexing
RCHIVELOG Mode and the Archiver Process
Archived Redo Log Files
Undo Retention

Using the RMAN Recovery Catalog

Repository Comparison
Recovery Catalog Overview
Creating the Recovery Catalog
Managing Records in the Catalog
Registering the Database
Catalog Resynchronization
Backing Up the Recovery Catalog

Backup Concepts and Strategies

Backup Solutions Overview
Backup Terminology
RMAN Backup Types
Understanding RMAN Backup Data Flow
Balancing Backup and Restore Requirements
Comparing Backup Strategies
Best Practices for Data Warehouse Backups

Creating Backups

Oracle Suggested Backup Strategy
Backups Sets Image Copies (RMAN)
Whole Database Backups
Read-Only Tablespace Backups
Checking for Block Corruption
Block Change Tracking/Fast Incremental Backups
Backup Compression RMAN Encrypted Backups
Control File Backups Cataloging Backups Files

Restore and Recovery Concepts

Employing the Best Oracle Technology for Recovery
Instance Failure and Instance/Crash Recovery
Media Failure
Complete Recovery (Overview)
Point-in-Time Recovery (Overview)
Recovery Through RESETLOGS
Recovery to an Abandoned Incarnation

Using Data Recovery Advisor

Data Recovery Advisor Overview
Using the Data Recovery Advisor (overview)
Using the Data Recovery Advisor in Enterprise Manager
Using the Data Recovery Advisor RMAN Command-Line Interface

Performing Recovery

Data File Loss (file system and ASM)
RMAN Recovery: NOARCHIVELOG Mode, Complete, Image Files Point-in-Time (Incomplete recovery)
Control File Loss and Recovery RMAN Recovery: Backup Control File
Redo Log File Loss and Recovery, Index Tablespace Recovery Read-Only Tablespace Recovery
Password Authentication File Re-creation, Server Parameter File Recovery Tempfile Recovery
Restoring RMAN Encrypted Backups
Block Media Recovery
Restore and Recovery Performance Best Practices

Using Flashback Technologies

Flashback Technologies Overview
Preparing to use Flashback Technologies
Flashback Query Flashback Version Query
Flashback Table
Flshback Transaction Query
Flashback Transaction
Flashback Drop
Best Practices for Undo-Based Flashback Technologies

Flashback Database

Flashback Database Architecture
Configuring Flashback Database
Performing Flashback Database
Best Practices for Flashback Database

RMAN Performance and Tuning

Tuning Principles
RMAN Multiplexing
Diagnosing Performance Bottlenecks
Restore and Recovery Performance Best Practices

Backup and Recovery Workshop Scenarios

Workshop Structure
Workshop Approach to Solving Failure Scenarios
Business Requirements for Database Availability and Procedures

Request More Information

Time Frame: 0-3 Months4-12 Months

Print Friendly, PDF & Email

No Comments Yet.

Leave a comment