Contact Us

« Important Announcement » Contact Us 877-206-0106 | USA Flag

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.


Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.


Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.


Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Oracle Database 12c: Backup and Recovery Workshop

2,800 USD
4 Days
Classroom Training, Online Training

AWS Training Pass

Take advantage of flexible training options with the AWS Training Pass and get Authorized AWS Training for a full year.

Learn More

Prices reflect a 22.5% discount for IBM employees (wherever applicable).
Prices reflect a 24% discount for Kyndryl employees (wherever applicable).
Prices reflect the Accenture employee discount.
Prices shown are the special AWS Partner Prices.
Prices reflect the Capgemini employee discount.
Prices reflect the UPS employee discount.
Prices reflect the ??democompanyname?? employee discount.
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, please go to GSA Advantage.

Class Schedule

Delivery Formats

Sort results

Filter Classes

Guaranteed to Run





    Sorry, there are no public classes currently scheduled in your country.

    Please complete this form, and a Training Advisor will be in touch with you shortly to address your training needs.

View Global Schedule

Course Description


All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. The objective of this training is to assist you in doing just that.

Among the tools and facilities that you will learn to use are the Oracle Recovery Manager (RMAN), the Enterprise Manager 12c Cloud Control, the Data Recovery Advisor, Oracle Flashback technologies, Redo Log File Size Advisor and the MTTR Advisor. Since it can be tempting to short-cut appropriate backup procedures if these perform poorly, special attention is given to backup performance and optimization.

This course is applicable to certification training as an Oracle Database 12c Administrator Certified Professional (OCP) for 'Exam 1Z1-063 Oracle Database 12c: Advanced Administration' and certification training as an Oracle Certified Implementation Specialist for 'Exam 1Z0-497 Oracle Database 12c: Essentials'.


