10g Backup & Recovery

Backup and Recovery Overview

Understanding the structures and processes for backup and recovery.
Introduce the different methods for backup and recovery
Diagnose and troubleshoot database problems.
Understand Oracle Recovery Manager

Backup and Recovery

Recovery structures and processes
Backup and recovery configuration
Types of failure and troubleshooting
Complete recovery
Incomplete media recovery
Export and import utilities
Test Recovery
ALTER DATABASE END BACKUP

Oracle Recovery Manager

RMAN command line prompt
Recovery Manager Architecture
Setting up Recovery Manager
Database space requirements and privileges
Creating and running backup and recovery scripts from RMAN
Using LIST and REPORT options from Recovery Manager
Crash Recovery workshop,
Tips and tricks when using Recovery Manager.
Persistent Parameters
Block Level recovery

Enterprise Manager Utilities

Catalog Maintenance Using Enterprise Manager
Creating an EM Backup Configuration
LogMiner
Recovery Manager
Configurable Parameters

Standby Databases & Data Guard

Data Guard Features
Creating the Standby Database
Maintaining the Standby Database
Altering the Physical Structure
Failover without Data Guard
Failover Using Data Guard
Role Transitions Using Data Guard
Data Guard Protection Modes
Logical Standby Databases
Creating a Logical Standby Database
Logical Standby Failover and Switchover
Data Guard Manager Line Mode
Data Guard Manager Using EM

Flashback

Flashback Features
Enabling Flashback
Flashback Query
Additional Query Functions
Flashback Version Query
Flashback Transaction Query
Flashback Table
Flashback Drop (Recycle Bin)
Flashback Database