Oracle Backup and Recovery

SEE SCHEDULE

Duration: 4 days

Method: Instructor led, Hands-on workshops

Price: $2100.00

Course Code: OR5520

Audience

Database Administrators

Description

This course gives the Oracle database administrator (DBA) a firm foundation in Oracle backup and recovery operations. It addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations. This course includes interactive workshops that provide participants with the opportunity to walk through real-world backup and recovery case studies.

Objectives

Upon successful completion of this course, the student will be able to:

Perform database and datafile backups with and without Recovery Manager (RMAN)
List the different Oracle backup methods and recovery operations that can be used to resolve database failure
Describe the database utilities (Export and Import) and the situations where they can be used
List the Oracle architecture components related to backup and recovery operations

Prerequisites

OR5510 Oracle Database Administration or Oracle DBA experience

Topics

I.Backup and Recovery Overview
- Describing the Basics of Database Backup, Restore, and Recovery
- Listing the Types of Failures that May Occur in an Oracle Environment
- Defining a Backup and Recovery Strategy
II.Instance and Media Recovery Structures
- Describing the Oracle Processes, Memory Structures, and Files Relating to Recovery
- Identifying the Importance of Checkpoints, Redo Log Files, and Archived Log Files
- Describing Ways to Tune Instance Recovery
III.Configuration of the Database Archiving Mode
- Noarchivelog and Archivelog Mode Configuration
- Automatic and Manual Archiving of Redo Log Files
- Multiple Archival Destinations and Processes
IV.Oracle Recovery Manager (RMAN) Overview and Configuration
- Identifying the Features and Components of RMAN
- Describing the RMAN Repository and Control File Usage
- Describing Channel Allocation
- Describing Media Management Library Interface
- Connecting to Recovery Manager
- Configuring the RMAN Environment
V.User-Managed Backups
- Describing User-Managed Backup and Recovery Operations
- Performing Closed Database Backups
- Performing Open Database Backups
- Cleaning Up After a Failed Online Backup
- Backing Up the Control File
- Discussing Backup Issues Associated with Read-Only Tablespaces
- Identifying the Backup Implications of Operations with NOLOGGING Options
- Performing logical backups (export, import)
- Using Oracle Data Pump
VI.RMAN Backups
- Identifying RMAN Specific Backups
- Using the RMAN BACKUP Command to Create Backup Sets
- Backing Up the Control File
- Backing Up the Archived Redo Log Files
- Using the RMAN COPY Command to Create Image Copies
VII.User-Managed Complete Recovery
- Describing Media Recovery
- Performing Recovery in Noarchivelog Mode
- Performing Recovery in Archivelog Mode
- Read-only Tablespace Recovery
- Relocating and Recovering a Tablespace
VIII.RMAN Complete Recovery
- Describing the Use of RMAN for Restoration and Recovery
- Performing Recovery in Noarchivelog Mode
- Performing Completing Recovery in Archivelog Mode
- Restoring Data Files to a Different Location
- Relocating and Recovering a Tablespace
IX.User-Managed Incomplete Recovery
- Describing the Steps of Incomplete Recovery
- Identifying the Situations Which Require Incomplete Recovery
- Performing an Incomplete Recovery
- Recovering from the Loss of Current Online Redo Logs
X.RMAN Incomplete Recovery
- Performing Incomplete Recovery Using UNTIL TIME
- Performing Incomplete Recovery Using UNTIL SEQUENCE
XI.RMAN Repository Maintenance
- Performing Crosschecking of Backups and Copies
- Updating the Repository When Backups Have Been Deleted
- Changing the Availability Status of Backups and Copies
- Making a Backup or Copy Exempt from the Retention Policy
- Cataloging Backups Made with Operating System Commands
XII.RMAN Catalog Creation and Usage
- Describing the Contents of the Recovery Catalog
- Listing the RMAN Features Which Require the Recovery Catalog
- Creating the Recovery Catalog
- Maintaining the Recovery Catalog by Using RMAN Commands
- Using RMAN to Register, Resynchronize, and Reset a Database
- Querying the Recovery Catalog to Generate Reports and Lists
- Creating, Storing and Executing Scripts
- Describing Methods for Backing Up and Recovering the Recovery Catalog
XIII.Flashback Technology
- Flashback Query
- Flashback Table
- Flashback Drop
- Flashback Database
XIV.Backup and Recovery and Networking Workshop
- The student is presented with various recovery scenarios
- Each scenario is documented
  - Diagnosis
  - Solutions
  - Time to Complete
  - Resources Needed