SkillBuilders Welcome  |  Log in
All Oracle Classes

Backup and Recovery with Oracle 11g and 12c RMAN
3 Day Onsite or 21 Hour Online Hands-On Training

This training provides a hands-on introduction to the Oracle Recovery Manager (RMAN) utility for backup and recovery of Oracle databases. The training provides in-depth coverage of RMAN, for all releases up to 12c; RMAN architecture, installation and setup; executing RMAN commands; RMAN channels including parallel backups, manual and automatic allocation; all options for backup, restore and recovery; debugging RMAN; scripting and reporting; working with tapes; RMAN maintenance, and in-depth RMAN tuning.

"The instructor's willingness to work with us and our many questions surrounding how RMAN works with our new backup product - Actifio. He was phenomenal!"

"John [Watson], the instructor, is excellent!"


Oracle Certified Master
John Watson
Average Student Rating:

Introduction to Recovery Manager

  • What is RMAN?
  • Basic Features
  • RMAN Introduction Complete!

RMAN Architecture

  • RMAN Components
  • Component Releases
  • The Control File
  • CFRKT Parameter
  • Control File Creation
  • Control File Size
  • NOCATALOG Mode
  • Recovery Catalog
  • Recovery Catalog Maintenance

RMAN Setup

  • RMAN Installation
  • User "RMAN"
  • Password File
  • Oracle Net
  • Catalog Tablespace - SYSAUX 
  • Create Catalog
  • Register Database
  • RMAN Startup Options
  • The Flash Recovery Area 
  • Creating and using virtual private catalogues

Executing RMAN Commands

  • RMAN Command Basics
  • Job Blocks
  • 9i and Above Command Syntax
  • Using SQL Statements from the RMAN Console
  • Common Job Commands
  • Common Commands

RMAN Channels

  • Channel Concepts
  • Manual Allocation
  • Parallel Backups
  • Automatic Allocation

Backup with RMAN

  • Backup Concepts
  • Backup Set Concepts
  • Backupset Pieces
  • Using RMAN to Backup ASM Files
  • Control File AUTOBACKUP
  • Full Backup
  • Deleting Archive Logs After Backup
  • BACKUP Syntax
  • Interpreting BACKUP Command Output
  • Full Tablespace Backup
  • Compressed Backup 
  • Datafile Backup
  • Incremental Backup
  • Enabling Change Tracking 
  • Cumulative Incremental
  • Incrementally Updated Backup 
  • Using BACKUP for Image Copies 
  • Duplexing
  • Backup Archive Logs
  • Retention Policies
  • Recovery Window
  • Redundancy
  • Overriding Retention Policy
  • Using the Duration Parameter 

Restore & Recovery with RMAN

  • What Are We Protected Against?
  • Recovery-Related Commands
  • RESTORE Command
  • RESTORE PREVIEW 
  • RECOVER Command
  • Recover Deleted Files
  • Recover Lost Tablespace
  • Restore to New Location
  • PIT Recovery (1)
  • PIT Recovery (2)
  • PIT Recovery (3)
  • Control File Recovery
  • Recovering Through Incarnations 

Database duplication

  • For Standby
  • To create another primary
  • Duplication from backup or from the active database

Database flashback and the FRA

  • The Fast Recovery Area
  • Flashback technologies
  • Database flashback architecture
  • Configuring database flashback
  • Using database flashback
  • Database flashback and resetlogs

Debugging RMAN

  • RMAN Messages
  • Capturing RMAN Logs
  • Reading RMAN Messages
  • Useful Views
  • V$PROCESS / V$SESSION
  • V$SESSION.CLIENT_INFO
  • V$SESSION_LONGOPS
  • V$SESSION_WAIT
  • Terminating Disk Jobs
  • RMAN Debug Mode
  • Media Manager Debugging

Scripting and Reporting

  • Scripting
  • Reporting
  • Reporting: LIST
  • Reporting: REPORT
  • Reporting: Views
  • Reporting: SHOW

Getting Started With Tapes

  • Media Management Concepts
  • Installing the MML
  • Backup to Tape
  • Environment Variables
  • Default Tape Channels
  • Configurable Tape Settings
  • Setting Default SBT Channels
  • Backup with Default Channels
  • Tape Restore
  • V$SESSION_WAIT
  • Terminating Tape Jobs
  • Media Manager Debugging

RMAN Maintenance

  • Expired Backups
  • Cross-Checking Backups
  • Listing Expired Backups
  • Status of All Backups
  • Deleting Expired Backups
  • Obsolete Backups
  • Deleting Obsolete Backups
  • Retention Policy

Tuning RMAN

  • Getting Started
  • Oracle Benchmark
  • Performance Factors
  • Tuning Tools
  • Checking RMAN Progress
  • V$SESSION_WAIT
  • The S.A.M.E. Methodology
  • Parallelism
  • Parallelism Test
  • Sync vs. Async I/O
  • Enable Async IO to Tape
  • Sync vs. Async Test
  • V$SESSION.CLIENT_INFO
  • Tape Compression
  • Multiplexing
  • Multiplexing & Memory
  • Multiplexing Guidelines
  • Multiplexing Tests
  • Tape Buffer / Block Size
  • Slowing RMAN Down
  • Backup Optimization

RMAN Case Studies

  • Configure the daatabase for recoverability in all circumstances
  • Diagnose problems
  • Use the Recovery Advisor
  • # 1 - Lost Control File
  • # 2 - Lost online or archive redolog file(s)
  • # 3 - Tuning
  • # 4 - Dropped Tablespace
  • # 5 - Damaged critical datafile
  • # 6 - Damaged non-critical datafile
  • # 7 - Dropped schema
  • # 8 - Combinations of all the above
 
SkillBuilders Sample Video