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

Live Online & Classroom Enterprise Certification Training

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.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Backup and Recovery Workshop Ed 3 Certification Training about?

The student benefits by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail.Students gain knowledge of the Recovery Manager (RMAN) command line interface for various 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.)

Extensive hands-on practices and workshop scenarios provide the student with experience in a realistic technical environment. This course includes an interactive workshop that provide participants with opportunities to diagnose and recover from several failure scenarios, based on backup and recovery case studies.After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.

What are the objectives of Backup and Recovery Workshop Ed 3 Certification Training ?

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
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

Who is Backup and Recovery Workshop Ed 3 Certification Training for?

Database Administrators
Support Engineer
Technical Consultant
Technical Administrator
Data Warehouse Administrator

What are the prerequisites for Backup and Recovery Workshop Ed 3 Certification Training?

Suggested Prerequisite

Knowledge of Oracle Database 12c
Knowledge of SQL and PL/SQL (for DBA use)

Required Prerequisite

Oracle Database 12c R2: Install and Upgrade Workshop
Oracle Database 12c R2: Administration Workshop Ed 3
Using Oracle Enterprise Manager Cloud Control 13c Ed 1

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Introduction

Oracle Maximum Availability Architecture

Oracle Secure Backup

Basic Workshop Architecture

Oracle backup and recovery solutions

Curriculum Context

Categories of failures

Benefits of using Oracle Data Guard

Assess your recovery requirements

Getting Started

Oracle DBA Tools for Backup and Recovery

Connecting to Oracle Recovery Manager (RMAN)

Quick Start: A Problem-Solution Approach

Core Concepts of the Oracle Database, critical for Backup and Recovery

Configuring for Recoverablility

Control File

RMAN commands

Using the Fast Recovery Area (FRA)

Archiving Logs

Configuring and managing persistent settings

Redo Log File

Using the RMAN Recovery Catalog

Creating and Configuring the Recovery Catalog

Using RMAN Stored Scripts

Managing Target Database Records in the Recovery Catalog

Maintaining and Protecting the Recovery Catalog

Virtual Private Catalogs

Backup Strategies and Terminology

Additional Backup Terminology

Backing Up Read-Only Tablespaces

Backup Solutions Overview and Terminology

Data Warehouse Backup and Recovery: Best Practices

Balancing Backup and Restore Requirements

Performing Backups

RMAN Backup Types

Oracle-Suggested Backup

Reporting on Backups

Block Change Tracking

Fast Incremental Backup

Incrementally Updated Backups

Managing Backups

Improving Your Backups

Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets

Creating and Managing Archival Backups

Cataloging Additional Backup Files

Compressing Backups

Backup and Restore for Very Large Files

Backing Up Recovery Files

Backing Up the Control File to a Trace File

Using a Media Manager

Using RMAN-Encrypted Backups

Using Dual-Mode Encryption

Using Password-Mode Encryption

Using Transparent-Mode Encryption

Creating RMAN-Encrypted Backups

Diagnosing Failures

Automatic Diagnostic Repository

Handling Block Corruption

Reducing Problem Diagnosis Time

Data Recovery Advisor

Restore and Recovery Concepts

Complete Recovery (Overview)

Instance Failure and Instance/Crash Recovery

Restoring and Recovering

Point-in-Time Recovery (Overview)

Recovery with the RESETLOGS Option

Media Failure

Performing Recovery, Part I

RMAN Recovery in NOARCHIVELOG Mode

Performing Point-in-Time (PITR) or Incomplete Recovery

Recovery with Image Files

Performing Complete Recovery (of critical and noncritical data files)

Restoring ASM Disk Groups

Performing Recovery, Part II

Redo Log File Loss and Recovery

Restoring RMAN Encrypted Backups

Recovery of Server Parameter File, Control File (One and All)

Restoring the Database to a New Host

Disaster Recovery

Index, Read-Only Tablespace, and Tempfile Recovery

Password Authentication File Re-creation

RMAN and Oracle Secure Backup

Configuring Oracle Secure Backup for RMAN

RMAN Backup and Restore Operations

RMAN and OSB: Overview and Basic Process Flow

Displaying OSB log files and transcripts for RMAN activities

Starting with Oracle Secure Backup

Oracle Secure Backup Jobs

Oracle Secure Backup Overview and Interface Options

Using Flashback Technologies

Using Flashback Technology to Query Data

Flashback Drop and the Recycle Bin

Flashback Transaction (Query and Backout)

Flashback Technology: Overview and Setup

Flashback Table

Flashback Data Archive

Using Flashback Database

Configuring Flashback Database

Flashback Database Architecture

Best Practices for Flashback Database

Performing Flashback Database

Transporting Data

Transporting Data Across Platforms

Database Transport: Using Data Files

Transporting Data with Backup Sets

Performing Point-in-Time Recovery

Performing RMAN TS Point-in-time Recovery

When to use TSPITR

Recovering Tables from Backups

TSPITR Architecture

Duplicating a Database

Duplicating Database with push anpull techniques

Understanding the RMAN Duplication Operation

Choosing Database Duplication Techniques

Creating a Backup-up Based Duplicate Database

Using a Duplicate Database

RMAN Troubleshooting and Tuning

Interpreting RMAN Message Output

Tuning Principles

RMAN Multiplexing

Diagnosing Performance Bottlenecks

Restore and Recovery Performance Best Practices

Cloud Tooling for Backup and Recovery

Customize Backup Configuration

Backup Destinations

Installing the Backup Module

Oracle Backup Cloud Service

On-Demand Backup and Recovery

Backup and Recovery Workshop

Workshop Structure and Approach

Diagnosing the Failures

Business Requirements for Database Availability and Procedures

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Backup and Recovery Workshop Ed 3 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree