After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. They learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error. This Course includes Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and also provides general file system backup to tape capabilities. Students install Oracle Secure Backup and use it to back up Oracle Database files and file system files.

Target Audience
Data Warehouse Administrator Database Administrators

Key Topics

• Introduction
• Configuring for Recoverability
• Using RMAN to Create Backups
• Using RMAN to Perform Recovery
• Using Oracle Flashback Technologies
• Using RMAN to Create a Duplicate Database
• Performing Tablespace Point-in-Time Recovery
• Using the RMAN Recovery Catalog
• Monitoring and Tuning RMAN
• Oracle Secure Backup Overview
• Install Oracle Secure Backup
• Use RMAN and Oracle Secure Backup
• Back Up File System Files With Oracle Secure Backup
• Restore File System Backups with Oracle Secure Backup
• Manage Oracle Secure Backup Security
• Manage the Administrative Domain

Objectives

• Plan effective backup and recovery procedures
• Use Recovery Manager to create backups and perform recovery operations
• Use Oracle Flashback technologies to recover from human error
• Install Oracle Secure Backup
• Perform an Oracle-suggested backup to tape
• Use Oracle Secure Backup to perform a file system backup
• Use Oracle Secure Backup to perform a file system restoration
• Perform an encrypted database backup and restore
• Manage the Oracle Secure Backup environment
• Monitor and tune Recovery Manager
• Perform tablespace point-in-time recovery
• Create a duplicate database
• Create and manage a recovery catalog database

Required Skills/Experience

• Oracle9i Database Administration Fundamentals I
• Oracle9i Database Administration Fundamentals II
• Oracle Database 10g: Administration Workshop I Release 2

Fee: $1,800.00

Course Schedule:
Back to Course Description

Austin

• Nov 10 - Nov 12

Charlotte

• Oct 27 - Oct 29

Columbia

• Sep 03 - Sep 05
• Oct 27 - Oct 29

Hunt Valley

Please contact your sales representative for availability.

Lansing

• Sep 22 - Sep 24

Madison

Please contact your sales representative for availability.

Milwaukee

Please contact your sales representative for availability.

Minneapolis

Please contact your sales representative for availability.

Oak Brook

Please contact your sales representative for availability.

Oklahoma City

• Nov 24 - Nov 26

Phoenix

• Sep 03 - Sep 05
• Nov 24 - Nov 26

Raleigh

Please contact your sales representative for availability.

San Antonio

Please contact your sales representative for availability.

Schaumburg

• Sep 03 - Sep 05
• Nov 24 - Nov 26

Tulsa

• Sep 29 - Oct 01

Washington DC

Please contact your sales representative for availability.