Standard

Posted: 09/06/07

R State Standard

£ Institutionally Developed

College: n/a

CIS 2130 – Oracle Database Backup and Recovery

 

Course Description:

 

This course introduces participants to the critical task of planning and implementing database backup and recovery strategies. The class addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios. Generic backup, restore and recovery operations.  Through hands-on exercises, participants will examine backup methodologies based on business requirements in a mission critical enterprise. Participants will utilize multiple strategies and Oracle tools such as Recovery Manager to perform backups, and restore and recovery operations.  Topics include: understand needs for backup and recovery, be able to understand and implement essential elements of a disaster recovery plan, understand Oracle recovery structures, understand and be able to implement Oracle Backup and Recovery operations, understand database recovery modes, be able to know when to utilize RMAN, be able to register, resync and reset an Oracle database, understand and be able to implement database backup procedures, troubleshooting database failures, understand and be able to use Oracle import and export utilities, and establish competencies for ORACLE Backup and Recovery Exam.

 

 Competency Areas:

Hours:

Understand needs for backup and recovery

Class

4

Be able to understand and implement essential elements of a disaster recovery plan

D. Lab

6

Understand Oracle recovery structures

P. Lab/O.B.I.

0

Understand and be able to implement Oracle Backup and Recovery operations

Credit

7

Understand database recovery modes

 

 

Be able to know when to utilize RMAN

 

 

Be able to register, resync and reset an Oracle database

 

 

Understand and be able to implement database backup procedures

 

 

Troubleshooting database failures

 

 

Understand and be able to use Oracle import and export utilities

 

 

Establish competencies for Oracle Backup and Recovery Exam

 

 

 

Prerequisite:   CIS 2128 and CIS 2129 

Corequisite:  

 

Course Guide

 

Competency

After completing this section, the student will:

Hours

Class

D. Lab

P. Lab/

O.B.I.

UNDERSTAND NEEDS FOR BACKUP AND RECOVERY

2 

3 

0

 

Be able to articulate the need for a backup and recovery strategy and know how to define a strategy.

 

 

 

BE ABLE TO UNDERSTAND AND IMPLEMENT ESSENTIAL ELEMENTS OF A DISASTER RECOVERY PLAN

4

6

0 

 

Be able to create a backup and recovery plan once the backup and recovery requirements are defined.

 

 

 

UNDERSTAND ORACLE RECOVERY STRUCTURES

4

6

0 

 

Understand Oracle’s processes, memory and file structures relating to recovery and identify the importance of checkpoints, redo logs, and archives.

 

 

 

UNDERSTAND AND BE ABLE TO IMPLEMENT ORACLE BACKUP AND RECOVERY OPERATIONS

 4

6 

0 

 

Identify recovery implications and differences between archiving modes.  Be able to apply the correct archiving configuration based on the Backup and Recovery needs.

 

 

 

UNDERSTAND DATABASE RECOVERY MODES

4

6

0 

 

Know how to apply the appropriate recovery method to resolve media failures. Be able to resolve problems using complete or  incomplete recovery types.

 

 

 

BE ABLE TO KNOW WHEN TO UTILIZE RMAN

4

6

0 

 

Be able to list the capabilities and setup requirements needed to run RMAN.  Understand features of RMAN that assist with utilization decisions.

 

 

 

BE ABLE TO REGISTER, RESYNC AND RESET AN ORACLE DATABASE

 4

6

0 

 

Know how to recover an Oracle database using recovery guidelines that involve time-based, cancel-based recovery and resetlogs. Learn how to handle other recovery issues when there is a loss of non-essential data files, or loss of control files. 

 

 

 

UNDERSTAND AND BE ABLE TO IMPLEMENT DATABASE BACKUP PROCEDURES

4

6

0 

 

Describe the recovery implications of closed and opened database backups and identify the backup implications of logging and nologging options.

 

 

 

TROUBLESHOOTING DATABASE FAILURES

4

6

0 

 

Learn which dictionary views are required to recover a database after a media failure.  Learn troubleshooting techniques that involve open and closed recovery methods.

 

 

 

UNDERSTAND AND BE ABLE TO USE ORACLE IMPORT AND EXPORT UTILITIES

4

6

0 

 

Learn how to user the export utility to create a complete logical backup of a database object and how to use the import utility to recover database objects.

 

 

 

ESTABLISH COMPETENCIES FOR ORACLE BACKUP AND RECOVERY EXAM

2

3

0 

 

Upon completion of this course, the student should be prepared to take the ORACLE Backup and Recovery Exam.

 

 

 

 

Suggested Resources

 

Books:

 

Enterprise DBA Part 1B Backup and Recovery; ORACLE; Oracle Academic Initiative (OAI) program http://www.oracle.com/

Oracle 8i: Backup and Recovery Strategies; ElementK Press (www.elementk.com); ISBN:  0-538-88152-6

 

 Reference Books:

 

Oracle Press http://www.oracle.com/