OVERVIEW
This hands-on class is intended for experienced Oracle technologists who need to use or evaluate Recovery Manager, Oracle's utility for backup and recovery. Personnel new to backup and recovery or those currently using user-managed backup techniques will benefit from this class. This course includes a comprehensive and practical introduction to RMAN including architecture, setup, backup, restore and recovery, recovery catalog maintenance, debugging, tuning and reporting. Every lesson contains many working examples and at least one hands-on workshop.
DURATION: 3 Days
AUDIENCE:
Oracle Database Administrators and Oracle operators
PREREQUISITES:
- 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
- Backup and recovery concepts are helpful but not necessary (e.g. what is a point in time recovery?).
OBJECTIVES
After successfully completing this course, you will be able to:
- Use RMAN to backup your databases to disk or tape
- Use RMAN to backup Automatic Storage Management (ASM) files
- Use RMAN to restore and recover databases
- Tune RMAN operations (disk and tape)
- Perform full and incremental backups (to disk or tape) of databases, tablespaces and datafiles
- Perform complete and incomplete (point in time) recoveries
- Backup and Recover the control file
- Use the features such as compressed backups, change tracking and recovery through database incarnations
- Create RMAN scripts
- Allocate channels to employ parallelism and other tuning techniques
- Generate RMAN reports to determine what can be recovered, what needs to be backed up and more.
- Maintain the RMAN recovery catalog and target database control file
- Use special RMAN features such as backup set duplexing, restore validation and more
CONTENT
- Introduction to Recovery Manager
- What is RMAN?
- Basic Features
- 11g New 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
- Executing RMAN Commands
- RMAN Command Basics
- 8i 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
- 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