Oracle Database 19c: Backup and Recovery

COURSE TOPICS

Module 1: Backup and Recovery: Overview

• Backup and Recovery: Overview
• Understanding Instance Recovery

Module 2: Backup and Recovery Configuration

• Backup and Recovery Configuration
• Configuring Demo
• Control File Demo
• Adding a Redo file to Redo Group – Demo
• Enabling ARCHIVELOG mode in a Database – Demo
• Practice 2-1: Verifying that the Control File is Multiplexed
• Practice 2-2: Configuring the Size of the Fast Recovery Area
• Practice 2-3: Verifying that the Redo Log File Is Multiplexed
• Practice 2-4: Configuring ARCHIVELOG Mode

Module 3: Using Recovery Manager (RMAN)

• Using Recovery Manager
• Connection the RMAN and a Target Database Demo
• Using the sequel and RMAN Demo
• Managing the Setting RMAN Demo
• Practice 3-1: Configuring the Default Backup Destination
• Practice 3-2: Setting the Date and Time Format for RMAN
• Practice 3-3: Configuring RMAN Settings

Module 4: Backup Strategies

• Backup Strategies

Module 5: Creating Database Backups

• Creating Database Backups
• Fast Incremental Backup
• Syntex and Clause in RMAN Use for Backups Demo
• Creating Image Copies for Backups Demo
• Creating a Whole Backups Container or Noncontainer Database system Demo
• Creating a Partial PDP Backups Demo
• Maintaning the Block Change Tracking File Demo
• Backing up to Control Files to Trace File Demo
• Practice 2-1: Backing Up the Control File
• Practice 2-2: Verifying Automatic Backups of the Control File and SPFILE
• Practice 2-3: Creating a Whole Database Backup
• Practice 2-4: Creating Partial Database Backups
• Practice 2-5: Configuring Block Change Tracking
• Practice 2-6: Using Incremental Backups
• Practice 2-7: Backing Up Additional Database Files

Module 6: Using Optional Backup Features

• Using Optional Backup Features
• Compres Backup Demo
• Creating Duplex Backups Set by Backups Copies Demo
• Creating Backups of Backups Set Demo
• Creating archival Backups with RMAN Demo
• Backing ups Recovery File Demo
• Practice 3-1: Creating an Archival Backup

Module 7: Tuning RMAN Backup Performance

• Tuning RMAN Backup Performance
• Asynchronous I/O Bottlenecks
• Practice 4-1: Monitoring an RMAN Backup Job

Module 8: Recovery Catalog: Overview

• Recovery Catalog: Overview

Module 9: Creating a Recovery Catalog

• Creating a Recovery Catalog
• Configure a Recovery Catalog Database Demo
• Creating a Recovery Catalog Owner Demo
• Creating a Recovery Catalog Demo
• Practice 2-1: Creating a Recovery Catalog Owner
• Practice 2-2: Creating the Recovery Catalog

Module 10: Managing Target Database Records

• Managing Target Database Records
• Register a Database in Recovery Catalog Demo
• Manually Resynchronizing Recovery Catalog – Demo
• Practice 3-1: Registering a Database in the Recovery Catalog
• Practice 3-2: Configuring the Recovery Catalog for Recovery

Module 11: Using Stored Scripts

• Using Stored Scripts
• Practice 4-1: Creating a Stored Script
• Practice 4-2: Executing a Stored Script

Module 12: Creating and Using Virtual Private Catalogs

• Creating and Using Virtual Private Catalogs
• Practice 5-1: Enabling the Virtual Private Database (VPD) Functionality
• Practice 5-2: Creating a Virtual Private Catalog
• Practice 5-3: Backing Up a PDB

Module 13: Restore and Recovery Concepts

• Restore and Recovery Concepts
• Instance Failure

Module 14: Diagnosing Failure

• Diagnosing Failure
• Data Recovery Advisor
• Diagnosing Failure Using Oracle Database Recovery Advisor Demo
• Practice 2-1: Diagnosing and Repairing Database Failure

Module 15: Performing Complete Recovery

• Performing Complete Recovery
• Performing Complete Recovery Using RMAN Demo
• Practice 3-1: Recovering from the Loss of a System-Critical Data File
• Practice 3-2: Recovering from the Loss of an Application Data File

Module 16: Performing Point-in-Time Recovery

• Performing Point-in-Time Recovery
• Architecture Tablespace Point-in-Time Recovery
• Performing Incomplete Recovery Using Data Recovery Advisor RMAN Demo
• Practice 4-1: Recovering from Media Failure: Incomplete Recovery
• Practice 4-2: Recovering a Table from a Backup

Module 17: Performing Block Media Recovery

• Performing Block Media Recovery
• Performing a Recovery Block Media Corruption Demo
• Practice 5-1: Repairing Block Corruption

Module 18: Performing Additional Recovery Operations

• Performing Additional Recovery Operations
• Practice 6-1: Recovering from the Loss of a Parameter File
• Practice 6-2: Restoring the Control File
• Practice 6-3: Recovering from the Loss of All Control Files
• Practice 6-4: Restoring the Password File

Module 19: Oracle Flashback Technology: Overview

• Oracle Flashback Technology: Overview

Module 20: Using Logical Flashback Features

• Using Logical Flashback Features
• Flashback Drop and the Recycle Bin
• Prepare to Using Flashback Technology Demo
• Practice 2-1: Preparing to Use Flashback Technologies
• Practice 2-2: Restoring a Dropped Table
• Practice 2-3: Using Flashback Table

Module 21: Using Flashback Database

• Using Flashback Database
• Enabling Oracle Flashback Database Demo
• Practice 3-1: Enabling Flashback Logging
• Practice 3-2: Performing Flashback Database

Module 22: Using PDB Snapshot

• Using PDB Snapshot

Module 23: Database Duplication Overview

• Database Duplication Overview
• Demo (Part 01)

Module 24: Creating a Backup-Based Duplicate Database

• Creating a Backup-based for Duplicate Database
• Allocating Auxiliary Channels
• Demo (Part 02)
• Practice 2-1: Duplicating a Database (Part I)
• Practice 2-1: Duplicating a Database (Part II)
• Practice 2-2: Duplicating a PDB into an Existing CDB