About this Course

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.

Audience Profile

Database Administrators

At Course Completion

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.

Course Outline

1. 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

2. 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

3. Configuration of the Database Archiving Mode

• Noarchivelog and Archivelog Mode Configuration
• Automatic and Manual Archiving of Redo Log Files
• Multiple Archival Destinations and Processes

4. 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

5. 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
• Backup Up the Control Files
• 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

6. 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

7. 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

8. 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 Tablespace

9. 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

10. RMAN Incomplete Recovery

• Performing Incomplete Recovery Using UNTIL TIME
• Performing Incomplete Recovery Using UNTIL SEQUENCE

11. 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

12. 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
• Maintain the Recovery Catalog 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

13. Flashback Technology

• Flashback Query
• Flashback Table
• Flashback Drop
• Flashback Database

14. Backup and Recovery and Networking Workshop

• The student is presented with various recovery scenarios
• Each scenario is documented
• Diagnosis
• Solutions
• Time to Complete
• Resources Needs