Oracle Database 19c: Backup and Recovery Course Overview

Enroll for the 5-day Oracle Database 19c: Backup and Recovery from this course 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.

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

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

Oracle Database 19c: Backup and Recovery/1z0-083 Singapore.