Oracle Database 12c: Backup and Recovery Workshop

Overview

In this Oracle Database 12c R2: Backup and Recovery Workshop, student figure out how to perform backup and recovery based on the related Oracle Database architecture parts. Different backup, failure, restore, and recovery scenarios are given with the goal that student figure out how to assess their own recovery requirements and develop an appropriate strategy for backup and recovery methodology. This course incorporates an intuitive workshop, with situations that furnish members with opportunities to diagnose and recover from several failure circumstances.

Audience

• Support Engineer
• Technical Administrator
• Technical Consultant
• Data Warehouse Administrator
• Database Administrators

Course Objectives

• Describe the Oracle Database architecture components related to backup and recovery operations
• Plan effective backup and recovery procedures
• Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure
• Configure the database for recoverability
• Use Recovery Manager (RMAN) to create backups and perform recovery operations
• Use the Data Recovery Advisor to diagnose and repair failures
• Use Oracle Flashback Technologies to recover from human error
• Perform an encrypted database backup and restore
• Perform tablespace point-in-time recovery
• Describe Cloud Tooling for Backup and Recovery

This course prepares you for Exam 1Z0-063. Download Course Contents

Course Prerequisites

• Knowledge of Oracle Database 12c
• Knowledge of SQL and PL/SQL (for DBA use)
• Oracle Database 12c R2: Administration Workshop Ed 3
• Using Oracle Enterprise Manager Cloud Control 13c Ed 1
• Using Oracle Enterprise Manager Cloud Control 13c Ed 2

The student benefits by picking up a more profound comprehension of potentially the most critical activity of a DBA – backup and recovery. The ideas and architecture that support backup and recovery, alongside the means of how to complete it in different ways and circumstances, are shrouded in detail. Understudies pick up information of the Recovery Manager (RMAN) charge line interface for different backup, failure, restore, and recovery scenarios, including tape backup and data duplication.  (Familiarity with basic database tools and utilities, such as, SQL*Plus, is assumed.)

Upon Completion of this Course, you will accomplish following:-

• Develop appropriate backup and recovery procedures to address your business needs.
• Implement backup and recovery settings and perform backup operations to disk and tape.
• Employ Oracle Database recovery procedures to recover from media and other failures.
• Diagnose and repair data failures.
• Use Flashback Technologies and data duplication to complement backup and recovery procedures.
• Secure the availability of your database by appropriate backup and recovery strategies.