Oracle Database 10g: Backup and Recovery

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.

Learn To:

• Develop an effective backup and recovery strategy
• Perform backup and recovery operations using RMAN
• Install and configure Oracle Secure Backup for tape backup
• Use Oracle Secure Backup to back up database and file system files

Audience:

• Data Warehouse Beheerder
• Database Beheerder

Course 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 Prerequisites:

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