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