Oracle Database 10g: Backup and Recovery

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 RMAN
	Install and configure Oracle Secure Backup for tape backup
	Use Oracle Secure Backup to back up database and file system files

course content details

	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

	anage 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