Oracle Database 11g R2 - RMAN Backup and Recovery

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:

Preparing for Class

Training for your Team

Length: 3 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

Training for Yourself

$1,575.00 or 3 vouchers

Upcoming Classes

  • See More Classes

Please select a class.
  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

What people say about our training

Webucator has great online classes that make it easier to learn new skills or advance your existing skills from the comfort of your home or office.
William Rosky
Alaska Dept. Of Fish and Game
I liked the approach of presenting concepts supported by sample implementations.
Jeff Schmidt
GL Noble Denton
I really enjoyed every moment with my instructor. She always made me feel welcome and like I was on track.
Kellie Fedele
DeVry Inc
Our Webucator instructor made the experience of learning WordPress an exciting adventure!
Kim O'Leary
Northeast Document Conservation Center

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

60,496

Students who have taken Instructor-led Training

11,682

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

8.89

Students rated our Oracle Database 11g R2 - RMAN Backup and Recovery trainers 8.89 out of 10 based on 1 reviews

Contact Us or call 1-877-932-8228