10g: Advanced Back-up and Recovery

What you will learn: After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. They learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error.This Course includes Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and also provides general file system backup to tape capabilities. Students install Oracle Secure Backup and use it to back up Oracle Database files and file system files.

Learn To:
Develop an effective backup and recovery strategy Perform backup and recovery operations using RMANInstall and configure Oracle Secure Backup for tape backup Use Oracle Secure Backup to back up database and file system files

Audience: Data Warehouse Administrator
Database Administrators

Prerequisites:

Next Course:

Relevant Certification:

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