Oracle Database 19c: Backup and Recovery Course

24 hours of learning duration

Curriculum is divided into 17 modules

Gain an introduction to backup & recovery concepts

Convenience in payment of fees

Blended learning options

4.8/5

6456 Enrolled

Overview

What we’re going to teach you

Configure RMAN for backup operations
Perform full and incremental backups
Utilise backup optimization techniques
Manage backup retention and catalog
Perform complete database recovery
Configure and manage Data Guard
Execute point-in-time recovery processes

Learning objectives

Upon finishing the training, you will master

Grasp Oracle Database 19c architecture for effective backup and recovery understanding

Gain hands-on expertise in installing and configuring databases tailored for robust backup operations

Manage database storage structures proficiently to optimise backup strategies and streamline recovery processes

Implement stringent user security measures to protect databases and their backup files

Master Oracle Recovery Manager (RMAN) for efficient backup, restore, and troubleshooting, ensuring data continuity

Ready to get started?

Prerequisites

To enrol for the Oracle Database 19c: Backup and Recovery Course, the prerequisites include:

Experience with SQL and PL/SQL for basic database operations.
Knowledge of operating systems such as Linux, Unix, or Windows is necessary, along with the ability to execute basic commands in those environments.

Overall ratings by our students

Upcoming sessions

Our Trainer

Learners Point has a reputation for high-quality training that makes a difference in people's lives. We undertake a practical and innovative approach to working closely with businesses to improve their workforce. Our expertise is wide-ranging with ample support from our expert trainers who are globally recognized and hold a diverse set of experiences in their field of expertise. We are proud of our instructors who take ownership of our distinctive and comprehensive training methodologies, help our students imbibe those with ease, and accomplish gracefully.

We at Learners Point believe in encouraging our students to embark upon a journey of lifelong learning and self-development, with the aid of our comprehensive and distinctive courses tailored to current market trends. The manifestation of our career-oriented approach is what we assure through a pleasant professional enriched environment with cutting-edge technology, and an outstanding while highly acknowledged training staff that uses up-to-date methodologies and quality course material. With our aim to mold professionals to be future leaders, our industry expert trainers provide the best in town mentorship to our students while endowing them with the thirst for knowledge and inspiring them to strive for professional and human excellence.

Related courses

Curriculum

Plan and Implement a Backup and Recovery Strategy
Define a Disaster Recovery Plan
Test a Backup and Recovery Plan
Advantages and Disadvantages of Different Backup Methods
Backup Methods Comparison
Data Recovery Strategy
Backup Strategy
Validate the Recovery Strategy

Architectural Components of Backup and Restore
Physical Database Structures
Logical Database Structures
Dynamic Performance Views
Redo Logs, Checkpoints and Archives
Use the Flash Recovery Area (FRA)
The Archivelog Modes of a Database

Configure and Use Flashback Database
Monitor Flashback Database
Flash Recovery Area Space Usage
Flashback Query
Retrieve Row History with Flashback Versions Query
Audit or Recover From Transactions with Flashback Transactions Query
Flashback Table
Recover Dropped Tables with Flashback Drop
The Recycle Bin
Recover Tables to a Point in Time With Flashback Table
Flashback Database
Flashback Restore Points
Flashback Transaction Backout
Flashback Data Archive

RMAN Features and Components
The sys backup Privilege
RMAN Commands
Connect to RMAN
Specify the Location of RMAN Output
Start-Up and Shut Down a Target Database Using RMAN
Issue SQL Commands in RMAN

Create a Recovery Catalog
Register a Database
Unregister a Database
Control File Information
Virtual Private Catalogs
Backup a Recovery Catalog
Use a Flashback Recovery Area with RMAN
Configure Persistent RMAN Settings
Set Retention Policies
Configure Control File Autobackups
Integrate RMAN with a Media Manager

Channel Allocation
Types of RMAN Backup
Recovery Manager Commands
Performing Backups
Closed and Open Backups
Incremental Backups
Fast Incremental Backups using Block Change Tracking
Backup File Image Copies
Oracle Suggested Backup
Validate Backups
Listing Backups

Create Multisection Backups
Create Duplexed Backup Sets
Create Compressed Backups
Backup the Control File to a Trace File
Backup Recovery Files
Backup up ASM Metadata

Change the Availability Status of Backups and Copies
Catalog Backups Made with Operating System Commands
Generate Backup Reports and Lists
Cross Check Backups and Copies
Delete Backups
Update the Repository after Backup Deletion
Drop Database and Archival Backups
Import and Export the Recovery Catalog
Use Data Dictionary Tables

Create an Encrypted RMAN Backup
Transparent Encryption
Password Encryption
Use Different Encryption Modes

The Automatic Diagnostic Repository
The Data Recovery Advisor
Understanding RMAN Messages and the Error Stack
Diagnose Data File Loss
Recovery with RESETLOGS
Dealing with Block Corruption

Restore and Recover
Instance Failure and Crash Recovery
Media Failure
An Overview of Complete Recovery
An Overview of Point-in-Time Recovery
Recovery with RESETLOGS

Perform Recovery in Noarchivelog Mode
Perform Complete Recovery in Archivelog Mode
Use the Flash Recovery Area for Fast Recovery
Automatic Tempfile Recovery
Identify the Database Files to Restore and Recover
Preview Backups used in Restore Operations
Apply Incremental Backups to Restore Datafile Image Copies
The Switch Command
The Data Recovery Advisor
Perform Incomplete Recovery (PITR)
Restore and Recover a tablespace
Restore and Recover Datafiles
Recover a Datafile Not Backed Up
Table Recovery from Backups
Recover Individual Data Blocks
The Data Recovery Advisor

Restore the Server Parameter File
Restore the Control File
Re-create the Password File
Handling Redo Log File Loss
Restore and Recover the Database on a New Host
Restore RMAN Encrypted Backups
Disaster recovery

Tablespace-Point-in-Time Overview
Tablespace-Point-in-Time Example

Transport Tablespaces
Transport Databases

Database Duplication
Duplication Options
Create Files for the Duplicate Database
Prepare the Auxiliary Instance for Duplication
Create a Duplicate Database
Clone a Running Database
An Overview of Using Cloud Control to Clone a Running Database
Targetless Duplication of a Database
Duplication Enhancements from 18c

Tune Recovery Manager Overview
Restore and Recovery Performance Best Practices
Multiplexing in RMAN
Diagnosing Performance Bottlenecks

Frequently asked questions

The course equips you with crucial skills in database backup, recovery, and Oracle Recovery Manager. It enhances career opportunities by providing hands-on expertise in ensuring data protection and continuity.

The target audience includes database administrators aiming to enhance Oracle backup and recovery skills, IT professionals working with Oracle Database 19c, data recovery managers seeking proficiency, system analysts managing databases, technical consultants exploring Oracle products, and IT instructors specializing in database management and recovery strategies.

The Oracle Database 19c: Backup and Recovery Certification course is conducted in two languages. They are English and Arabic.

Learners Point offers 3 kinds of classes for the Oracle Database 19c: Backup and Recovery Certification course. Participants can choose from instructor-led classroom-based group coaching, one-on-one training sessions, or high-quality live and interactive online sessions. The training sessions are interactive, immersive, and intensive hands-on programs.

A participant is liable for a 100% refund, if he or she wishes to withdraw the application from the Oracle Database 19c: Backup and Recovery Course. However, the refund is approved only if we get a written application within 2 days after registration. The refund is processed within 4 weeks from the date of discontinuation.