Course Overview

All of the data within a database installation is at risk unless one has designed, tested, and implemented a robust backup and recovery strategy. The objective of this training is to assist you in doing just that.

Among the tools and facilities that you will learn to use are the Oracle Recovery Manager (RMAN), the Enterprise Manager 12c Cloud Control, the Data Recovery Advisor, Oracle Flashback technologies, the Redo Log File Size Advisor, and the MTTR Advisor. Since it can be tempting to shortcut appropriate backup procedures if these perform poorly, special attention is given to backup performance and optimization.

This course is applicable to certification training as an Oracle Database 12c Administrator Certified Professional (OCP) for ‘Exam 1Z1-063 Oracle Database 12c: Advanced Administration’ and certification training as an Oracle Certified Implementation Specialist for ‘Exam 1Z0-497 Oracle Database 12c: Essentials.’

What you’ll learn

The objectives for this course are as follows:

• Automatically managed backup strategies and database recovery operations using RMAN, the Enterprise Manager Cloud Control, and other database facilities.
• Database instance recovery, tuning checkpoints, the Redo Log File Size Advisor, and the MTTR Advisor.
• User-managed recovery scenarios, including recovery from temporary, read-only, and index tablespaces.
• Complete and incomplete media recovery, including database point-in-time, tablespace, and table point-in-time recovery.
• Configure a centralized recovery catalog. Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution.
• Optimizing backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for optimum efficiency.
• Achieve data preservation through archival backups.
• Duplicate and clone databases for regulatory compliance, Real Application Testing database replay, test configuration, and other purposes.
• Tablespace transportation, database transportation, cross-platform transportation, and endian format conversion.
• Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor.
• Newly released or enhanced features such as backup file compression, encryption, parallelization, and others.
• Recovering from logical failure using appropriate Oracle Flashback technologies, such as Flashback Table, Flashback Drop, and Flashback Database.