Oracle Database 11g: Backup and Recovery Workshop

Course DateLocationDaysPriceRegister
Call for Classroom Training Dates3 $2,895Register


Course DateLocationDaysPriceRegister
Feb 28, 2018Live Virtual - 10:00 am Eastern3 $2,760Register
Nov 8, 2017Live Virtual - 11:00 am Eastern3 $2,760Register


Oracle Database 11g: Backup and Recovery Workshop

Description: 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. This course is based on Oracle Database 11g Release 2 Patch Set 1.

Duration: 3 Days

Audience:

  • Database Administrators
  • Technical Consultant
  • Technical Administrator

Required Prerequisites:

  • Knowledge of Oracle Database administration
  • Oracle Database 11g: Administration Workshop I DBA Release 2
  • Oracle Database 11g: Administration Workshop II DBA Release 2

Suggested Prerequisites:

  • Knowledge of RMAN and Enterprise Manager

Topics:

  • 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

    Course DateLocationDaysPriceRegister
    Call for Classroom Training Dates3 $2,895Register


    Course DateLocationDaysPriceRegister
    Feb 28, 2018Live Virtual - 10:00 am Eastern3 $2,760Register
    Nov 8, 2017Live Virtual - 11:00 am Eastern3 $2,760Register