Oracle Database 19c: Backup and Recovery

Oracle Database 19c: Backup and Recovery Certification Training Course Overview

Enroll for the 4-day Oracle Database 19c: Backup and Recovery from Koenig Solutions accredited by Oracle. This course is designed to give an Oracle database administrator practical experience in planning and implementing a backup and recovery strategy using Recovery Manager and Flashback Database.

Through a blend of hands-on labs and interactive lectures you will also learn how to perform backup and recovery operations using RMAN and also various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures

Target Audience:

  • Administrator
  • Database Administrator

Learning Objectives:

The Oracle Database 19c Backup and Recovery course is designed to provide the skills needed to enable a delegate to plan and implement a backup and recovery strategy in the workplace for Oracle Databases using RMAN and Flashback Database technologies.

 

 

Oracle Database 19c: Backup and Recovery (32 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2800
02 - 05 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 09 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3250
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions
Module 2: BACKUP AND RECOVERY CONSIDERATIONS
  • 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
Module 3: ORACLE RECOVERY STRUCTURES AND PROCESSES
  • 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
Module 4: FLASHBACK
  • 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
Module 5: RECOVERY MANAGER OVERVIEW
  • RMAN Features and Components
  • The sysbackup 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
Module 6: CREATE AND CONFIGURE A RECOVERY CATALOG
  • 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
Module 7: BACKUP WITH RMAN
  • 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
Module 8 ADVANCED BACKUP TECHNIQUES
  • 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
Module 9: MAINTAIN A RECOVERY CATALOG
  • 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
Module 10: ENCRYPTED RMAN BACKUPS
  • Create an Encrypted RMAN Backup
  • Transparent Encryption
  • Password Encryption
  • Use Different Encryption Modes
Module 11: DATABASE FAILURE DIAGNOSTICS
  • 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
Module 12: OVERVIEW OF RESTORE AND RECOVERY
  • 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
Module 13: BASIC RESTORE AND RECOVER WITH RMAN
  • 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
Module 14: ADVANCED RESTORE AND RECOVER WITH RMAN
  • 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
Module 15: TABLESPACE POINT IN TIME RECOVERY (TSPITR)
  • Tablespace-Point-in-Time Overview
  • Tablespace-Point-in-Time Example
Module 16: TRANSPORT DATA
  • Transport Tablespaces
  • Transport Databases
Module 17: CREATE A DUPLICATE DATABASE WITH RMAN
  • 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
Module 18: MONITOR,TUNE AND TROUBLESHOOT BACKUP AND RECOVERY
  • Tune Recovery Manager Overview
  • Restore and Recovery Performance Best Practices
  • Multiplexing in RMAN
  • Diagnosing Performance Bottlenecks
Download Course Contents

Request More Information

Course 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