Oracle Database 19c Backup and Recovery with RMAN Training Course

Course Contents - DAY 1

Course Introduction

• • Administration and Course Materials
• • Course Structure and Agenda
• • Delegate and Trainer Introductions

Session 1: 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

Session 2: 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

Session 3: 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

Session 4: 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

Oracle Database 19c Backup and Recovery with RMAN Training Course

Course Contents - DAY 2

Session 5: 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

Session 6: 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

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

Session 8: 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

Session 9: ENCRYPTED RMAN BACKUPS

• • Create an Encrypted RMAN Backup
• • Transparent Encryption
• • Password Encryption
• • Use Different Encryption Modes

Oracle Database 19c Backup and Recovery with RMAN Training Course

Course Contents - DAY 3

Session 10: 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

Session 11: 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

Session 12: 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

Session 13: 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

Oracle Database 19c Backup and Recovery with RMAN Training Course

Course Contents - DAY 4

Session 14: TABLESPACE POINT IN TIME RECOVERY (TSPITR)

• • Tablespace-Point-in-Time Overview
• • Tablespace-Point-in-Time Example

Session 15: TRANSPORT DATA

• • Transport Tablespaces
• • Transport Databases

Session 16: 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

Session 17: MONITOR,TUNE AND TROUBLESHOOT BACKUP AND RECOVERY

• • Tune Recovery Manager Overview
• • Restore and Recovery Performance Best Practices
• • Multiplexing in RMAN
• • Diagnosing Performance Bottlenecks