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

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

• # 1 - Lost Control File
• # 1 - Solution
• # 2 - Lost CNTL File, No Cat
• # 2 - Solution
• # 3 - Tuning
• # 3 - Solution
• # 4 - Dropped Tablespace
• # 4 - Solution

Students must possess a working knowledge of:

• Oracle architecture (e.g. What is archiving? What is the control file?)
• Oracle startup and shutdown (e.g. What is MOUNT mode? What is the parameter file?)
• Some DDL commands such as CREATE TABLESPACE

This class has not been reviewed online yet.

Read reviews of all SkillBuilders classes.

4.8 out of 5

Student Rating