Oracle Database 11g: Backup and Recovery Workshop

Oracle Database 11g: Backup and Recovery Workshop Certification Training Course Overview

Oracle Database 11g: Backup and Recovery Training Course imparts essential skills to evaluate backup and recovery requirements of an enterprise environment. Participants enrolled for this Oracle Database Backup and Recovery training will become well versed in developing apt strategies for discovering various techniques and procedures to manage backup and recovery as per business requirements.  
 
Competing this Oracle Database 11g course successfully will make candidates adept at giving smart backup solutions with efficient techniques for a unique business enterprise.
 

Oracle Database 11g: Backup and Recovery Workshop (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2550
04 - 06 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)
01 - 03 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 2900
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1:Introduction
  • Assessing Your Recovery Requirements
  • Data Failures Examples
  • Failure Categories
  • Oracle Data Protection Solutions
  • Oracle Backup and Recovery Solutions
  • Oracle Maximum Availability Architecture
  • Oracle Secure Backup (overview only)
  • Oracle Active Data Guard (overview only)
Module 2:Using Recovery Manager (RMAN) and Enterprise Manager
  • Oracle Recovery Manager (architecture overview)
  • Enterprise Manager (backup and recovery interface overview)
  • Using the RMAN Command-Line
  • RMAN Commands (overview)
  • Configuring RMAN Persistent Settings
  • Viewing and Managing RMAN Persistent Settings
Module 3:Configuring for Recoverability
  • Fast Recovery Area (overview)
  • Fast Recovery Area Sizing and Configuration
  • Control File Multiplexing & Autobackup
  • Redo Log Files and the LGWR Process
  • Redo Log File Multiplexing
  • RCHIVELOG Mode and the Archiver Process
  • Archived Redo Log Files
  • Undo Retention
Module 4:Using the RMAN Recovery Catalog
  • Repository Comparison
  • Recovery Catalog Overview
  • Creating the Recovery Catalog
  • Managing Records in the Catalog
  • Registering the Database
  • Catalog Resynchronization
  • Backing Up the Recovery Catalog
Module 5: Backup Concepts and Strategies
  • Backup Solutions Overview
  • Backup Terminology
  • RMAN Backup Types
  • Understanding RMAN Backup Data Flow
  • Balancing Backup and Restore Requirements
  • Comparing Backup Strategies
  • Best Practices for Data Warehouse Backups
Module 6:Creating Backups
  • Oracle Suggested Backup Strategy
  • Backups Sets & Image Copies (RMAN)
  • Whole Database Backups
  • Read-Only Tablespace Backups
  • Checking for Block Corruption
  • Block Change Tracking/Fast Incremental Backups
  • Backup Compression & RMAN Encrypted Backups
  • Control File Backups & Cataloging Backups Files
Module 7:Restore and Recovery Concepts
  • Employing the Best Oracle Technology for Recovery
  • Instance Failure and Instance/Crash Recovery
  • Media Failure
  • Complete Recovery (Overview)
  • Point-in-Time Recovery (Overview)
  • Recovery Through RESETLOGS
  • Recovery to an Abandoned Incarnation
Module 8:Using Data Recovery Advisor
  • Data Recovery Advisor Overview
  • Using the Data Recovery Advisor (overview)
  • Using the Data Recovery Advisor in Enterprise Manager
  • Using the Data Recovery Advisor RMAN Command-Line Interface
Module 9:Performing Recovery
  • Data File Loss (file system and ASM)
  • RMAN Recovery: NOARCHIVELOG Mode, Complete, Image Files & Point-in-Time (Incomplete recovery)
  • Control File Loss and Recovery & RMAN Recovery: Backup Control File
  • Redo Log File Loss and Recovery, Index Tablespace Recovery & Read-Only Tablespace Recovery
  • Password Authentication File Re-creation, Server Parameter File Recovery & Tempfile Recovery
  • Restoring RMAN Encrypted Backups
  • Block Media Recovery
  • Restore and Recovery Performance Best Practices
Module 10:Using Flashback Technologies
  • Flashback Technologies Overview
  • Preparing to use Flashback Technologies
  • Flashback Query & Flashback Version Query
  • Flashback Table
  • Flshback Transaction Query
  • Flashback Transaction
  • Flashback Drop
  • Best Practices for Undo-Based Flashback Technologies
Module 11:Flashback Database
  • Flashback Database Architecture
  • Configuring Flashback Database
  • Performing Flashback Database
  • Best Practices for Flashback Database
Module 12:RMAN Performance and Tuning
  • Tuning Principles
  • RMAN Multiplexing
  • Diagnosing Performance Bottlenecks
  • Restore and Recovery Performance Best Practices
Module 13:Backup and Recovery Workshop Scenarios
  • Workshop Structure
  • Workshop Approach to Solving Failure Scenarios
  • Business Requirements for Database Availability and Procedures
Download Course Contents

Request More Information

Course Prerequisites
Basic knowledge of Oracle Database
 
On course completion, participants will be able to learn:
 
  • Understand the architecture and components of backup and recovery for an Oracle Database
  • Implement Oracle Secure Backup and Oracle Data Guard features for ensuring high availability
  • Plan and execute appropriate procedures for backup and recovery
  • Understand and execute the right backup methods and recovery operations for resolving database failures
  • Conduct tablespace point-in-time recovery
  • Configure and execute the database for recoverability
  • Create backups and conduct recovery activities using RMAN (Recovery Manager)
  • Diagnose and resolve failures using Data Recovery Advisor
  • Recover from human errors using Oracle Flashback Technologies
  • Conduct an encrypted backup and restore 

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 11g: Backup and Recovery Workshop Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

FAQ's