Oracle Database 10g Backup & Recovery

 

Day 1

• Lesson 1 : Introduction
• Lesson 2 : Configuring for Recoverability
• Lesson 3 : Using RMAN to Create Backups
• Lesson 4 : Using RMAN to Perform Recovery
• Lesson 5 : Using Oracle Flashback Technologies
• Lesson 6 : Using RMAN to Create a Duplicate Database

Day 2

• Lesson 7 : Performing Tablespace Point-in-Time Recovery
• Lesson 8 : Using the RMAN Recovery Catalog
• Lesson 9 : Monitoring and Tuning RMAN
• Lesson 10 : Oracle Secure Backup Overview
• Lesson 11 : Installing Oracle Secure Backup

Day 3

• Lesson 12 : Using RMAN and Oracle Secure Backup
• Lesson 13 : Backing Up File-System Files with Oracle Secure Backup
• Lesson 14 : Restoring File-System Backups with Oracle Secure Backup
• Lesson 15 : Managing Oracle Secure Backup Security
• Lesson 16 : Managing the Administrative Domain

Lesson 1 : Introduction

• Describe course objectives
• Describe backup methods
• Describe the forms of data recovery
• Describe Oracle Recovery Manager architecture
• Plan a recovery strategy
• Plan a backup strategy based on your recovery strategy

Lesson 2 : Configuring for Recoverability

• Configure your database in ARCHIVELOG mode
• Specify a retention policy
• Configure the Flash Recovery Area

Lesson 3 : Using RMAN to Create Backups

• Configure persistent settings
• Configure backup destinations
• Configure backup optimization
• Create duplexed backup sets

 

Lesson 4 : Using RMAN to Perform Recovery

• Perform complete recovery
• Perform recovery on a new host
• Perform recovery using a backup control file

Lesson 5 : Using Oracle Flashback Technologies

• Use Flashback Drop to recover a dropped table
• Use Flashback Query to view the contents of the database as of any single point in time
• Use Flashback Versions Query to view versions of a row over time
• Use Flashback Transaction Query to view transaction history of a row
• Use Flashback Table to restore the contents of a table to a specific point in the past
• Configure Flashback Database
• Perform Flashback Database to a point in time

Lesson 6 : Using RMAN to Create a Duplicate Database

• Describe the ways a duplicate database can be used
• Configure auxiliary database file names
• Create a duplicate database

Lesson 7 : Performing Tablespace Point-in-Time Recovery

• Determine when to use tablespace point-in-time recovery (TSPITR)
• Choose the correct TSPITR target time
• Perform basic RMAN tablespace point-in-time recovery

Lesson 8 : Using the RMAN Recovery Catalog

• Create the recovery catalog
• Manage the recovery catalog
• Resynchronize the recovery catalog
• Use stored scripts

Lesson 9 : Monitoring and Tuning RMAN

• Monitor RMAN jobs
• Troubleshoot RMAN operations
• Tune RMAN backup performance

Lesson 10 : Oracle Secure Backup Overview

• Describe how Oracle Secure Backup complements the Oracle backup and recovery options
• Define Oracle Secure Backup terminology
• Describe Oracle Secure Backup interface options
• Describe backup management features of Oracle Secure Backup

Lesson 11 : Installing Oracle Secure Backup

• Install Oracle Secure Backup on Linux
• Choose an Oracle Secure Backup interface
• Register the Administrative Server in EM
• Add an Oracle Secure Backup user with preauthorized access

Lesson 12 : Using RMAN and Oracle Secure Backup

• Create database backup storage selectors
• Describe integrated disk and tape backup
• Perform Oracle-suggested backup to tape
• Determine database recovery

Lesson 13 : Backing Up File-System Files with Oracle Secure Backup

• Create dataset scripts
• Schedule file backups
• Submit backup requests
• Perform file-system backups

Lesson 14 : Restoring File-System Backups with Oracle Secure Backup

• Browse the catalog for file-system backup data
• Create catalog-based restore requests
• Perform file-system restoration

Lesson 15 : Managing Oracle Secure Backup Security

• Manage user access control for Oracle Secure Backup
• Describe host authentication
• Determine backup security characteristics
• Describe encryption
• Perform an encrypted database backup and restore

Lesson 16 : Managing the Administrative Domain

• Describe Oracle Secure Backup processes
• Configure policies and defaults
• Browse primary Oracle Secure Backup catalogs
• Manage clients Manage media servers (tape devices and libraries)
• Manage volumes Manage jobs