California State University, Chico
Department of Computer Science
Syllabus/Course Requirements
Spring 2003
Course Number: CSCI 379 - 01
Course Title: Enterprise DBA Parts 1A and 3: Oracle 8i Backup, Recovery and Networking
Prerequisite: CSCI 379: Enterprise DBA Part 1A - Oracle 8i Architecture and Administration or experience or similar background
Course Times and Locations:
LECTURE: TR 0330PM-0445PM OCNL 241
LAB: MW 1100AM-1150AM OCNL 241
Instructor: Dr. Melody Stapleton
Instructor's Office Hours: TuTh 2 - 3:15 pm in OCNL 208
Faculty Phone: (530) 898-5617 , message 898-6442, fax 898-5995
Email: mjstapleton@csuchico.edu
Textbooks:
Course Description: This course will cover the basic principles and techniques of Backup and Recovery as well as Network Administration for the Oracle 8i DBMS. We will cover all 15 lessons in the Oracle Course Manuals for Backup and Recovery and all 10 lessons from the Oracle Course Manual for Network Administration and we will complete the bulk of the lab exercises from these manuals.
Course Goals: Students will be able to develop an effective backup and recovery strategy, understand Oracle recovery structures and processes, implement an effective backup and recovery configuration, learn how to create physical backups without the use of Recovery Manager, implement a complete recovery without the use of Recovery Manager, learn about incomplete recovery with archiving, learn the use of export and import as it relates to backup and recovery, learn backup and recovery with the use of Recovery Manager and learn about additional recovery issues and utilities. Students will also learn about the fundamentals of Oracle's Net 8 Networking facilities, including the basic Net 8 Architecture, Net 8 Client Configuration, centralized naming concepts of Net 8, use of the Oracle Names Server, Multi-threaded server configuration, use of Connection Manager, how to troubleshoot the Net 8 environment and how to ensure security in the Net 8 environment.
Course Notes: In Oracle Course Manuals, the Oracle Lab (OCNL 241) and on the web from my web page.
Web Page: www.ecst.csuchico.edu/~melody/ (watch for Live and Internet Courses for Spring 2002 - CSCI 379 - 02: Enterprise DBA Parts 1B and 3 - Oracle 8i Backup, Recovery and Networking)
Note: Are you sure you are taking the right course? It is mandatory that you have had the equivalent of CSCI 379 - Enterprise DBA Part 1A: Oracle 8i Architecture and Administration as a prerequisite. If you have not had this prerequisite, you need to drop the course and enroll in the archived version of the prerequisite course mentioned above, or wait until the prerequisite is offered in the next Fall semester.
Mandatory Attendance Policy for On-Campus Students: This course is in high demand from your fellow students. Only serious students who plan to attend each class should take this course. Otherwise, you should drop the course and make room for other, serious students who desire to take this course. It is mandatory that you attend the lectures for this course. You can be dropped from the course for non-attendance. Each unexcused absence will result in a half letter grade reduction for your overall grade for the course. Thus, if you miss class once, you will receive at maximum a grade of "A-". If you miss the course twice, you will receive maximum of "B+" for your grade. If you are ill, you must notify Dr. Stapleton via email before you miss the class. If you are ill for more than one class in a row, you must provide a Doctor's excuse. You may be excused for family emergencies. Non-attendance due to workload in this course or other courses is not acceptable as an excuse. A seating chart will be made and your attendance will be noted daily. There are many more students that desire this course than can fit in the classroom, so your seat in this course is quite valuable.
Plagiarism/Cheating Policy: Anyone who as determined by the Instructor/TA has copied any part of another students work will automatically receive a grade of "F" for the course. Anyone cheating on an exam will receive a grade of "F" for the course. Anyone who alters their exam answers after receiving the exam back with receive a grade of "F" for the course.
Course Assignments:
There will be lab exercises assigned from the Oracle Course Manuals. Students will need to demonstrate completion of these exercises. There will also be a cumulative Backup and Recovery Workshop lab exercise that will be done in a group setting. If a group is not available, the instructor may approve of an individual conducting the workshop.
Policy on Turning in Lab and Homework Assignments: Due dates are firm. No late assignments will be accepted unless serious illness or other excused absences merit allowances in the judgment of the instructor.
Grade Evaluation Procedures: Students will be graded based on their performance in the following course components -
First Assignment: Read Lesson 1 and 2 from your Oracle 8i: Backup and Recovery Course Manual. Send email to mjstapleton@csuchico.edu right away with your full name, the courses you have taken including whether or not you have had the equivalent of our Oracle 8i Database Administration course, the languages and applications you know, your experience with database management systems and your interest in this class and in computer science in general.