Overview of Course

Oracle Database 12c R2: Backup and Recovery Workshop Ed 3 is a comprehensive course that provides you with the skills and knowledge to develop and implement backup and recovery strategies for Oracle databases. You will learn how to design, test, and implement a backup and recovery plan to ensure the integrity and availability of your data.

Watch Full Course

Course Highlights

Highlight Icon

Learn to design and implement a backup and recovery strategy for Oracle databases

Highlight Icon

Understand the various backup and recovery options available in Oracle Database 12c R2

Highlight Icon

Develop skills to manage backup and recovery scenarios, including point-in-time recovery and flashback technology

Key Differentiators

  • Checked Icon

    Personalized Learning with Custom Curriculum

    Training curriculum to meet the unique needs of each individual

  • Checked Icon

    Trusted by over 100+ Fortune 500 Companies

    We help organizations deliver right outcomes by training talent

  • Checked Icon

    Flexible Schedule & Delivery

    Choose between virtual/offline with Weekend options

  • Checked Icon

    World Class Learning Infrastructure

    Our learning platform provides leading virtual training labs & instances

  • Checked Icon

    Enterprise Grade Data Protection

    Security & privacy are an integral part of our training ethos

  • Checked Icon

    Real-world Projects

    We work with experts to curate real business scenarios as training projects

Contact Learning Advisor!

Inquiry for :

Skills You’ll Learn


Develop and implement a backup and recovery strategy for Oracle databases


Perform backup and recovery operations using RMAN


Configure and manage recovery scenarios


Troubleshoot common backup and recovery issues


Implement advanced recovery features such as Oracle Data Guard and flashback technology

Training Options

Training Vector
Training Vector
Offer Vector

1-on-1 Training

USD 1,500 / INR 125,000
  • Option Item Access to live online classes
  • Option Item Flexible schedule including weekends
  • Option Item Hands-on exercises with virtual labs
  • Option Item Session recordings and learning courseware included
  • Option Item 24X7 learner support and assistance
  • Option Item Book a free demo before you commit!
Offer Vector

Corporate Training

On Request
  • Option Item Everything in 1-on-1 Training plus
  • Option Item Custom Curriculum
  • Option Item Extended access to virtual labs
  • Option Item Detailed reporting of every candidate
  • Option Item Projects and assessments
  • Option Item Consulting Support
  • Option Item Training aligned to business outcomes
For Corporates
vectorsg Unlock Organizational Success through Effective Corporate Training: Enhance Employee Skills and Adaptability
  • Choose customized training to address specific business challenges and goals, which leads to better outcomes and success.
  • Keep employees up-to-date with changing industry trends and advancements.
  • Adapt to new technologies & processes and increase efficiency and profitability.
  • Improve employee morale, job satisfaction, and retention rates.
  • Reduce employee turnovers and associated costs, such as recruitment and onboarding expenses.
  • Obtain long-term organizational growth and success.

