Oracle Database 11g: Backup and Recovery Workshop (ORA007)

Cours disponible en français ou en anglais - Training available in French or in English

Durée: 3 jours

Objectifs du cours :

After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course reviews the backup and recovery techniques that are discussed in the Oracle Database 11g: Administration Workshop I and II courses, and examines various backup, failure, restore, and recovery scenarios. Students are expected to have some knowledge of Recovery Manager (RMAN) and Enterprise Manager, as they will use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are also described as an additional way to recover from various errors. Extensive hands-on practices and workshops provide the student with experience in a realistic technical environment. This course includes interactive workshops that provide participants with the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.

Compétences acquises :

Les stagiaires seront à même d'effectuer les tâches suivantes :

Introduction

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

Connaissances requises :

Pour suivre ce cours, les stagiaires doivent disposer des connaissances suivantes :

Oracle Database Administration experience

Oracle Database 11g: Administration Workshop I