NetBackup 5.x Oracle

Course Overview

The 5.x for Oracle for Solaris course provides students with comprehensive instruction of NetBackup 5.x for Oracle9i Recovery Manager (RMAN). Students will learn to configure and use these tools to perform various backup and recovery operations.

Audience

This course is designed for database administrators (DBAs) who will be responsible for the maintenance of Oracle databases within their enterprise environment and system administrators who will be responsible for the backup and recovery of systems within their enterprise environment.

Skills Gained

Upon completion of this course, students should be able to:

• Identify components of the Oracle architecture
• Establish and manage a recovery catalog and link it to the target database
• Install the VERITAS NetBackup for Oracle extension and link it with RMAN
• Perform offline (cold) and online (hot) backups of complete Oracle databases in addition to specific components
• Establish backup policies specifically for Oracle databases
• Create RMAN scripts and templates using VERITAS NetBackup for Oracle wizards

Prerequisites

• This course is designed with consideration to both DBAs and system administrators.
• A basic familiarity with operating VERITAS NetBackup is expected.
• Knowledge of Oracle9i is desirable, but not required.

Course Outline

Module 1 - Oracle Concepts

• Oracle's Architecture
• The Oracle Instance
• Environment Variables and Functions
• Starting, Stopping, and Querying an Oracle Database

Module 2 - Database Backup and Restore Fundamentals

• Types of Database Failure
• Requirements for Recovering a Failed Database
• Database Recovery Methods
• Types of Database Backups
• ARCHIVELOG Mode
• Integration of VERITAS NetBackup for Oracle with Oracle
• Recovery Manager (RMAN)
• Managing NetBackup Notify Scripts

Module 3 - Oracle Recovery Manager (RMAN) Concepts

• RMAN Architecture
• RMAN Command Structure and Execution Modes
• RMAN Repository
• RMAN Recovery Catalog
• Registering an Oracle Database with RMAN

Module 4 - Performing and Monitoring Backups with RMAN

• How RMAN Backs Up Data
• RMAN Backup Methods
• RMAN Backup Scripts
• Parallel Backup Streams
• Monitoring and Troubleshooting RMAN Backups

Module 5 - NetBackup for Oracle Installation and Configuration

• Installing NBUO
• Integrating NBUO with Oracle9i
• Configuring NBUO to Support RMAN Operations
• Managing the Run-Time Environment
• Verifying NBUO Configuration
• Performing RMAN Backups Using NBUO

Module 6 - Establishing Oracle Backup Policies

• Using NetBackup Wizards
• Establishing Parallel Backup Streams
• Managing Backup Sets
• Configuring NBUO and RMAN to Support Backup Sets

Module 8 - Performing Simple Restore and Recovery Operations with RMAN and NBUO

• Restoring and Recovering a Database
• Restoring Data Files and Tablespaces
• Restoring the Control File
• Restoring Archived Redo Logs
• Incomplete/Partial Recovery Operations
• Database Recovery Challenges
• Restoration Procedures in Preparation of an Incomplete Recovery
• Recovering from the Loss of Critical Oracle Components