ONLINE CLASSES

Backup and Recovery with Oracle10g RMAN:
21-Hour Online Class and Hands-On Workshop.

A hands-on introduction to the Oracle Recovery Manager (RMAN) utility for backup and recovery of Oracle8i, 9i and 10g databases. The training provides in-depth coverage 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.

Cost: $1,185

Upcoming Class Schedule

Dates Times (ET) Location Availability
No Events Scheduled at this time. Call 1.888.803.5607 or email us to schedule this class

Enrollment includes:

  • Review recordings of your class sessions online, any time* what is this?
  • 300+ page coursebook (hardcopy)
  • Headset
  • Workshop solutions and sample code
  • Certificate of Completion what is this?
  • 100% Satisfaction Guarantee what is this?
  • Bring a colleague and receive a $25 Amazon.com gift certificate what is this?

 

  • 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

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?).

4.6 out of 5

Student Rating

SkillBuilders Sample Video