4.Backup and Recovery

Backup and Recovery Concepts

• Part of Your Job
• Statement Failure
• User Error
• Understanding Instance Recovery
• Phases of Instance Recovery
• Using the MTTR Advisor
• Media Failure
• Archive Log Files

Performing Database Backups

• Backup Solutions: Overview
• Oracle Secure Backup
• User-Managed Backup
• Terminology
• Recovery Manager (RMAN)
• Configuring Backup Settings
• Backing Up the Control File to a Trace File
• Monitoring the Flash Recovery Area

Performing Database Recovery

• Opening a Database
• Data Recovery Advisor
• Loss of a Control File
• Loss of a Redo Log File
• Data Recovery Advisor
• Data Failures
• Listing Data Failures
• Data Recovery Advisor Views

Performing User-Managed Backup and Recovery

• Restoring and Recovering
• Causes of File Loss
• Critical Versus Non-critical
• Recovering from a TEMPFILE Loss
• Re-creating Indexes
• Recovering from a Lost Index Tablespace
• Authentication Methods for Database Administrators
• Recovering a Read-Only Tablespace

Configuring for Recoverability

• Purpose of Backup and Recovery Functionality
• Typical Backup and Recovery Tasks
• Oracle Backup and Recovery Solutions
• Using Recovery Manager (RMAN)
• Using a Flash Recovery Area
• Flash Recovery Area Space Management

Using the RMAN Recovery Catalog

• RMAN Repository Data Storage: Comparison of Options
• Storing Information in the Recovery Catalog
• Registering a Database in the Recovery Catalog
• Recovery Catalog Resynchronization: Concepts
• Using RMAN Stored Scripts
• Backing Up and Recovering the Recovery Catalog
• Using a Virtual Private Catalog

Configuring Backup Specifications

• Using RMAN to Create Backups
• Configuring Persistent Settings for RMAN
• Using Enterprise Manager to Configure RMAN Settings
• Control File Auto-backups
• Managing Persistent Settings
• Configuring Devices for Backup
• Configuring and Allocating Channels for Use in Backups
• Configuring Backup Optimization

Creating Backups

• Creating an Oracle-Suggested Backup
• Creating Backup Sets & Image Copies
• Creating a Whole Database Backup
• RMAN Backup Types
• Monitoring Block Change Tracking
• Creating Duplex Backup Sets
• Archival Backups: Concepts
• Encrypting Backups

Performing User-Managed Backup and Recovery

• Restoring and Recovering
• Causes of File Loss
• Critical Versus Non-critical
• Recovering from a TEMPFILE Loss
• Re-creating Indexes
• Recovering from a Lost Index Tablespace
• Authentication Methods for Database Administrators
• Recovering a Read-Only Tablespace

Using RMAN to Perform Recovery

• Using RMAN RESTORE and RECOVER Commands
• Performing Recovery Using Enterprise Manager
• Recovery Using Incrementally Updated Backups
• Perform a Fast Switch to Image Copies
• Restoring and Recovering the Database on a New Host
• Performing Disaster Recovery

Using RMAN to Duplicate a Database

• Using RMAN to Create a Duplicate Database
• Creating a Duplicate Database
• Creating an Initialization Parameter File for the Auxiliary Instance
• Allocating Auxiliary Channels
• Understanding the RMAN Duplication Operation
• Using EM to Clone a Database
• Cloning a Running Database

Performing Tablespace Point-in-time Recovery

• Tablespace Point-in-Time Recovery (TSPITR) Concepts
• Tablespace Point-in-Time Recovery: Architecture
• Understanding When to Use TSPITR
• Determining the Tablespaces for the Recovery Set
• Using Enterprise Manager to Perform TSPITR
• Understanding TSPITR Processing
• Troubleshooting RMAN TSPITR

Monitoring and Tuning RMAN

• Parallelization of Backup Sets
• Monitoring RMAN Sessions
• Interpreting RMAN Message Output
• Using the DEBUG Option
• Tuning RMAN
• RMAN Multiplexing
• Comparing Synchronous and Asynchronous I/O
• Tape Subsystem Performance Rules

Using Flashback Technology

• Flashback Technology
• Transactions and Undo
• Guaranteeing Undo Retention
• Preparing Your Database for Flashback
• Flashback Drop and the Recycle Bin
• Using Flashback Technology to Query Data
• Possible Workflow
• Flashback Transaction Wizard

Using Flashback Database

• Flashback Table
• Enabling Row Movement on a Table
• Enabling Row Movement on a Table
• Flashback Database Architecture
• Configuring Flashback Database
• Performing Flashback Database Using EM
• Flashback Database Considerations
• Flashback Data Archive