Oracle Database 11g : Backup and Recovery Workshop


This Oracle Database 11g: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll 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.


By enrolling in this course, you'll get a chance to participate in hands-on practices and workshops that give you experience working within a realistic technical environment. These interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.


Oracle Database 11g Release 2 ( Patch Set 1


• 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)

• 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

• 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

• 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 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

• 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

• 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

• 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

• 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

• 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 Architecture • Configuring Flashback Database • Performing Flashback Database • Best Practices for Flashback Database

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

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


Case Studies


Pre Test
Post Test
Certification Exam


3 Days

Target Audience

Database Administrators , Technical Consultant , Technical Administrator


Sep 2017Dec 2017