Regis University
MSCIT Program
Database Technologies Emphasis
Course: MSCD 642 – Backup and Recovery
Credit Hours: 3 credits
Term: Summer 8W2 2004
Course Starts 07/08/2004
Schedule: Ends 08/26/2004
Lowell campus rm 2
Thursday
Instructor: Richard Maxfield
Office Hours: By appointment
E-mail: maxfieldrichard@qwest.net
Prerequisites: MSCD 600 Database Architecture,
MSCD 610 Database Concepts,
MSCD 640 Database Administration
FIRST CLASS ASSIGNMENT:
Prior to first class: Reading Assignments before Week One: Oracle9i Database
Administrator II text – Chapters 1 and 2
TEXTS:
Required Text: Morris-Murphy (2004). Oracle9i Database Administrator II:
Backup/Recovery and Network Administration. Course
Technology. ISBN: 0-619-15902-2.
Additional Text: Kuhn, Darl, & Schulze, Scott (2002). Oracle RMAN Pocket
Reference, O’Reilly, ISBN: 0-596-00233-5
COURSE DESCRIPTION:
This course studies the critical tasks of planning and implementing database backup and
recovery strategies. Explores backup methodologies based on business requirements in a
typical enterprise and utilizes multiple strategies to recover from different types of
recovery failures.
COURSE OBJECTIVES:
Upon completing this course, you will be able to:
List key issues involved when defining an effective backup and recovery
strategy.
List Oracle architecture components related to backup and recovery
operations.
Diagnose and troubleshoot database problems and failures.
Identify industry standard Oracle backup and recovery solutions.
1
Configure and implement Cold Backups, Hot Backups, and Oracle
Recovery Manager (RMAN) to backup, restore, and recover databases.
Issue commands to perform complete and incomplete recoveries to
resolve database failures.
Use standard Oracle tools to load data, export and import objects.
List Oracle Net architecture components.
Configure and implement Oracle Net.
Identify network security risks and related Oracle solutions.
Define key elements of a shared server environment.
Configure and implement Oracle in a shared server environment.
COURSE POLICIES
ATTENDANCE:
Students are expected to attend all classes. Due to the limited number of class periods in
each term, students who miss more than one class may expect that their course grade will
be lowered by one letter grade. A student should inform the instructor in advance if s/he
is unable to attend a class meeting. The student is still responsible for materials covered
in class during their absence.
LATE ASSIGNMENTS:
Late assignments will be accepted with early notifications.
GRADING:
Grades will be based on individual effort and points earned on the GPA rating scale (4.0):
Your grade in the course will be calculated based on the following table:
Grading Criteria
Activity Weight
Class Participation 10%
Course Lab Work 25%
Weekly Review Questions 30%
Paper 10%
Final Exam 25%
TOTAL: 100%
2
Grading Scale
A 4.00 Outstanding scholarship
A- 3.67
B+ 3.33
B 3.00 Satisfactory
B- 2.67
C+ 2.33
C 2.00
Unsatisfactory (or minimum mastery; the minimum of what was
expected).
C- 1.67
D+ 1.33
D 0.67 Unsatisfactory (some mastery, but generally inadequate and less than
expected).
D- 0.33
F 0.00 Failure, no credit (virtually no demonstrated mastery).
CLASS PARTICIPATION:
Class participation will count towards the final grade. Showing up in class is not
participation; it should involve engaging in discussions, etc.
CHEATING & PLAGIARISM:
Cheating is NOT allowed in this course. Cheating is when one student copies the work of
another student with or without the knowledge of the other student. Any student caught
cheating will automatically receive a grade of ‘F’ for the respective assignment and will
be reported to the MSCIT Degree Chair.
Plagiarism is when a student uses part or whole of a published work without citing the
work, and is submitted as an original work of theirs. Any work showing evidence of
plagiarism will result in a grade of ‘F’ on the respective assignment without the benefit of
resubmission.
Equal Access to Learning and Accommodations
Equal access to education means equal opportunity to learn. Under Section 504
of the 1973 Rehabilitation Act and the Americans with Disabilities Act of 1990,
students with verified disabilities who are otherwise qualified, have a right to
equal access to classes at Regis University. If you are a student with a disability
3
and you need accommodations for this class, please document your disability
and discuss necessary accommodations with the Director of Learning Support
Services (Lowell Campus, Carroll Hall 225, phone 303-458-4941), and schedule
an appointment the first week of the session. The Disability Services home page
is located at http://www.regis.edu/disability.
TENTATIVE COURSE OUTLINE*
Note: For weekly assignments (labs, quizzes, and reading) refer to
http://www.richardm.us
Course Outline
Work- Readings Due Topics Assignments
shop Due
One Oracle9i Database Course orientation and Log in to
Administrator II introductions Oracle
(Chapters 1,2) Backup and Recovery account and
overview complete any
Archiving assigned lab
work.
Two Oracle9i Database User managed backups
Administrator II User managed complete
(Chapters 3,4) recovery Lab 1A, 1B
Three Oracle9i Database User managed incomplete
Administrator II recovery
(Chapter 5,6) Overview of Recovery Lab 2,3
manager
Oracle RMAN
Pages 1-15
Four Oracle9i Database Backup operations using
Administrator II RMAN
(Chapter 7,8) Complete recovery with Lab 4
RMAN
Oracle RMAN
Pages 16-56
4
Five Oracle9i Database Incomplete recovery with
Administrator II RMAN
(Chapter 9,10) Recovery Manager Lab 5
maintenance
Six Oracle9i Database Recovery catalog
Administrator II Loading and transporting data
(Chapter 11,12)
Lab 6
Seven Oracle9i Database Network administration
Administrator II Server side configuration
(Chapter 13,14)
Client side configuration Lab 7
Eight Oracle9i Database Course evaluation
Administrator II Final exam
(Chapter 15)
Lab 8
* The tentative nature of this course outline denotes that topics may vary depending on
the needs of the students and at the discretion of the instructor, which is based on the
speed of the course.
Assignments to be completed prior to Workshop One
1. Read: Oracle9i Database Administrator II text – Chapters 1 and 2
2. Sign up for an account with the Oracle Technology Network (OTN).
3. Sign up to receive the FREE Oracle Magazine through www.oramag.com.
4. 2. Visit and give a thorough review of the www.oracle.com web site.
5. Write a double spaced, 2-3 page synopsis of news, product releases and
current events posted on the Oracle web site (www.oracle.com). The
paper should follow MLA format.
5
Professional Paper Guidelines
The student should prepare a 7-10 page written report on an Oracle Backup and Recovery
or Network Administration subject.
The paper will be graded on structure, content, and continuity.
Topic sentence and introductory paragraph 10%
Paper body content 50%
Summary paragraph 10%
Spelling and grammar 10%
Overall flow and readability 10%
References and citations (if appropriate) 10%
The following are samples of appropriate topics:
1. Export / Import
2. Backups • Online Backup (hot) • Offline Backup (cold)
3. Recovery Methods • Redo Application • Block Recovery • Thread Recovery •
Media Recovery • Database Recovery • Tablespace Recovery • Data File
Recovery
4. Disaster Recovery
5. Net8 Architecture
6. Oracle Names
7. Multithreaded Server (MTS)
8. Security in the Network Environment
Plagiarism is not acceptable!
Plagiarism is when a student uses part or whole of a published work without citing the
work, and is submitted as an original work of theirs. Any work showing evidence of
plagiarism will result in a grade of ‘F’ on the respective assignment without the benefit of
resubmission.
6