Oracle Database 18c: Backup and Recovery Workshop Ed 1 | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Oracle Database 18c: Backup and Recovery Workshop Ed 1

  • On Demand Class Icon
    On Demand
    • HRDF SBL Claimable
    • Certificate of Attendance available
    • 90 days of access from date of activation
    Starting From
    RM 5025.00
    40 Hours
  • Private Class Icon
    Private Class
    • All of our private classes are customized to your organization's needs.

      Click on the button below to send us your details and you will be contacted shortly.
    0 Days

Course Details

Expand All
In this course, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are included so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several database related failure situations.

• Database Administrators

• Support Engineer

• Technical Consultant

• Technical Administrator

• Data Warehouse Administrator

Suggested Prerequisite

• Knowledge of SQL and PL/SQL (for DBA use)

• Knowledge of Oracle Database 18c

• Basic knowledge of Linux operating system

Required Prerequisite

• Oracle Database 18c: Administration Workshop

This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises

After completing this course, students will be able to:

• Describe the Oracle Database architecture components related to backup and recovery operations

• Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure

• Plan effective backup and recovery procedures

• Configure the database for recoverability

• Use Recovery Manager (RMAN) to create backups and perform recovery operations

• Use the Data Recovery Advisor to diagnose and repair failures

• Perform an encrypted database backup and restore

• Perform tablespace point-in-time recovery

• Use Oracle Flashback Technologies to recover from human error


Expand All

• Oracle Maximum Availability Architecture

• Assess your recovery requirements
• Categories of failures
• Basic Workshop Architecture
• Curriculum Context
• Oracle backup and recovery solutions
• Overview of Oracle Secure Backup and Oracle Data Guard

• Oracle DBA tools for backup and recovery

• Connecting to Oracle Recovery Manager (RMAN)

• Review of Oracle Database architecture

• Configuring and managing persistent settings

• Multiplexing the control file

• RMAN commands

• Archiving redo log files

• Using the Fast Recovery Area (FRA)

• Multiplexing redo log files

• Creating and Configuring the Recovery Catalog

• Using RMAN Stored Scripts

• Using Virtual Private Catalogs

• Managing Target Database Records in the Recovery Catalog

• Maintaining and Protecting the Recovery Catalog

• Backing Up Read-Only Tablespaces

• Balancing Backup and Restore Requirements

• Backup Terminology

• Data Warehouse Backup and Recovery: Best Practices

• RMAN Backup Types

• Oracle-Suggested Backup

• Reporting on Backups

• Managing Backups

• Fast Incremental Backup

• Incrementally Updated Backups

• Block Change Tracking

• Creating and Managing Archival Backups

• Cataloging Additional Backup Files

• Using a Media Manager

• Compressing Backups

• Backing Up Recovery Files

• Backing Up the Control File to a Trace File

• Backup and Restore for Very Large Files

• Using Dual-Mode Encryption

• Creating RMAN-Encrypted Backups

• Restoring Encrypted Backups

• Using Password-Mode Encryption

• Using Transparent-Mode Encryption

• Automatic Diagnostic Repository

• Performing Block Media Recovery

• Using the Data Recovery Advisor

• Reducing Problem Diagnosis Time

• Complete Recovery (Overview)

• Instance Failure and Instance/Crash Recovery

• Restoring and Recovering

• Point-in-Time Recovery (Overview)

• Recovery with the RESETLOGS Option

• Media Failure

• Using RMAN for Recovery in NOARCHIVELOG Mode

• Performing Complete Recovery

• Using Restore Points

• Using Image Files for Recovery

• Performing Database Point-in-Time Recovery

• Performing Fully Automated TSPITR

• When to use Tablespace Point-in-Time Recovery (TSPITR)

• TSPITR Architecture

• Recovering Tables from Backups

• Recovery of Server Parameter File (SPFILE)

• Performing Disaster Recovery

• Recovering from the Loss of a Redo Log File Group

• Restoring the Database to a New Host

• Restoring the Control File

• Flashback Transaction Query

• Using Flashback Technology to Query Data

• Flashback Table

• Flashback Data Archive

• Flashback Technology: Overview

• Flashback Drop and the Recycle Bin

• Configuring Flashback Database

• Performing Flashback Database

• Flashback Database Architecture

• Creating Guaranteed Restore Points

• Best Practices for Flashback Database

• Transporting Data Across Platforms

• Database Transport: Using Data Files

• Transporting Data with Backup Sets

• Performing RMAN TS Point-in-time Recovery

• When to use TSPITR

• Recovering Tables from Backups

• TSPITR Architecture

• Understanding the RMAN Duplication Operation

• Comparing the “Push” and “Pull” Methods

• Choosing Database Duplication Techniques

• Creating a Backup-Based Duplicate Database

• Using a Duplicate Database

• Interpreting RMAN Message Output

• Tuning RMAN Backup Performance

• Configuring RMAN Multiplexing

• Diagnosing Performance Bottlenecks

• Workshop Structure and Approach

• Diagnosing the Failures

• Business Requirements for Database Availability and Procedures


See All


based on 0 ratings reviews