Oracle Backup and Recovery

Course Description

 

This Oracle online training course teaches you how to address Oracle Backup and Recovery issues. You will learn how to perform user managed backups and recoveries as well as Oracle managed backup and recoveries(RMAN).

 

In This Course You Will Learn How To:

  • Perform User Managed backup and recoveries
  • Perform Oracle Managed backup and recoveries
  • Configure RMAN
  • Create and configure the recovery catalog

 

Prerequisites

 

You need to have equivalent experience or have taken the following courses:

  • Oracle 10g/11g Database Administration I Part 1
  • Oracle 10g/11g Database Administration I Part 2

 

Outline

 

Module 00: Oracle Backup and Recovery Online Training - Course Introduction

 

Module 01: Backup methods

  • User Managed Backups
  • Oracle Managed Backups Types of Failures
  • Types of Recoveries

 

 

 

Module 02: Recovery Configuration

  • Configuring the Database for Archivelog
  • Configuring the Database for No-Archivelog
  • Configuring the Flash Recovery Area

 

 

 

Module 03: Configuring RMAN

  • RMAN Default Settings
  • Command Line
  • Enterprise Manager

 

 

 

Module 04: RMAN Backups

  • Full RMAN Backup
  • Compressed Backups
  • Uncompressed Backups
  • Partial RMAN Backup
  • Incremental Backups
  • Change Tracking File

 

 

 

Module 05: Managing Backups

  • Backup Reports
  • Backup Maintenance
  • Backup Catalog
  • Backup Crosscheck

 

Module 06: RMAN Complete Recovery

  • RMAN Complete Recovery
  • Database Recovery
  • Tablespace Recovery
  • Datafile Recovery

 

Module 07: RMAN In-Complete Recovery

  • Time Based Recovery
  • Sequence Based Recovery
  • SCN Based Recovery

 

Module 08: Non-Database File Recovery

  • Spfile Recovery
  • Controlfile Recovery
  • Incremental Recovery
  • Flash Recovery Area for a Fast Recovery

 

Module 09: User Managed Backup

  • Configuring User Managed Backups
  • Perform a User Managed Backup

 

Module 10: User Managed Recovery

  • User Managed Complete Recovery
  • User Managed Incomplete Recovery

 

Module 11: Configuring Flashback

  • Flashback Query
  • Flashback Drop
  • Flashback Database

 

Module 12: Performing Flashback Recoveries

  • Flashback Query
  • Flashback Drop
  • Flashback Transaction Query
  • Flashback Versions Query

 

Module 13: Performing Flashback Database

  • Determining the FRA Size
  • FRA Retention
  • Performing a Flashback Database

 

Module 14: RMAN Duplicate Command

  • Setting up for a Duplicate Database
  • Creating the Duplicate spfiles
  • Performing the Duplicate Command.

 

Module 15: RMAN Recovery Catalog

  • Configuring for the Recovery Catalog
  • Creating the Recovery Catalog

 

Module 16: Backups with the Recovery Catalog

  • Registering the Database with the Recovery Catalog
  • Performing Backups with the Recovery Catalog

 

Module17: Recoveries with the Recovery Catalog

  • Identifying Type of Recoveries with the Recovery Catalog
  • Performing Recoveries with the Recovery Catalog

 

Module 18: Recovery Catalog Maintenance

  • Registering Additional Databases with the Recovery Catalog
  • Cataloging Additional Backups with the Recovery Catalog
  • Recovery Catalog Scripts

 

Module 19: DataPump

  • Configuring Datapump
  • DataPump Exports
  • DataPump Imports

 

Module 20: Tuning RMAN

  • RMAN Sessions
  • RMAN Channels
  • RMAN Job Progress

 

Module 21: Oracle Backup and Recovery Online Training - Course Summary