Oracle8i:Backup and Recovery

Introduction to Oracle Backup and Recovery
Backup and Recovery Administration Responsibilities
Defining a Backup Strategy
Planning for Disaster Recovery

Oracle RDBMS Backup and Recovery Fundamentals
Oracle Data Dictionary Management Views
Oracle Internals Fundamental Concepts
Oracle Processes
Oracle External Structures
ARCHIVELOG and NOARCHIVELOG Mode

Physical Backups
Oracle File Locations
Physical Backup Options in Oracle
Performing Cold Backups in Oracle
Performing Hot Backups in Oracle
Additional Oracle Backup Considerations

Complete Recovery
Recovery 101
Closed Database Recoveries
Open Database Recovery

Incomplete Recovery
Incomplete Recovery of an Oracle Database
Other Database Recovery Considerations

Logical Backups
Logical Backups and Oracle's Export Utility (Exp)
Oracle's Import Utility (Imp)
Incremental Exports and Imports

Troubleshooting Utilities
Oracle Problem Detection
LogMiner

Recovery Manager
Starting with RMAN
Setting Up RMAN

RMAN
RMAN Backups
Other RMAN Backup Topics

RMAN
Recovering the Oracle Database
Other Types of Recoveries with RMAN
Other RMAN Recovery Topics

RMAN
Managing RMAN
RMAN Stored Scripts

Standby Database
Standby Database Basics and Setup
Using the Standby Database

After completing this course, students will know how to:

Prepare backup, recovery, and disaster plans.
Describe the internal workings of the Oracle database as they pertain to backup and recovery.
Describe the backup procedures for both hot and cold backups and then perform those backups (without RMAN).
Perform complete and incomplete database recoveries and full, tablespace, and datafile recoveries with the database open and closed (without RMAN).
List and describe the benefits and use of the Oracle Export/Import utility, and use Oracle Export/Import utilities to perform an export from an Oracle database and an import into an Oracle database.
Use the Oracle troubleshooting utilities including DBV and the DBMS_REPAIR package.
Describe the basic RMAN architecture. Perform required setup procedures in preparation for using RMAN.
Perform full, incremental, tablespace and datafile backups using RMAN.
Perform full, tablespace and datafile recoveries using RMAN.
Create stored scripts and generate reports and lists in RMAN.
Setup an Oracle standby database, enable archived redo log processing on the standby database, and enable the standby database in read only mode or activate it for full use.

Prerequisites

Students should have knowledge of Oracle8i: Architecture and Administration
(2nd Ed) or equivalent