Oracle Database 11g R2 - RMAN Backup and Recovery

IT/Networking/Server/Operating Systems
Schedules
Optional
  IT Online Library (1 Year Subscription - $1595.00)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions
Overview

This Oracle Database 11g R2 - RMAN Backup and Recovery training class teaches students how to design, test, and implement a robust backup and recovery strategy.

The primary target audiences for this course includes database administrators, web server administrators, system administrators, implementation specialists, data center support engineers, and senior application designers and developers.

 

Goals
  1. Implement user-managed and automatically managed backup strategies and database recovery.
  2. Learn to use RMAN and other database facilities.
  3. Learn about database instance recovery, tuning checkpoints, the Redo Log File Size Advisor and the mTTR Advisor.
  4. Learn user-managed recovery scenarios, including recovery from temporary, read-only and index .
  5. Manage backup strategies and database recovery operations using RMAN .
  6. Learn complete and incomplete media recovery, including database point-in-time recovery and tablespace point-in-time recovery.
  7. Learn to build upon basic RMAN capabilities with a centralized recovery catalog. Deploy .
  8. Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution.
  9. Optimize backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for optimum efficiency.
  10. Learn data preservation through archival backups.
  11. Learn to duplicate databases for regulatory compliance, Real Application Testing database replay, test configuration, and other purposes.

Outline
  1. Instance Recovery
    1. About Instance Recovery
    2. Instance Recovery Parallelism
    3. changing RECOVERY_PARALLELISM
    4. MTTR Advisor and Tuning Checkpoints
    5. LOG_CHECKPOINTS_TO_ALERT
    6. Redo Logfile Size Advisor
    7. Fast-Start On-DEMAND Parallelism
  2. Configuring RMAN
    1. RMAN Architecture
    2. Launch and Use RMAN
    3. Configure RMAN Settings
    4. Allocate RMAN Channels
  3. Backup with RMAN
    1. About Backup File Types
    2. Performing Full Backups
    3. Performing Incremental Backups
    4. Establishing Backup Retention Policy
    5. Generate Reports
    6. Report Unrecoverable
    7. Report Need Backup
    8. List Incarnation
  4. RMAN Management with EM
    1. Monitoring the Flash Recovery Area
    2. The EM Interface to RMAN
    3. Scheduling RMAN Backups
    4. Oracle-Suggested Backup Strategy
    5. Manage Current Backups
    6. Backup Reports
    7. Manage Restore Points
  5. 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. Re-create The Password File
  6. Recovery with RMAN
    1. Complete Media Recovery
    2. Incomplete Media Recovery
    3. Recovery Using EM
  7. Using the RMAN Recovery Catalog
    1. Understanding Catalog Concepts
    2. Create the Recovery Catalog
    3. Manage Virtual Private Catalogs
    4. Protection of the Recovery Catalog
    5. Using RMAN Scripts
  8. Database Duplication and Cloning
    1. Why Perform Database Duplication?
    2. RMAN Duplicate Database
    3. RMAN Duplicate
    4. Database Cloning
  9. Advanced RMAN Capabilities
    1. Backup Optimization
    2. Enhancing Parallelism, Section Sizes
    3. Backup Performance and Control
    4. Minimize Time vs. Minimize Load
    5. Archival Backups
    6. Copying Files between Databases
  10. Transporting Tablespaces
    1. About Tablespace Transportation
    2. Read-only Tablespace Transportation
    3. Read-write Tablespace Transport
    4. Transport Tablespaces Using EM
  11. 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. Using the Data Recovery Advisor
    10. Block Media Recovery
    11. DBMS_REPAIR() ISOLATION

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

 

Class Prerequisites

Experience in the following is required for this Oracle class:

  • Database administration experience.
  • Resource manager and scheduler as well as RMAN backup and recovery experience.

Prerequisite Courses

Courses that can help you meet these prerequisites:

  • Introduction to SQL Training
  • Oracle PL/SQL Training

Course Setup
  • Live Online: Course Setup | WebEx Setup