Course Overview
The student begins by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.
What are the skills covered
Upon completion of this course, the student should be able to:
- Develop appropriate backup and recovery procedures to address your business needs.
- Implement backup and recovery settings and perform backup operations to disk and tape.
- Employ Oracle Database recovery procedures to recover from media and other failures.
- Diagnose and repair data failures.
- Use flashback technologies and data duplication to complement backup and recovery procedures.
- Secure the availability of your database by appropriate backup and recovery strategies.
Who should attend this course
- Administrator
- Database Administrator
Course Curriculum
What are the Prerequisites
- Oracle Database: Administration Workshop
- Basic knowledge of Linux operating system
- A working knowledge of SQL and PL/SQL packages
- Basic understanding of Oracle Database architecture
- Familiarity with basic database monitoring procedures
Download Course Syllabus
Course Modules
- Target Audience
- Prerequisites
- Learning Outcomes
- Course Outline
- What’s next?
- Objectives
- DBA Responsibilities
- Separation of DBA Duties
- Assessing Your Recovery Requirements
- Categories of Failure
- Statement Failure
- User Process Failure
- Network Failure
- User Error
- Instance Failure
- Media Failure
- Data Failures
- Instance Recovery
- The Checkpoint (CKPT) Process
- The Redo Log Files and the Log Writer (LGWR) Process
- Database Log Mode
- Automatic Instance Recovery or Crash Recovery
- Phases of Instance Recovery
- Tuning Instance Recovery
- Using the MTTR Advisor
- Restoring and Recovering
- Comparing Complete and Incomplete Recovery
- The Complete Recovery Process
- The Point-in-Time Recovery Process
- Oracle Data Protection Solutions
- Flashback Technology
- Summary
- Objectives
- Configuring for Recoverability
- Configuring the Fast Recovery Area
- Monitoring the Fast Recovery Area
- Multiplexing Controlfiles
- Redo Log Files
- Multiplexing the Redo Log
- Creating Archived Redo Log Files
- Archiver (ARCn) Process
- Archived Redo Log Files: Naming and Destinations
- Configuring ARCHIVELOG Mode
- Summary
- Objectives
- Integrated Oracle Recovery Manager (RMAN)
- Connecting to RMAN and a Target Database
- Using SQL in RMAN
- Types of RMAN Commands
- Job Commands: Example
- Configuring Persistent Settings for RMAN
- Viewing Persistent Settings
- Managing Persistent Settings
- Specifying a Retention Policy
- Recovery Window Retention Policy: Example
- Summary
- Objectives
- Understanding Types of Backups
- Backup Terminology
- RMAN Backup Types
- Backup Solutions: Overview
- Balancing Backup and Restore Requirements
- Comparing Backup Strategies
- Option 1: Full and Incremental Backups
- Option 2: Incrementally Updated Disk Backups
- Option 3: Offloading Backups to Physical Standby Database in Data Guard Environment
- Backing Up Read-Only Tablespaces: Considerations
- Data Warehouse Backup and Recovery: Best Practices
- Summary
- Objectives
- Understanding Types of Backups
- Backup Terminology
- RMAN Backup Types
- Backup Solutions: Overview
- Balancing Backup and Restore Requirements
- Comparing Backup Strategies
- Option 1: Full and Incremental Backups
- Option 2: Incrementally Updated Disk Backups
- Option 3: Offloading Backups to Physical Standby Database in Data Guard Environment
- Backing Up Read-Only Tablespaces: Considerations
- Data Warehouse Backup and Recovery: Best Practices
- Summary
- Objectives
- Saving Backup Space with Unused Block Compression
- Compressing Backups
- Using RMAN Backup Compression
- Using a Media Manager
- Configuring Backup and Restore for Very Large Files
- Backing Up and Restoring Very Large Files
- Creating RMAN Multisection Backups
- Creating Proxy Copies
- Creating Duplexed Backup Sets Using BACKUP COPIES
- Creating Backups of Backup Sets
- Archival Backups: Concepts
- Creating Archival Backups with RMAN
- Managing Archival Database Backups
- Backing Up Recovery Files
- Summary
- Objectives
- Is there a problem?
- Diagnosing Performance Bottlenecks
- Diagnosing Performance Bottlenecks: Read Phase
- Is there a “write” problem?
- Diagnosing Performance Bottlenecks: Write or Copy Phase
- Using Dynamic Views to Diagnose RMAN Performance
- Monitoring RMAN Job Progress
- Identifying Backup and Restore Bottlenecks
- Asynchronous I/O Bottlenecks
- Synchronous I/O Bottlenecks
- Tuning RMAN Backup Performance
- Parallelization of Backup Sets
- RMAN Multiplexing
- Summary
- Objectives
- RMAN Repository Data Storage: Comparison of Options
- Storing Information in the Recovery Catalog
- Reasons to Use a Recovery Catalog
- Summary
- Objectives
- Creating a Recovery Catalog: Three Steps
- Configuring the Recovery Catalog Database
- Creating the Recovery Catalog Owner
- Creating the Recovery Catalog
- Summary
- Objectives
- Managing Target Database Records in the Recovery Catalog
- Registering a Database in the Recovery Catalog
- Unregistering a Target Database from the Recovery Catalog
- Recovery Catalog Resynchronization: Concepts
- Manually Resynchronizing the Recovery Catalog
- Summary
- Objectives
- Using RMAN Stored Scripts
- Executing RMAN Stored Scripts
- Maintaining RMAN Stored Scripts
- Summary
- Objectives
- Creating and Using Virtual Private Catalogs
- Creating a Virtual Private Catalog
- Managing Virtual Private Catalogs
- Upgrading Catalog
- Upgrading Virtual Private Catalogs
- Upgrading Catalog Example
- Upgrading Catalog
- Summary
- Objectives
- File Loss
- Data Repair Techniques
- Restoring and Recovering
- Using RMAN RESTORE and RECOVER Commands
- Instance Failure
- Instance Recovery
- Phases of Instance Recovery
- Media Failure
- Comparing Complete and Incomplete Recovery
- Complete Recovery Process
- Point-in-Time Recovery Process
- Recovery with the RESETLOGS Option
- Restore and Recovery Performance: Best Practices
- Summary
- Objectives
- Reducing Problem Diagnosis Time
- Automatic Diagnostic Workflow
- Automatic Diagnostic Repository
- ADR Command-Line Tool (ADRCI)
- V$DIAG_INFO View
- Data Failure: Examples
- Summary
- Objectives
- Ensuring Backups Are Available
- Restoring in NOARCHIVELOG Mode
- Recovery with Incremental Backups in NOARCHIVELOG Mode
- Performing Complete Recovery
- Review: Recovering Image Copies
- Recovering Image Copies: Example
- Performing a Fast Switch to Image Copies
- Using SET NEWNAME for Switching Files
- Using Restore Points
- PDB Temp File Recovery
- PDB SYSTEM or UNDO Tablespace Recovery
- PDB Non-SYSTEM Tablespace Recovery
- Summary
- Objectives
- Point-in-Time Recovery
- PITR Terminology
- Performing Point-in-Time Recovery
- When to Use TSPITR
- Tablespace Point-in-Time Recovery: Architecture
- Preparing for TSPITR
- Determining the Correct Target Time
- Determining the Tablespaces for the Recovery Set
- Identifying Objects That Will Be Lost
- Performing RMAN TSPITR
- Performing Fully Automated TSPITR
- Improving TSPITR Performance
- Performing RMAN TSPITR with an RMAN-Managed Auxiliary Instance
- Performing RMAN TSPITR Using Your Own Auxiliary Instance
- Troubleshooting RMAN TSPITR
- PITR of PDBs
- Recovering Tables from Backups
- Table Recovery: Graphical Overview
- Prerequisites and Limitations
- Specifying the Recovery Point in Time
- Process Steps of Table Recovery
- Summary
- Objectives
- What is block corruption?
- Block Corruption Symptoms: ORA-01578
- How to Handle Corruption
- Setting Parameters to Detect Corruption
- Block Media Recovery
- Prerequisites for Block Media Recovery
- Recovering Individual Blocks
- Best Practice: Proactive Checks
- Checking for Block Corruption
- Summary
- Objectives
- Recovery from the Loss of the Server Parameter File
- Restoring the Server Parameter File from the controlfile Autobackup
- Loss of a controlfile
- Recovering from the Loss of All controlfile Copies: Overview
- Restoring the controlfile from Autobackup
- Restoring the SPFILE and the controlfile
- Recovering NOLOGGING Database Objects
- Loss of a Redo Log File
- Log Group Status: Review
- Recovering from the Loss of a Redo Log Group
- Clearing a Log File
- Re-creating a Password Authentication File
- Summary
- Objectives
- Configuring Database Flashback Technologies
- Flashback Technologies: Error Detection and Correction
- Review: Transactions and Undo
- Flashback Technology
- Summary
- Objectives
- Using Flashback Technologies to Query Data
- Flashback Query
- Flashback Version Query
- Flashback Table: Overview
- Flashback Table
- Flashback Table: Considerations
- Flashback Transaction Query
- Flashback Transaction Query: Considerations
- Flashback Transaction Backout
- Flashback Transaction Backout Options
- Flashing Back a Transaction
- Best Practices: Undo-Based Flashback Query, Flashback Table
- Flashback Drop and the Recycle Bin
- Recycle Bin
- Bypassing the Recycle Bin
- Using Flashback Time Travel
- Creating and Enabling Flashback Time Travel
- How the Flashback Data Archive Works
- Transparent Schema Evolution
- Full Schema Evolution
- Summary
- Objectives
- Preparing Your Database for Flashback
- Guaranteeing Undo Retention
- Undo Retention
- Flashback Database: Continuous Data Protection
- Flashback Database
- Flashback Database Architecture
- Configuring Flashback Database
- Configuring Flashback Database Overview
- Configuring Flashback Database Parameters
- Configuring Flashback Database Log Management
- Flashback Database: Examples
- CDB and PDB Flashback
- Flashback Database Considerations
- Monitoring Flashback Database Information
- Flashback Database and Guaranteed Restore Points
- Guaranteed Restore Points
- PDB Flashback and Clean Restore Point
- Summary
- Objectives
- Overview
- Methods of Transporting with Recovery Catalog
- Prerequisites: Generic
- Prerequisites: Specific
- Recovery Catalog Methods for PDBs
- Quickly Transport a PDB with Recovery Catalog
- Transport a PDB Using a Preexisting Backup with Recovery Catalog
- Transport a PDB Using Multiple Incremental Backups with Recovery Catalog
- Recovery Catalog Methods for Tablespaces
- Quickly Transport a Tablespace with Recovery Catalog
- Transport a Tablespace Using a Preexisting Backup with Recovery Catalog
- Transport a Tablespace Using Multiple Incremental Backups with Recovery Catalog
- Transport a PDB Using Multiple Incremental Backups with Recovery Catalog
- Summary
- Objectives
- Methods of Transporting in NOCATALOG Mode
- Prerequisites: Generic
- Prerequisites: Specific
- NOCATALOG Mode for PDBs
- Quickly Transport a PDB in NOCATALOG Mode
- Transport a PDB Using a Preexisting Backup in NOCATALOG Mode
- Transport a PDB Using Multiple Incremental Backups in NOCATALOG Mode
- NOCATALOG Mode for Tablespaces
- Quickly Transport a Tablespace in NOCATALOG Mode
- Transport a Tablespace Using a Preexisting Backup in NOCATALOG Mode
- Transport a Tablespace Using Multiple Incremental Backups in NOCATALOG Mode
- Summary
- Objectives
- Methods of Transporting Over Network Link
- Prerequisites: Generic
- Methods of Transporting PDBs Over Network Link
- Transporting PDBs Over Network Link
- Quickly Transport a PDB Over Network Link
- Transport PDBs by Restoring Backups Incrementally Over the Network
- Methods of Transporting Tablespaces Over Network Link
- Transport Tablespaces Over Network Link
- Quickly Transport a Tablespace Over Network Link
- Transport Tablespaces by Restoring Backups Incrementally Over the Network
- Summary
- Objectives
- PDB Snapshot Carousel
- Creating PDB Snapshots
- Creating PDBs Using PDB Snapshots
- PDB Snapshots Basics
- PDB Snapshots Views
- Dropping PDB Snapshots
- Flashing Back PDBs Using PDB Snapshots
- Summary
- Objectives
- Using a Duplicate Database
- Choosing Database Duplication Techniques
- Duplicating an Active Database with “Push”
- Comparing the “Push” and “Pull” Methods of Duplication
- Duplicating a Database with a Target Connection
- Duplicating a Database with a Recovery Catalog
- Duplicating a Database Without a Recovery Catalog or Target Connection
- Summary
- Objectives
- Creating a Backup-Based Duplicate Database
- Creating an Initialization Parameter File for the Auxiliary Instance
- Specifying New Names for Your Destination
- Using the SET NEWNAME Clauses
- Substitution Variables for SET NEWNAME
- Specifying Parameters for File Naming
- Starting the Instance in NOMOUNT Mode
- Ensuring Backups and Archived Redo Log Files Are Available
- Allocating Auxiliary Channels
- Understanding the RMAN Duplication Operation
- Specifying Options for the DUPLICATE Command
- Using Additional DUPLICATE Command Options
- Duplicating Selected PDBs in a CDB
- Cloning an Active PDB into an Existing CDB
- Example: Duplicating PDB1 from CDB1 to CDB2 as PDB1
- Example: Duplicating PDB1 from CDB1 to CDB2 as PDB2
- Summary
Request More Information
Training Options
- ILT: Instructor-Led Training
- VILT: Virtual Instructor-Led Training
Intake: 23-27 Mar 2026
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Exam:
[yith_ywraq_button_quote product="144495"]
[yith_ywraq_button_quote product="144496"]
Intake: 23-27 Mar 2026
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Exam:
[yith_ywraq_button_quote product="144497"]
[yith_ywraq_button_quote product="144498"]
Intake: 11-15 May 2026
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Price:
RM6,750.00 Original price was: RM6,750.00.RM6,000.00Current price is: RM6,000.00.Enroll Now
RM7,812.00 Original price was: RM7,812.00.RM7,062.00Current price is: RM7,062.00.Enroll Now
Exam:
[yith_ywraq_button_quote product="144499"]
[yith_ywraq_button_quote product="144500"]
Intake: 11-15 May 2026
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Price:
RM6,750.00 Original price was: RM6,750.00.RM6,000.00Current price is: RM6,000.00.Enroll Now
RM7,812.00 Original price was: RM7,812.00.RM7,062.00Current price is: RM7,062.00.Enroll Now
Exam:
[yith_ywraq_button_quote product="144501"]
[yith_ywraq_button_quote product="144502"]
Intake: 20-24 Jul 2026
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Exam:
[yith_ywraq_button_quote product="144503"]
[yith_ywraq_button_quote product="144504"]
Intake: 20-24 Jul 2026
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Exam:
[yith_ywraq_button_quote product="144505"]
[yith_ywraq_button_quote product="144506"]
Intake: 21-25 Sep 2026
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Exam:
[yith_ywraq_button_quote product="144507"]
[yith_ywraq_button_quote product="144508"]
Intake: 21-25 Sep 2026
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Exam:
[yith_ywraq_button_quote product="144509"]
[yith_ywraq_button_quote product="144510"]
Intake: 16-20 Nov 2026
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Exam:
[yith_ywraq_button_quote product="144511"]
[yith_ywraq_button_quote product="144512"]
Intake: 16-20 Nov 2026
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Exam:
[yith_ywraq_button_quote product="144513"]
[yith_ywraq_button_quote product="144514"]
Exam & Certification
Oracle Database AI: Backup and Recovery Certification Training Course
