Oracle 10g RMAN Training Class
Backup and Recovery with Oracle10g RMAN - 21 Hour Online Class or 3 Day Classroom
A hands-on introduction to Oracle’s Recovery Manager (RMAN) utility for backup and recovery. Covers an overview of RMAN including new features for Oracle 10g; RMAN architecture, installation and setup (including Oracle Net, Catalog Tablespace/SYSAUX in 10g startup options and the Flash Recovery Area); executing RMAN commands (including 8i Job Blocks and syntax for Oracle 9i and above); RMAN channels including parallel backups, manual and automatic allocation; BACKUP, AUTOBACKUP and an overview of backing up; restore and recovery; debugging RMAN; scripting and reporting; working with tapes; RMAN maintenance, and in-depth RMAN tuning.
Class Description:
This hands-on training is intended for experienced Oracle technologists** who need to use or evaluate Recovery Manager (RMAN), 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 Oracle10g compatible course is 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 (exception: Intro and Architecture chapters contain Q&A summary only).Audience: Oracle Database Administrators and Oracle operatorsPrerequisites ** : Students must possess a working knowledge of:
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:
|
Topic Summary
- Introduction to Recovery Manager
- What is RMAN?
- Basic Features
- 10g 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 (10g)
- Create Catalog
- Register Database
- RMAN Startup Options
- The Flash Recovery Area (10g)
- 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 (10g)
- Control File AUTOBACKUP
- Full Backup
- Deleting Archive Logs After Backup
- BACKUP Syntax
- Interpreting BACKUP Command Output
- Full Tablespace Backup
- Compressed Backup (10g)
- Datafile Backup
- Incremental Backup
- Enabling Change Tracking (10g)
- Cumulative Incremental
- Incrementally Updated Backup (10g)
- Using BACKUP for Image Copies (10g)
- Duplexing
- Backup Archive Logs
- Retention Policies
- Recovery Window
- Redundancy
- Overriding Retention Policy
- Using the Duration Parameter (10g)
- Restore & Recovery with RMAN
- What Are We Protected Against?
- Recovery-Related Commands
- RESTORE Command
- RESTORE PREVIEW (10g)
- 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 (10g)
- 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