Course Reviews


  • Describe Oracle Database Architecture
  • Explain the Oracle Database Instance
  • Understand the Oracle Database Storage Architecture

  • Define the Terminology and Concepts of Backup and Recovery
  • Plan your Backup and Recovery Procedures
  • Overview of Flashback Technology

  • Configure the Database for Recoverability
  • Use the RMAN Recovery Catalog

  • Maintain the Recovery Catalog
  • Use RMAN Stored Scripts

  • Create Backups
  • Perform User-Managed Backup and Recovery

  • Use RMAN to Perform Recovery
  • Use RMAN to Duplicate a Database

  • Tune RMAN
  • Troubleshoot RMAN

  • Learn how to perform backup encryption using RMAN
  • Understand the importance of securing data and how encryption helps
  • Practice creating and restoring encrypted backups

  • Understand how to diagnose and troubleshoot database failures
  • Identify common issues that cause database failures
  • Learn how to use diagnostic tools such as Automatic Diagnostic Repository (ADR)

  • Understand the concepts of restore and recovery
  • Learn about the types of recovery scenarios and when to use them
  • Practice creating and testing restore and recovery scenarios

  • Learn how to perform media recovery using RMAN
  • Understand how to restore datafiles, tablespaces, and control files
  • Practice performing recovery operations

  • Learn how to perform complete recovery, incomplete recovery, and point-in-time recovery
  • Understand the scenarios where these types of recoveries are needed
  • Practice performing different recovery scenarios

  • Learn how to integrate RMAN with Oracle Secure Backup
  • Understand the benefits of using Oracle Secure Backup for backup and recovery
  • Practice configuring and using Oracle Secure Backup with RMAN

  • Understand how to perform tape backups and restores using RMAN
  • Learn about the advantages and disadvantages of tape backups
  • Practice performing tape backup and restore scenarios

  • Learn about flashback technologies and their benefits
  • Understand how to use Flashback Query, Flashback Table, and Flashback Transaction Query
  • Practice using flashback technologies to recover data

  • Understand how to use Flashback Database to restore the database to a previous point-in-time
  • Learn about the requirements and limitations of using Flashback Database
  • Practice using Flashback Database to restore the database

  • Learn how to manage backup space by using backup compression and backupset duplication
  • Understand how to transport data between databases using Data Pump Export and Import
  • Practice managing backup space and transporting data between databases

  • Understand how to duplicate a database using RMAN
  • Learn about the different scenarios where database duplication is needed
  • Practice duplicating a database using RMAN.

  • Learn how to tune RMAN performance for backup and recovery operations
  • Understand RMAN parallelism and how to configure it
  • Practice tuning RMAN performance and benchmarking backup and recovery operations

  • Apply the concepts and skills learned in previous modules in a comprehensive workshop
  • Work with real-world scenarios and simulate backup and recovery operations
  • Practice troubleshooting and resolving issues in a backup and recovery environment

  • Understand the Oracle Database Cloud Service and its features
  • Learn how to provision and manage Oracle databases in the cloud
  • Practice deploying, configuring, and managing Oracle databases in the cloud.
Hanger Icon
Contact Learning Advisor
  • RedtickMeet the instructor and learn about the course content and teaching style.
  • RedtickMake informed decisions about whether to enroll in the course or not.
  • RedtickGet a perspective with a glimpse of what the learning process entails.
Phone Icon
Contact Us
(Toll Free)
Inquiry for :


Section Icon

Target Audience:

  • Database Administrators
  • Support Engineer
  • Technical Consultant
Section Icon


  • Working knowledge of SQL and PL/SQL
  • Basic knowledge of the Oracle database architecture
  • Familiarity with Oracle Database 12c R2 SQL workshop
Section Icon

Benefits of the course:

  • Develop in-demand skills for managing backup and recovery operations in Oracle databases
  • Enhance your knowledge of Oracle Database 12c R2 architecture and recovery features
  • Hands-on experience with real-world scenarios to reinforce concepts learned
  • Gain confidence in designing, implementing, and troubleshooting backup and recovery strategies
Section Icon

Exam details to pass the course:

  • There is no exam required to pass the course, but participants will receive a certificate of completion upon finishing the course.
Section Icon

Certification path:

  • To obtain the Oracle Database 12c Administrator Certified Professional certification, you must pass two exams: Oracle Database 12c: Installation and Administration (1Z0-062) and Oracle Database 12c: Advanced Administration (1Z0-063).
  • This course can help prepare you for the Advanced Administration exam.
Section Icon

Career options:

  • Database Administrator
  • Backup and Recovery Specialist
  • Data Protection Officer
  • Technical Consultant

Why should you take this course from Skillzcafe:

Why should you take this course from Skillzcafe:
  • Bullet Icon Expert instructors with years of experience in Oracle database management and backup and recovery strategies 
  • Bullet Icon Hands-on labs and exercises to reinforce the concepts learned in the course
  • Bullet Icon Flexible learning options, including self-paced e-learning and instructor-led virtual classrooms
  • Bullet Icon Access to a community of fellow learners and experts for support and networking
  • Bullet Icon Skillzcafe is an Oracle Authorized Education Partner, ensuring the highest quality training and materials


This course uses Oracle Database 12c R2.

You will need access to an Oracle Database 12c R2 environment to complete the hands-on exercises. Skillzcafe provides a virtual lab environment for course participants.

Question Vector
Equip your employees with the right skills to be prepared for the future.

Provide your workforce with top-tier corporate training programs that empower them to succeed. Our programs, led by subject matter experts from around the world, guarantee the highest quality content and training that align with your business objectives.

  • 1500+

    Certified Trainers

  • 200+


  • 2 Million+

    Trained Professionals

  • 99%

    Satisfaction Score

  • 2000+


  • 120+


  • 180+


  • 1600%