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 target audience 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

I needed formal training in Access to help run our company's custom database. This course helped explain a lot of procedures and greatly enhanced my understanding of setting up a database.
Douglas Norwood
Custom Storefronts, inc.
The course was just what I needed from an intro course. Answered my questions and gave me a background to move forward with HTML5.
Daniel Scanlan
American Water
The instructor is awesome.
Ginger Loverde
MetroPCS
I found this course to be invaluable. The instructor was friendly, knowledgeable, and engaging, and he clearly knew the program inside and out. The course is 7 hours long, but the day flew by quickly because it was very interactive, with lots of exercises spread throughout the day. I have taken other courses before through other training companies, and the quality and content of this course was far superior. I am pleased with the course, and really appreciate the instructional booklet which I will be able to refer to as needed as well.
Rebecca Cohen
Metsa Board Americas

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,011

Students who have taken Instructor-led Training

11,714

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