Division: Technology

Subject Code: CISCourse #: 247

Course Title: Database Backup and Recovery

HARRISBURG AREACOMMUNITY COLLEGE

FORM 335

Course Form 335 must be updated at least every five years per AP 765 to include, at a minimum, the following elements. [§335.2]

1.Digital Description:

Credit hours:3.0

Lecture hours: 3.0

Lab hours:0.0

BL: [__]⅓[__]½ [__]⅔[___] Other (Indicate fraction or percent)

2.Catalog Description: An introduction to the critical task of planning and implementing database backup and recovery strategies. The course addresses backup and recovery techniques and examines various backup, failure, restore, and recovery scenarios. Backup methodologies based on business requirements in a mission critical enterprise are also covered.

Minimum Grade Required

3.Prerequisites:CIS 243C

Corequisites:

Other: Or permission of the instructor

4.Learning Outcomes

[These outcomes are necessary to enable students to attain the essential

knowledge and skills embodied in the program’s educational objectives.]

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

  • Differentiate between the different Backup and Recovery Strategies
  • Perform Full DB Backup
  • Perform Tablespace Backup
  • Configure target database to be in archive log mode
  • Create Recovery Catalog
  • Register a target database
  • Configure the persistent RMAN parameters
  • Use RMAN commands to display Recovery Catalog information
  • Configure the Flash Recovery Area
  • Perform Full DB Recovery
  • Perform Incomplete DB Recovery
  • Configure Flashback Database
  • Use the various features of Flashback Database
  • Handle Block Corruption
  • Configure and Use Space Management Monitoring

5.Planned Sequence of Learning Activities

[These must be designed to help students achieve the learning outcomes.]

1. Recovery Manager:

Define Important Backup and Recovery Terms

Identify components of Recovery Manager

Discuss Backup Methods

2. RMAN:

Backing Up the Database Using RMAN

Backup Using RMAN

Performing Backups

Backups Using Enterprise Manager

Monitoring RMAN Backups

RMAN Commands

3. Recovery in Oracle:

Recovery Options

Recovery in the Database

Incomplete Recovery

Recovery of non-Critical Files

4. Flashback Database:

Review Flashback Database Components

Guidelines of the Flashback DB

Restrictions of a Flashback DB

Configuring a Flashback DB

Perform a Flashback DB

Potential Flashback DB Failures

Options available after a Flashback DB

Excluding a Tablespace from Flashback

Managing, Monitoring, and Disabling Flashback.

5. User Errors:

Use the Flashback Database to:

Drop data

Query Data

Access versions of Flashback DB

Identify individual transactions

6. Block Corruption:

Block and Blocks Corruption

Identify Block Corruption

Recover from Block Corruption

7. Automatic Database Management:

Performance Tuning

Common Manageability Infrastructure

Automatic Undo retention Tuning

8. Database Resource Manger:

Terminology and Overview

Configuring the DRM

Mapping Sessions

Data Dictionary Views

DRM using Enterprise Manager

9. Scheduler:

Oracle Scheduler

Advanced Components

Statistics

Data Dictionary Views

Identify Block Corruption

10. Space Management:

Tablespaces and Proactive Monitoring

Server-Generated Alerts

Segments and Segment Shrink features

Space Management Tools

Resumable Space Allocation

11. Memory Management:

Memory Structures

Program Global Area

12. Storage Management:

Overview of Automatic Storage Management

ASM Architecture

Administering ASM

Obtaining Data Dictionary Information

Migrating a DB to ASM

Using RMAN

13. Globalization Support, Diagnostic Tools, and Listener:

Globalization concepts

Diagnostic Tools

Listener

6.Assessment of Student Learning

[Methods of assessment should be appropriate for Learning Outcomes listed above.]

These Learning Outcomes will be assessed using a combination of assignments and exams.

7.List of Texts, References, Selected Library Resources or other Learning Materials (code each item based on instructional use): C-Lecture/Laboratory, A-Lecture, B-Laboratory, LC-Lecture/Clinical, CLN-Clinical, I-Online,

BL-Blended, V-Videocourse, D-Independent Study, P-Private Lessons,

E-Internship, F-Cooperative Work-Study, FE-Field Experience. [These resources must be easily accessible to students.]

Database Administrator II: Backup/Recovery & Network Administration; Claire Rajan; 1st Edition, Thomson/Course Technology, ISBN: 978-1-4188-3664-8

8.Prepared by Faculty Member: Paul C. MartinDate: 3/3/09

9.Approved by Department Chairperson:Date:

10.Approved by Academic Division Dean: Marjorie A. MattisDate: 10/5/09

This course meets all reimbursement requirements of Chapter 335, subchapters A / B.

This course was developed, approved, and offered in accordance with the policies, standards, guidelines, and practices established by the College. It is consistent with the college mission.

If the course described here is a transfer course, it is comparable to similar courses generally accepted for transfer to accredited four-year colleges and universities.

11.Director, Curriculum Compliance:Catherine A. LencioniDate: 10/6/09

12.Provost & VP, Academic Affairs: Ronald R. Young Date: 10/6/09

13.Original Date of course approval by the college:200320

14.Date(s) of subsequent reviews [Indicate change: Learning Outcomes; textbook(s)]:

December 2006

200620

200830

200930

12/1/04

Review and updated: 10/26/07; 1/11/08; 1/16/09