Skip Navigation Links

Course Length:
5 Days
Course Description:
Oracle Database 11g: Backup and Recovery training teaches students how to backup and recover a portion or all of an Oracle 11g database.
Who Should Attend:
This course is for students interested in safeguarding Oracle 11g databases.
Benefits of Attendance:
Upon completion of this course, students will be able to:
  • Use Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability.
  • Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flashback Transaction Backout wizard, database Recovery Wizard, Recovery Advisor interface, and others.
  • Setup database instance recovery, tuning checkpoints, the Redo Log File Size Advisor, and the MTTR Advisor.
  • Implement User-managed recovery scenarios, including recovery from temporary, read-only, and index tablespaces.
  • Implement automatically managed backup strategies and database recovery operations using RMAN and other database facilities.
  • Build upon basic RMAN capabilities with a centralized recovery catalog.
  • Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution.
  • Optimize backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for efficiency.
  • Set up data preservation through archival backups.
  • Implement security through transparent and explicit encryption features.
  • Duplicate databases for regulatory compliance, Real Application Testing database replay, test configuration, and other purposes.
  • Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor.
Prerequisites:
Students should have taken Oracle Database 11g: Administration Workshop I and Oracle Database 11g: Introduction to SQL or have equivalent real-world experience.
Course Outline:
  • Recovery Concepts
    1. About The Backup & Recovery Structures
    2. Managing Redo Data
    3. Managing Archived Redo Data
    4. Creating A Foundation For Sound Recovery
  • Oracle Flashback Technology
    1. About Flashback Technology
    2. Flashback Query
    3. Select...As Of Timestamp
    4. Select...As Of SCN
    5. Configuring Undo Management For Flashback
    6. Undo_Retention
    7. Flashback Table
    8. Flashback Drop
    9. Flashback Versions Query
    10. Flashback Transaction Query
    11. Flashback Transaction Backout
  • Flashback Database
    1. About Flashback Database
    2. Configuring The Flash Recovery Area
    3. Performing Database Flashback
    4. Monitoring Flashback Performance
    5. Flashback Database Considerations
    6. Configure Flashback Data Archive
  • Instance Recovery
    1. About Instance Recovery
    2. Instance Recovery Parallelism
    3. Mttr Advisor & Tuning Checkpoints
    4. Log_Checkpoints_To_Alert
    5. Redo Logfile Size Advisor
    6. Fast-Start On-Demand Parallelism
  • Configuring RMAN
    1. RMAN Architecture
    2. Launch & Use RMAN
    3. Configure RMAN Settings
    4. Allocate RMAN Channels
  • Backup With RMAN
    1. About Backup File Types
    2. Performing Full Backups
    3. Performing Incremental Backups
    4. Establishing A Backup Retention Policy
    5. Generate Reports
    6. Report Unrecoverable
    7. Report Need Backup
    8. List Incarnation
  • RMAN Management With EM
    1. Monitoring The Flash Recovery Area
    2. The EM Interface To RMAN
    3. Scheduling RMAN Backups
    4. Using The Oracle-Suggested Backup Strategy
    5. Manage Current Backups
    6. Backup Reports
    7. Manage Restore Points
  • User-Managed Recovery Operations
    1. Recovery Concepts
    2. Recover Temporary Tablespaces
    3. Recover Read-Only Tablespaces
    4. Recover Index Tablespaces
    5. Recover Redo Log Group Member
    6. Recreate The Password File
  • Recovery With RMAN
    1. Complete Media Recovery
    2. Incomplete Media Recovery
    3. Recovery Using EM
  • Using The RMAN Recovery Catalog
    1. Understanding Catalog Concepts
    2. Create The Recovery Catalog
    3. Manage Virtual Private Catalogs
    4. Data Protection Of The Recovery Catalog
    5. Using RMAN Scripts
  • Database Duplication & Cloning
    1. Why Perform Database Duplication?
    2. RMAN Duplicate Database
    3. RMAN Duplicate
    4. Database Cloning
  • Advanced RMAN Capabilities
    1. Backup Optimization
    2. Enhancing Parallelism With Section Sizes
    3. Archival Backups
    4. Backup Set Encryption
    5. Copying Files Between Databases
  • Transporting Tablespaces
    1. About Tablespace Transportation
    2. Read-Only Tablespace Transportation
    3. Read-Write Tablespace Transportation
    4. Transport Tablespaces Using EM
  • Recovering From Corruption With Data Recovery Advisor
    1. How Does Corruption Occur?
    2. Detecting Corruption
    3. Analyze
    4. V$Database_Block_Corruption View
    5. Db_Block_Checking
    6. Db_Block_Checksum
    7. Db_Lost_Write_Protect
    8. Db_Ultra_Safe
    9. Recovery Using The Data Recovery Advisor
    10. Block Media Recovery
    11. Isolating Corruption With Dbms_Repair()
  • Conclusion