Oracle 9i Back up and Recovery (O940) Training Course

Training Course Objectives

This course is designed to give the Oracle 9i database administrator a firm foundation in backup and recovery tasks. The primary goal of the course is to give the DBA the skills and knowledge to set-up, maintain and troubleshoot an Oracle 9i backup and recovery scheme.

The enhancements and changes that have been introduced in 9i will be discussed during this course for the benefit of students to understand the full capability of the Oracle 9i RDBMS as well as for students who may be migrating plans from previous Oracle RDBMS versions.

Who Should Attend

• Oracle Database Administrators
• Oracle System Administrators
• Oracle Support Engineers

Training Course Prerequisites

• Oracle 9i SQL (O010)
• Oracle 9i PL/SQL (O020)
• Oracle 9i DBA Part 1 (O910)
• Oracle 9i DBA Part 2 (O920)
• View Learning Path

Training Course Duration

3 Days

Training Course Contents

Overview

• Understanding the structures and processes for backup and recovery.
• Introduce the different methods for backup and recovery
• Diagnose and troubleshoot database problems.
• Understand Oracle Recovery Manager

Considerations

• Define requirements for backup and recovery strategy
• Obtain management agreement for backup and recovery plan
• Consider plan for disaster recovery
• Identify the database configurations that support recovery

Backup and Recovery

• Recovery structures and processes
• Backup and recovery configuration
• Types of failure and troubleshooting
• Complete recovery
• Incomplete media recovery
• Export and import utilities
• Test Recovery
• ALTER DATABASE END BACKUP

Oracle Recovery Manager

• RMAN command line prompt
• Recovery Manager architecture
• Setting up Recovery Manager
• Database space requirements and privileges
• Creating and running backup and recovery scripts from RMAN
• Using LIST and REPORT options from Recovery Manager
• Crash Recovery workshop,
• Tips and tricks using Recovery Manager
• Persistent Parameters
• Block Level recovery

Enterprise Manager Utilities

• Catalog Maintenance using Enterprise Manager
• Creating an OEM Backup Configuration
• LogMiner
• Recovery Manager
• Configurable Parameters

Standby Database & Data Guard

• Data Guard Features
• Creating the Standby Database
• Maintaining the Standby Database
• Altering the Physical Structure
• Failover without Data Guard
• Failover Using Data Guard
• Role Transitions using Data Guard
• Data Guard Protection Modes
• Logical Standby Databases
• Creating a Logical Standby Database
• Logical Standby Failover and Switchover
• Data Guard Manager Line Mode
• Data Guard Manager Using OEM

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.