MSCD642 - Database Backup and Recovery: Syllabus

Instructor Information

Refer to Discussion Forum, Facilitator Introduction and Expectations

Course Title

MSCD642 - Database Backup and Recovery

Course Description

This course provides an introduction to database backup, restore, and recovery using Oracle 12c. You will study the critical tasks of planning and implementing database backup and recovery strategies. The course explores backup methodologies based on business requirements in a typical enterprise and utilizes multiple strategies to recover from different types of recovery failures. This course also introduces students to Oracle network concepts and administration. Students will access an Oracle instance located on the Academic Research Network (ARNe) via Citrix over the Internet.

Prerequisite Courses

MSCD 600 Database Architecture, MSCD 610 Database Concepts, and MSCD 640 Database Administration.

Course Outcomes

In addition to course objectives, the Regis University MSCD program is designed to implement University outcomes as an integral part of the curriculum, thus providing each student with a more comprehensive educational experience. With this goal in mind, upon the completion of this course students are expected to:

1. List key issues involved when defining an effective backup and recovery strategy.
2. List Oracle architecture components related to backup and recovery operations.
3. Diagnose and troubleshoot database problems and failures.
4. Identify industry standard Oracle backup and recovery solutions.
5. Configure and implement Cold Backups, Hot Backups, and Oracle Recovery; Manager (RMAN) to backup, restore and recover databases.
6. Issue commands to perform complete and incomplete recoveries to resolve database failures.
7. Use standard Oracle tools to load data, export and import objects.
8. List Oracle Net architecture components.
9. Configure and implement Oracle Net.
10. Identify network security risks and related Oracle solutions.
11. Define key elements of a shared server environment.
12. Configure and implement Oracle in a shared server environment.

Course Materials

Required Texts

Kuhn, D., Alapati, S., Nanda, A. (2013). RMAN Recipes for Oracle Database 12c: A Problem-solution Approach. New York, NY: APRESS. ISBN: 978-1430248361

Optional Materials

Coronel, C., Morris, S. & Rob, P. (2013). Database Systems: Design, Implementation and Management (10th ed.). New York, NY: Thompson. ISBN: 9781111969608.

Purdue Online Writing Lab (OWL), http://owl.english.purdue.edu/owl/resource/560/01/

American Psychological Association (current edition). APA Style, http://www.apastyle.org/

Technology Tools

The web-based Citrix technical environment for lab work can be found at this URL: http://myregisapp.regis.edu/Citrix/StoreWeb/

The login ID and password for the Citrix environment are your Regis Net credentials (e.g. Regis InSITE credentials).

Your instructor will provide you with user documentation within your Worldclass online course that will describe how to use the Citrix Lab Environment. Your instructor will also provide you with a database user ID/password or other database login instructions.

technical specifications

Pre-Assignment

Do the following before the first night of class:

• Read chapters 1 and 2 in RMAN Recipes for Oracle Database 12c: A Problemsolution Approach.
• The online version of the course has a few Powerpoint-based presentation in Week One that students can download. However, the instructor will provide you with new slides from the RMAN Recipes for Oracle Database 12c: A Problem-solution Approach.

Course Assignments and Activities

Note to Classroom Sections only

Exact dates for reading assignments and homework assignments may be one week earlier or later than indicated in the Course Overview Grid. The syllabus, handed out the first night of class, will indicate any changes.

Forum/Participation

Because of the accelerated nature of the course, in-class and online participation is important. Class participation/effort is important because we can all learn from each other.

Participation points can make a difference in the final grade. If the student doesn't participate during any given week, they will lose the participation points of that week.

In-class participation means:

1. Present in class every session
2. Effectively responds to questions from the facilitator
3. Contributes to discussions.

Online participation means:

1. Volume: Students should have a minimum of three postings per thread topic.
2. Frequency: Students should post three times per week. Post in the beginning of the week, in the middle of the week and at the end of the week.
3. Quality: What the facilitator is looking for is "value added" postings. Responding with something like "I agree" or "Good point" is not an acceptable posting.

Student Evaluation Grid

CCIS Policies

Review the CCIS Policies on the Regis University website.

OTHER INFORMATION

NOTE TO LEARNERS: On occasion, the course facilitator may, at his or her discretion, alter the Learning Activities shown in this Syllabus. The alteration of Learning Activities may not, in any way, change the Learner Outcomes or the grading scale for this course as contained in this syllabus. Examples of circumstances that could justify alterations in Learning Activities could include number of learners in the course; compelling current events; special facilitator experience or expertise; or unanticipated disruptions to class session schedule.