| All Oracle Classes |
|
|
|
Backup and Recovery with Oracle10g RMAN: |
Print to PDF |
|
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?).
This class has not been reviewed online yet.
4.6 out of 5
Student Rating
