Oracle Database 11g Release 2 DBA Backup & Recovery with RMAN

4 Day Course
Hands On
Code O11GBR

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

Delegates will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will perform backup and recovery operations using RMAN and Enterprise Manager. They will use Flashback features to recover from human error.

This Oracle Database 11g Release 2 Backup & Recovery with RMAN course is suitable for users of Oracle Database 11gR2 and for users of Oracle Database 12c.

Objectives

The delegate will learn and acquire skills as follows:

  • Planning a backup and recovery strategy and a disaster recovery strategy
  • Creating and managing a recovery catalog database
  • Using Recovery Manager to perform backups
  • Using Recovery Manager to perform recoveries
  • Monitor and Tune Recovery Manager
  • Performing tablespace point-in-time recovery
  • Perform an encrypted database backup and restore
  • Creating a duplicate database
  • Using Flashback technology to recover from errors

Target Audience

The Oracle Database 11g Release 2 Backup & Recovery with RMAN course is designed for database administrators, data warehouse administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11gR2 and Oracle Database 12c databases.

Additional Information

  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Backup and Recovery Considerations (7 topics)

  • Plan and Implement a Backup and Recovery Strategy
  • Define a Disaster Recovery Plan
  • Test a Backup and Recovery Plan
  • Advantages and Disadvantages of Different Backup Methods
  • Data Recovery Strategy
  • Backup Strategy
  • Validate the Recovery Strategy

Basic Restore and Recover with RMAN (16 topics)

  • Perform Recovery in Noarchivelog Mode
  • Perform Complete Recovery in Archivelog Mode
  • Use the Flash Recovery Area for Fast Recovery
  • Automatic Tempfile Recovery
  • Identify the Database Files to Restore and Recover
  • Preview Backups used in Restore Operations
  • Apply Incremental Backups to Restore Datafile Image Copies
  • The Switch Command
  • The Data Recovery Advisor
  • Perform Incomplete Recovery (PITR)
  • Restore and Recover a tablespace
  • Restore and Recover Datafiles
  • Recover a Datafile Not Backed Up
  • The 12c Table Recovery from Backups
  • Recover Individual Data Blocks
  • The Data Recovery Advisor

Monitor, Tune and Troubleshoot Backup and Recovery (4 topics)

  • Tune Recovery Manager Overview
  • Restore and Recovery Performance Best Practices
  • Multiplexing in RMAN
  • Diagnosing Performance Bottlenecks

Overview of RMAN and Oracle Secure Backup (7 topics)

  • Oracle Secure Backup Overview
  • Oracle Secure Backup Interfaces
  • Oracle Secure Backup Architecture
  • Oracle Secure Backup Jobs with RMAN
  • Backup the Fast Recovery Area to Tape
  • RMAN Backup to Tape
  • Overview of Integration with Cloud Control

Using Archivelog and Noarchivelog Modes (5 topics)

  • The Archive Modes of a Database
  • Configure a Database in Archivelog Mode
  • Configure a Database in Noarchivelog Mode
  • Configure Multiple Redo Log Archive Processes
  • Configure Multiple Archival Destinations

Flashback (14 topics)

  • Configure and Use Flashback Database
  • Monitor Flashback Database
  • Flash Recovery Area Space Usage
  • Flashback Query
  • Retrieve Row History with Flashback Versions Query
  • Audit or Recover From Transactions with Flashback Transactions Query
  • Flashback Table
  • Recover Dropped Tables with Flashback Drop
  • The Recycle Bin
  • Recover Tables to a Point In Time With Flashback Table
  • Flashback Database
  • Flashback Restore Points
  • Flashback Transaction Backout
  • Flashback Data Archive

Recovery Manager Overview (3 topics)

  • RMAN Features and Components
  • Connect to RMAN
  • Start Up and Shut Down a Target Database Using RMAN

Create and Configure a Recovery Catalog (12 topics)

  • Create a Recovery Catalog
  • Register a Database
  • Unregister a Database
  • Control File Information
  • RESYNC CATALOG Command
  • Virtual Private Catalogs
  • Merge Catalogs
  • Backup a Recovery Catalog
  • Use a Flashback Recovery Area
  • Configure Persistent RMAN Settings
  • Set Retention Policies
  • Configure Control File Autobackups

Backup with RMAN (12 topics)

  • Channel Allocation
  • Types of RMAN Backup
  • Backup Commands
  • Backup Sets Parallelization
  • Compressed Backups
  • Performing Backups
  • Full Closed and Open Backups
  • Incremental and Cumulative Backups
  • The Copy Command
  • Block Change Tracking
  • Backup Validate
  • Troubleshooting

Advanced Backup Techniques (6 topics)

  • Create Multisection Backups
  • Create Duplexed Backup Sets
  • Create Compressed Backups
  • Backup the Control File to a Trace File
  • Backup Recovery Files
  • Backup up ASM Metadata

Maintain a Recovery Catalog (9 topics)

  • Reset Command
  • Change the Availability Status of Backups and Copies
  • Catalog Backups Made with Operating System Commands
  • Generate Reports and Lists
  • Cross Check Backups and Copies
  • Delete Backups
  • Update the Repository after Backup Deletion
  • Drop Database
  • Use Data Dictionary Tables

Encrypted RMAN Backups (5 topics)

  • Create an Encrypted RMAN Backup
  • Transparent Encryption
  • Password Encryption
  • Password Encryption
  • Use Different Encryption Modes

Database Failure Diagnostics (6 topics)

  • The Automatic Diagnostic Repository
  • The Data Recovery Advisor
  • Understanding RMAN Messages and the Error Stack
  • Diagnose Data File Loss
  • Recovery with RESETLOGS
  • Dealing with Block Corruption

Overview of Restore and Recovery (6 topics)

  • Restore and Recover
  • Instance Failure and Crash Recovery
  • Media Failure
  • An Overview of Complete Recovery
  • An Overview of Point in Time Recovery
  • Recovery with RESETLOGS

Advanced Restore and Recover with RMAN (7 topics)

  • Restore the Server Parameter File
  • Restore the Control File
  • Re-create the Password File
  • Handling Redo Log File Loss
  • Restore and Recover the Database on a New Host
  • Restore RMAN Encrypted Backups
  • Disaster recovery

Tablespace Point-in-Time Recovery (2 topics)

  • Tablespace Point-in-Time Overview
  • Tablespace Point-in-Time Example

Transport Data (2 topics)

  • Transport Tablespaces
  • Transport Databases

Create a Duplicate Database with RMAN (8 topics)

  • Database Duplication
  • Duplication Options
  • Create Files for the Duplicate Database
  • Prepare the Auxiliary Instance for Duplication
  • Create a Duplicate Database
  • Create a Duplicate Database with Enterprise Manager
  • Clone a Running Database
  • Use EM to Clone a Running Database

Overview of Backup and Restore to Tape (6 topics)

  • Schedule Backups with Enterprise Manager
  • Oracle Suggested Backup Strategy
  • Perform Backups to Tape
  • Manage Tape Backups
  • Perform Recovery from Tape
  • RMAN Automatic Failover to Previous Backup

Prerequisites

A working knowledge of Oracle SQL and Oracle Database Administration. This can be obtained by attendance on the Oracle SQL and Oracle Database 11g DBA - Part I courses.

This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections