Oracle Database DBA Backup and Recovery with RMAN — A 3-Day Course

Synopsis

Delegates will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will perform backup and recovery operations using RMAN and Enterprise Manager. They will use Flashback features to recover from human error. Delegates will also learn how to use Oracle Secure Backup to backup and restore from tape.

Objectives

On completion of this course, delegates will be able to:

Plan and implement a backup and recovery strategy using Recovery Manager and Oracle Secure Backup
Perform backup and recovery operations using RMAN and Enterprise Manager
Use Flashback features to recover from human error
Alter a database to ARCHIVELOG and NOARCHIVELOG modes
Create and manage a recovery catalog database
Monitor and Tune Recovery Manager
Performing tablespace point-in-time recovery
Creating a duplicate database
Using Flashback technology to recover from errors
Installing Oracle Secure Backup
Performing Oracle Secure Backup to tape of database files
Performing encrypted database backup and restores
Managing the Oracle Secure Backup environment

Suitable For

This course is designed for:

Database administrators, data warehouse administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle 10g and Oracle 11g databases.

Prerequisites

A working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses:

Oracle SQL
Oracle Database 10g DBA - Part 1
Oracle Database 11g DBA - Part I

Publicly scheduled dates, locations, and prices

A schedule of dates for this course is not currently available. Please call 0800 651 0338 or use our contact form to enquire about places and availability.

Outline Course Contents

Backup and Recovery Considerations

Plan and Implement a Backup and Recovery Strategy
Define a Disaster Recovery Plan
Test a Backup and Recovery Plan
Advantages and Disadvantages of Different Backup Methods
Data Recovery Strategy
Backup Strategy
Validate the Recovery Strategy

Oracle Recovery Structures and Processes

Architectural Components of Backup and Restore
Redo logs, Checkpoints and Archives
Multiplexing Control files and Redo Logs
Flash Recovery Area

Using ARCHIVELOG and NOARCHIVELOG ModesM

The Archive Modes of a Database
Configure a Database in Archivelog Mode
Configure a Database in Noarchivelog Mode
Configure Multiple Redo Log Archive Processes
Configure Multiple Archival Destinations

Flashback

Configure and Use Flashback Database
Monitor Flashback Database
Flash Recovery Area Space Usage
Flashback Query
Retrieve Row History with Flashback Versions Query
Audit or Recover From Transactions with Flashback Transactions Query
Flashback Table
Recover Dropped Tables with Flashback Drop
The Recycle Bin
Recover Tables to a Point In Time With Flashback Table
Flashback Database
Flashback Restore Points
Flashback Transaction Backout
Flashback Data Archive

Recovery Manager Overview

RMAN Features and Components
Connect to RMAN
Start Up and Shut Down a Target Database Using RMAN

Create and Configure a Recovery Catalog

Create a Recovery Catalog
Register a Database
Unregister a Database
Control File Information
RESYNC CATALOG Command
Virtual Private Catalogs
Merge Catalogs
Backup a Recovery Catalog
Use a Flashback Recovery Area
Configure Persistent RMAN Settings
Set Retention Policies
Configure Control File Autobackups

Back Up with RMAN

Channel Allocation
Types of RMAN Backup
Backup Commands
Backup Sets Parallelization
Compressed Backups
Performing Backups
Full Closed and Open Backups
Incremental and Cumulative Backups
The Copy Command
Block Change Tracking
Backup Validate
Troubleshooting

Maintain a Recovery Catalog

Reset Command
Change the Availability Status of Backups and Copies
Catalog Backups Made with Operating System Commands
Generate Reports and Lists
Cross Check Backups and Copies
Delete Backups
Update the Repository after Backup Deletion
Drop Database
Use Data Dictionary Tables

Restore and Recover with RMAN

Perform Recovery in Noarchivelog Mode
Perform Complete Recovery in Archivelog Mode
Perform Incomplete Recovery
Use the Flash Recovery Area for Fast Recovery
Restore and Recover a tablespace
Restore and Recover Datafiles
Recover a Datafile Not Backed Up
Restore the Server Parameter File
Restore the Control File from Auto-Backup
Restore and Recover the Database on a New Host

Create a Duplicate Database with RMAN

Database Duplication
Duplication Options
Create Files for the Duplicate Database
Prepare the Auxiliary Instance for Duplication
Create a Duplicate Database
Create a Duplicate Database with Enterprise Manager
Clone a Running Database
Use EM to Clone a Running Database

Tablespace Point-in-Time Recovery

Overview of Tablespace Point-in-Time Recovery
Determine Recovery Set Tablespaces
Perform RMAN Tablespace Point-in-Time Recovery
Troubleshoot Tablespace Point-in-Time Recovery

Monitor, Tune and Troubleshoot Backup and Recovery

Tune recovery Manager Overview
Tune RMAN Backup Performance
Instance Recovery Performance Tuning
Understand RMAN Output Messages
Troubleshoot RMAN

Overview of Oracle Secure Backup

Oracle Secure Backup Overview
Oracle Secure Backup Product Family
Encrypted Backups
Oracle Secure Backup Interfaces
Oracle Secure Backup Web Tool
Oracle Secure Backup Command Line Tool
Oracle Enterprise Manager and Grid Control
Recovery Manager Command Line Interface
Media Management Expiration Policies
Domain Security

Install Oracle Secure Backup

Administrative Domains and Host Roles
Pre-installation Tasks
Install Oracle Secure Backup
Oracle Secure Backup Home Directory
Configure the Administrative Domain
Set Up Oracle Secure Backup Users and Classes

RMAN and Oracle Secure Backup

Overview of RMAN and Oracle Secure Backup
RMAN and the Oracle Secure Backup Administrative Domain
Configure RMAN and Oracle Secure Backup
Insert Volumes in the Library
Perform Oracle Suggested Backup to Tape
Back Up the Flash Recovery Area to Tape
Manage Database Tape Backups