Oracle 10g Database Backup & Recovery

Audience:

• Data Warehouse Administrator
• Database Administrators

Required Prerequisites:

• Oracle9i Database Administration Fundamentals I
• Oracle9i Database Administration Fundamentals II
• Oracle Database 10g: Administration Workshop I Release 2

Course Objectives:

• Plan effective backup and recovery procedures
• Use Recovery Manager to create backups and perform recovery operations
• Use Oracle Flashback technologies to recover from human error
• Install Oracle Secure Backup
• Perform an Oracle-suggested backup to tape
• Use Oracle Secure Backup to perform a file system backup
• Use Oracle Secure Backup to perform a file system restoration
• Perform an encrypted database backup and restore
• Manage the Oracle Secure Backup environment
• Monitor and tune Recovery Manager
• Perform tablespace point-in-time recovery
• Create a duplicate database
• Create and manage a recovery catalog database

Course Topics:

Introduction

• Overview of backup methods
• Overview of recovery methods
• Backup and recovery strategies

Configuring for Recoverability

• Configuring ARCHIVELOG mode
• Specifying a Retention Policy
• Configuring the Flash Recovery Area

Using RMAN to Create Backups

• Configuring RMAN Persistent Settings
• Configuring Backup Optimization
• Enabling Fast Incremental Backup
• Creating an Oracle-suggested Backup
• Creating Duplex Backup Sets
• Configuring Control File Auto-backups
• Managing Backups

Using RMAN to Perform Recovery

• Performing Complete Recovery
• Performing Recovery Using Incrementally Updated Backups
• Using the Flash Recovery Area for Fast Recovery
• Restoring and Recovering the Database on a New Host
• Restoring the Server Parameter File
• Restoring the Control File from Auto-backup

Using Oracle Flashback Technologies

• Performing Flashback Table
• Flashing Back Dropped Tables
• Performing Flashback Versions Query
• Performing Flashback Transaction Query
• Configuring Flashback Database
• Performing Flashback Database

Using RMAN to Create a Duplicate Database

• Creating an Initialization Parameter File for the Auxiliary Instance
• Creating a Duplicate Database
• Using Enterprise Manager to Create a Duplicate Database

Performing Tablespace Point-in-Time Recovery

• Tablespace Point-in-time Recovery Architecture
• Determining the Recovery Set Tablespaces
• Performing Basic RMAN Tablespace Point-in-time Recovery
• Troubleshooting Tablespace Point-in-time Recovery

Using the RMAN Recovery Catalog

• Configuring the Recovery Catalog Database
• Creating the Recovery Catalog Owner
• Creating the Recovery Catalog
• Registering a Database in the Recovery Catalog
• Cataloging Additional Backup Files
• Manually Re-synchronizing the Recovery Catalog
• Creating and Executing Stored Scripts

Monitoring and Tuning RMAN

• Monitoring RMAN Sessions
• Monitoring RMAN Job Progress
• Interpreting RMAN Message Output
• Tuning RMAN Backup Performance

Oracle Secure Backup Overview

• Oracle Secure Backup: Tape Management and Integration with Oracle Products
• Oracle Secure Backup Interface Options
• Media Management Expiration Policies
• Securing Data and Access to the Backup Domain

Install Oracle Secure Backup

• Perform Pre-installation Tasks
• Perform Installation Tasks
• Configure the Administrative Server
• Configure Oracle Secure Backup Users

Use RMAN and Oracle Secure Backup

• RMAN Database Backup to Tape
• Define Database Storage Selectors
• Back Up the Flash Recovery Area to Tape
• Perform Oracle-suggested Backup to Tape
• Manage Database Tape Backups

Back Up File System Files With Oracle Secure Backup

• Manage Media Families
• Create Datasets
• Create Backup Windows
• Create Backup Schedules
• Create Backup Triggers
• Create On-Demand Backup Requests

Restore File System Backups with Oracle Secure Backup

• Browse the Catalog for File System Backup Data
• Restore File System Data
• Create a Catalog-Based Restore Request
• Submit a Restore Request

Manage Oracle Secure Backup Security

• Manage User Access Control
• Define an Oracle Secure Backup User
• Leverage Oracle Security Technology
• Administrative Server Certificate Authority (CA)
• Create Encrypted Backups
• Restore Encrypted Backups
• Perform Encrypted Recovery

Manage the Administrative Domain

• Managing Common Daemon Operations
• Managing Policies and Defaults
• Configuring Oracle Secure Backup Policies
• Adding Clients, Media Servers, and Devices
• Managing Devices and Volumes
• Managing Jobs

<<Back