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:

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 Live Online 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 is easy and accessible. The instructors are very knowledgeable and hands-on; it was just like being in a real classroom.
Amy McCormick
tw telecom
I liked the individualized instruction from my teacher. I like that she asked about my work and then tailored the class to the information that I needed.
Veronica Hobson
Weatherford
I can't stress enough how enjoyable and thorough today's Excel class was. The instructor was patient and articulate in her delivery. I will be recommending Webucator to my colleagues, friends and family. Money well spent!
Sasha Mitchell
n/a
This was my first Webucator class and I wasn't sure what to expect but the price was right and the course schedule fit my schedule. I'm really impressed and will be back for more!
Randy Berner
Comptroller of the Currency

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,793

Students who have taken Instructor-led Training

11,791

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