The objectives for this course are as follows:
  • Automatically managed backup strategies and database recovery operations using RMAN, the Enterprise Manager Cloud Control, and other database facilities.
  • Database instance recovery, tuning checkpoints, the Redo Log File Size Advisor and the MTTR Advisor.
  • User-managed recovery scenarios, including recovery from temporary, read-only and index tablespaces.
  • Complete and incomplete media recovery, including database point-in-time, tablespace and table point-in-time recovery.
  • Configure a centralized recovery catalog. Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution.
  • Optimizing backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for optimum efficiency.
  • Achieve data preservation through archival backups.
  • Duplicate and clone databases for regulatory compliance, Real Application Testing database replay, test configuration and other purposes.
  • Tablespace transportation, database transportation, cross-platform transportation and endian format conversion.
  • Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor.
  • Newly released or enhanced features such as backup file compression, encryption, parallelization and others.
  • Recovering from logical failure using appropriate Oracle Flashback technologies, such as Flashback Table, Flashback Drop and Flashback Database.


  • Database administrators
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Senior application designers and developers


    • DBOR-950 and DBOR-951 Oracle Database 12C: SQL Fundamentals (Levels I & II), or equivalent experience
    • DBOR-955 Oracle Database 12C: Install & Upgrade Workshop, or equivalent experience
    • DBOR-956 Oracle Database 12C: Architecture & Internals, or equivalent experience
    • DBOR-957 Oracle Database 12C: Administration Workshop, or equivalent experience


  • Getting Started: About Database Failure & Recovery
    • Backup & Recovery Facilities
    • HA & MAA
    • The Backup Administrator
    • Backup Storage Technologies
  • Getting Started: Configure The Database For Recovery
    • Manage Redo Data
    • Manage Archived Redo Data
    • About The Fast Recovery Area
    • Recoverability Checklist
  • Getting Started: Automatic Instance Recovery
    • About Instance Recovery
    • Mean Time To Recover (MTTR)
    • Instance Recovery Parallelism
    • Mttr Advisor & Checkpoint Tuning
    • Redo Logfile Size Advisor
    • FAST-START ON-DEMAND Parallelism
    • RMAN Architecture
    • Launch & Use RMAN
    • Configure RMAN Settings
    • RMAN Channels
  • Backup: Perform RMAN Backups
    • Consistent VS. Inconsistent Backups
    • Backup File Types
    • RMAN Backup Sets
    • RMAN Image Copies
    • Full Backups
    • Incremental Backups
    • Retention Policies & Obsolete Files
    • Expired Backup Entries
    • Rman Backup Reports
    • Report Unrecoverable
    • Report Need Backup
    • List Incarnation
  • Backup: RMAN Management With EM
    • Monitoring The Fast Recovery Area
    • The EM Interface To RMAN Backup
    • About Backup Guided Workflows
    • Schedule Customized Backup
    • Schedule Oracle-Suggested Backup
    • Manage Current Backups
    • Backup Reports
    • Restore Points
    • Backup Encryption
  • The RMAN Recovery Catalog
    • RMAN Catalog Concepts
    • Create The Base Catalog
    • Register A Target Database
    • Manage The Centralized Catalog
    • Virtual Private Catalogs
    • Protection Of The Recovery Catalog
    • Using RMAN Scripts
  • Recovery: User-Managed Recovery
    • Recovery Concepts
    • Recover Temporary Tablespaces
    • Recover Read-Only Tablespaces
    • Recover Index Tablespaces
    • Recover Redo Log Group Member
    • Recreate The Password File
  • Recovery: RMAN Recovery
    • Complete Recovery
    • Partial But Complete Recovery
    • RMAN Failure Diagnosis
    • Incomplete Recovery
    • Recovery Using EM
    • EM User Directed Recovery
    • EM Oracle Advised Recovery
    • Decryption During Restore
  • Advanced: Enhanced RMAN Capabilities
    • Backup Optimization
    • Parallelism With Section Sizes
    • Backup Performance & Control
    • Minimize Time Vs. Minimize Load
    • Archival Backups
  • Advanced: Database Duplication & Cloning
    • Why Perform Database Duplication?
    • RMAN Duplicate Operation
    • RMAN Duplicate
    • Database Cloning With Em
  • Advanced: Data Transportation
    • About Transportation
    • Read-Only TS Transportation
    • Read-Write TS Transportation
    • Cross-Platform TS Transportation
    • Database Transportation
    • EM Tablespace Transportation
  • Advanced: Handling Corruption With Data Recovery Advisor
    • Understanding Failure & Corruption
    • How Does Corruption Occur?
    • Detecting Corruption
    • Analyze
    • Recovering From Corruption
    • Block Media Recovery
    • Isolating Corruption
    • DBMS_REPAIR() Units
    • About ADMIN_TABLES()
    • About CHECK_OBJECT()
    • About DUMP_ORPHAN_KEYS()
  • Flashback: About Oracle Flashback Technology
    • About Flashback Technology
    • Flashback & Database Security
    • Configuration For Flashback
  • Flashback: Recovery Using Oracle Flashback Technology
  • 2023 Top 20 Training Industry Company - IT Training

    Need Help?

    Call us at 877-206-0106 or e-mail us at

    Personalized Solutions

    Need a personalized solution for your Training? Contact us, and one of our training advisors will help you find the best solution.

    Contact Us

    Need Help?

    Do you have a question about the courses, instruction, or materials covered? Do you need help finding which course is best for you? We are here to help!

    Talk to us

    20% Off All Project Management Training Courses

    Maximize project efficiency and profitability across the board.


    20% Off All AI Training Courses

    IBM TechXchange Conference 2024

    October 21-24 | Mandalay Bay, Las Vegas

    Save $127 with Code: TECHXCHANGE10

    Offer Expires June 30, 2024

    Self-Paced Training Info

    Learn at your own pace with anytime, anywhere training

    • Same in-demand topics as instructor-led public and private classes.
    • Standalone learning or supplemental reinforcement.
    • e-Learning content varies by course and technology.
    • View the Self-Paced version of this outline and what is included in the SPVC course.
    • Learn more about e-Learning

    Course Added To Shopping Cart







    Self-Paced Training Terms & Conditions


    Sorry, there are no classes that meet your criteria.

    Please contact us to schedule a class.

    STOP! Before You Leave

    Save 0% on this course!

    Take advantage of our online-only offer & save 0% on any course !

    Promo Code skip0 will be applied to your registration

    Nothing yet
    here's the message from the cart

    To view the cart, you can click "View Cart" on the right side of the heading on each page
    Add to cart clicker.

    Purchase Information

    ??elearning-coursenumber?? ??coursename??
    View Cart

    Need more Information?

    Speak with our training specialists to continue your learning journey.


    Delivery Formats


    By submitting this form, I agree to LearnQuest's Terms and Conditions

    heres the new schedule
    This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.
    Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.