Course Length:

3 Days

Course Description:

In this course participants 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.

Who Should Attend:

Data Warehouse Administrators and Database Administrators will benefit from this course.

Benefits of Attendance:

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

• 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

Prerequisites:

Students should have taken Oracle9i Database Administration Fundamentals I, Oracle9i Database Administration Fundamentals II, and Oracle Database 10g: Administration Workshop I Release 2.

Course Outline:

• 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