Course Overview

This Oracle Database 11g: RMAN Backup & Recovery course is designed to provide students with the skills needed to design, test, and implement a robust backup and recovery strategy. When a major failure occurs, a variety of recovery and troubleshooting techniques must be employed. The focus of this course is the Oracle Recovery Manager (RMAN) tool. Additional facilities covered include the Data Recovery Advisor, Redo Log File Size Advisor, and MTTR Advisor. It is tempting to shortcut appropriate backup procedures if they perform poorly, so special attention is given to performance optimization.

This course, along with its prerequisites, covers information necessary to complete the certification test EXAM #1Z1-053 ORACLE DATABASE 11g: ADMINISTRATION II.

What you’ll learn

Upon completion of the Oracle Database 11g: RMAN Backup & Recovery course, students will be able to:

• Explain user-managed and automatically managed backup strategies and database recovery operations using RMAN and other database facilities.
• Utilize database instance recovery, tuning checkpoints, the Redo Log File Size Advisor, and the MTTR Advisor.
• Describe user-managed recovery scenarios, including recovery from temporary, read-only, and index tablespaces.
• Understand automatically managed backup strategies and database recovery operations using RMAN and other database facilities. Complete and incomplete media recovery, including database point-in-time recovery and tablespace point-in-time recovery.
• Build upon basic RMAN capabilities with a centralized recovery catalog. Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution.
• Optimize backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for optimum efficiency.
• Use data preservation through archival backups.
• Duplicate databases for regulatory compliance, real application testing database replay, test configuration, and other purposes.
• Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor.