Oracle Database 19c: Backup and Recovery

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 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

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

*Course fee/person - Subject to minimum 4 registrations. (Public/Private schedule)