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

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

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

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