VERITAS NetBackup 5.x for Oracle for Solaris (VT-269)

Objective

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

Overview

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

Who can benefit

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.

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.

Content

Oracle Concepts

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

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

Oracle Recovery Manager (RMAN) Concepts

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

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

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

Establishing Oracle Backup Policies

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

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