Oracle Database 11g: Backup and Recovery Workshop Training

Live Online & Classroom Enterprise Certification Training

This Database 11g Backup & Recovery training will teach you to evaluate your own recovery requirements & develop an appropriate strategy for backup & recovery procedures. Get hands-on practices and workshops in a realistic technical environment.

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 Certification Training about?

This Oracle Database 11g: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll learn to develop an appropriate strategy for backup and recovery procedures; please note that this course is based on Oracle Database 11g Release 2 Patch Set 1.

By enrolling in this course, you'll get a chance to participate in hands-on practices and workshops that give you experience working within a realistic technical environment. These interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.

This course reviews the backup and recovery techniques discussed in the Oracle Database 11g: Administration Workshop I and II courses. Expert Oracle University instructors will help you examine various backup, failure, restore and recovery scenarios.

Please note that you're expected to have some knowledge of Recovery Manager (RMAN) and Enterprise Manager, as you'll use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are also described as an additional way to recover from various errors.

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

Perform tablespace point-in-time recovery
Describe the Oracle Database architecture components related to backup and recovery operations
Describe additional high availability features such as Oracle Data Guard and Oracle Secure Backup
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

Who is Backup and Recovery Workshop Certification Training for?

Database Administrators
Technical Consultant
Technical Administrator

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

Suggested Prerequisite

Knowledge of Oracle Database administration
Knowledge of RMAN and Enterprise Manager

Required Prerequisite

Oracle Database 11g: Administration Workshop I Release 2
Oracle Database 11g: Administration Workshop II Release 2

Available Training Modes

Live Online Training

24 Hours

Classroom Training

3 Days

Course Outline Expand All

Expand All

Introduction

Oracle Maximum Availability Architecture

Oracle Active Data Guard (overview only)

Oracle Secure Backup (overview only)

Data Failures Examples

Oracle Backup and Recovery Solutions

Oracle Data Protection Solutions

Assessing Your Recovery Requirements

Failure Categories

Using Recovery Manager (RMAN) and Enterprise Manager

Enterprise Manager (backup and recovery interface overview)

Viewing and Managing RMAN Persistent Settings

Configuring RMAN Persistent Settings

Using the RMAN Command-Line

Oracle Recovery Manager (architecture overview)

RMAN Commands (overview)

Configuring for Recoverability

RCHIVELOG Mode and the Archiver Process

Fast Recovery Area (overview)

Undo Retention

Fast Recovery Area Sizing and Configuration

Archived Redo Log Files

Redo Log File Multiplexing

Redo Log Files and the LGWR Process

Control File Multiplexing & Autobackup

Using the RMAN Recovery Catalog

Managing Records in the Catalog

Registering the Database

Creating the Recovery Catalog

Backing Up the Recovery Catalog

Repository Comparison

Catalog Resynchronization

Recovery Catalog Overview

Backup Concepts and Strategies

Best Practices for Data Warehouse Backups

Understanding RMAN Backup Data Flow

Balancing Backup and Restore Requirements

RMAN Backup Types

Comparing Backup Strategies

Backup Terminology

Backup Solutions Overview

Creating Backups

Backups Sets & Image Copies (RMAN)

Control File Backups & Cataloging Backups Files

Read-Only Tablespace Backups

Oracle Suggested Backup Strategy

Whole Database Backups

Block Change Tracking/Fast Incremental Backups

Backup Compression & RMAN Encrypted Backups

Checking for Block Corruption

Restore and Recovery Concepts

Instance Failure and Instance/Crash Recovery

Recovery to an Abandoned Incarnation

Complete Recovery (Overview)

Point-in-Time Recovery (Overview)

Employing the Best Oracle Technology for Recovery

Media Failure

Recovery Through RESETLOGS

Using Data Recovery Advisor

Using the Data Recovery Advisor (overview)

Using the Data Recovery Advisor RMAN Command-Line Interface

Using the Data Recovery Advisor in Enterprise Manager

Data Recovery Advisor Overview

Performing Recovery

Restore and Recovery Performance Best Practices

Data File Loss (file system and ASM)

Block Media Recovery

Restoring RMAN Encrypted Backups

Redo Log File Loss and Recovery, Index Tablespace Recovery & Read-Only Tablespace Recovery

Control File Loss and Recovery & RMAN Recovery: Backup Control File

RMAN Recovery: NOARCHIVELOG Mode, Complete, Image Files & Point-in-Time (Incomplete recovery)

Password Authentication File Re-creation, Server Parameter File Recovery & Tempfile Recovery

Using Flashback Technologies

Flashback Technologies Overview

Best Practices for Undo-Based Flashback Technologies

Flashback Transaction

Flashback Table

Flashback Transaction Query

Flashback Drop

Flashback Query & Flashback Version Query

Preparing to use Flashback Technologies

Flashback Database

Flashback Database Architecture

Configuring Flashback Database

Best Practices for Flashback Database

Performing Flashback Database

RMAN Performance and Tuning

Restore and Recovery Performance Best Practices

RMAN Multiplexing

Tuning Principles

Diagnosing Performance Bottlenecks

Backup and Recovery Workshop Scenarios

Workshop Approach to Solving Failure Scenarios

Workshop Structure

Business Requirements for Database Availability and Procedures

Who is the instructor for this training?

https://www.springpeople.com/oracle-weblogic-server-11g-administration-essentials-training

Backup and Recovery Workshop 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