TRENDS is authorized to promote and deliver Oracle courses in partnership with TechEdge Solutions. EZY Corporation logo and Oracle logo are registered trademarks of EZY Corporation and Oracle respectively. All rights reserved.

Oracle Database 12c R2: Backup and Recovery Workshop Ed 3

Schedule

Start End Duration Location Details
January 03, 2022 January 07, 2022 KDE 3.1 Virtual Classroom (GMT+08:00)
April 04, 2022 April 08, 2022 KDE 3.1 Virtual Classroom (GMT+08:00)
July 04, 2022 July 08, 2022 KDE 3.1 Virtual Classroom (GMT+08:00)
October 03, 2022 October 07, 2022 KDE 3.1 Virtual Classroom (GMT+08:00)

Course Details

Oracle Database 12c R2: Backup and Recovery Workshop Ed 3 

Course Code: OD12BRW2

Duration: 5 Days

Prerequisites:

Required Prerequisites

  • Knowledge of Oracle Database 12c
  • Knowledge of SQL and PL/SQL (for DBA use)
  • Oracle Database 12c R2: Install and Upgrade Workshop NEW
  • Oracle Database 12c R2: Administration Workshop Ed 3 

Suggested Prerequisites

  • Using Oracle Enterprise Manager Cloud Control 13c Ed 1 
  • Using Oracle Enterprise Manager Cloud Control 13c Ed 2 

Course Description:

In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.

Course Objectives:

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

Intended Audience:

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

Course Outlines:

  • Introduction and Configuration
  • Getting Started
  • Configuring for Recoverablility
  • Using the RMAN Recovery Catalog
  • Backup Strategies and Terminology
  • Performing Backups
  • Improving Your Backups
  • Using RMAN-Encrypted Backups   
  • Diagnosing Failures
  • Restore and Recovery Concepts
  • Performing Recovery Part I
  • Performing Recovery Part II
  • RMAN and Oracle Secure Backup
  • Using Flashback Technologies
  • Using Flashback Database
  • Transporting Data
  • Performing Point-in-Time Recovery
  • Duplicating a Database
  • RMAN Troubleshooting and Tuning
  • Cloud Tooling for Backup and Recovery
  • Backup and Recovery Workshop