Close Window

I.

Course Prefix

Course Number

Course Name

Credit

Lecture

Lab

CIS 

245

Database Fundamentals II

3

3

1

II.

Prerequisite:

See recommendation in Course (Catalog) Description

III.

Course (Catalog) Description:

Course continues developing the knowledge needed by the database administrator to maintain a database. Content includes methods to backup, restore, and recover the database given various different scenarios; transporting data between databases and the utilities used; networking concepts and configuration parameters; solving common network problems; configuring network parameters to allow the database clients to communicate with the database server. Course prepares student for corresponding Oracle Database Administrator certification exam. Recommended: CIS 145 or comparable knowledge.

IV.

Learning Objectives:

At the end of the course, the student will be able to:

1. Perform database and data file backups with and without Recovery Manager (RMAN).
2. Define networking requirements
3. Configure the network environment for an Oracle client-server system
4. List the different Oracle backup methods and recovery operations to resolve      database failure
5. Describe the database utilities (Export and Import) and the situations where they can be used
6. Describe the network configuration and recovery techniques given various scenarios
7. List the Oracle architecture components related to backup and recovery operations.

V.

Academic Integrity:

Students and employees at Oakton Community College are required to demonstrate academic integrity and follow Oakton's Code of Academic Conduct. This code prohibits:

  • cheating
  • plagiarism (turning in work not written by you, or lacking proper citation)
  • falsification and fabrication (lying or distorting the truth)
  • helping others to cheat
  • unauthorized changes on official documents
  • pretending to be someone else or having someone else pretend to be you
  • making or accepting bribes, special favors, or threats
  • any other behavior that violates academic integrity

    • There are serious consequences to violations of the academic integrity policy. Oakton's policies and procedures provide students a fair hearing if a complaint is made against you. If you are found to have violated the policy, the minimum penalty is failure on the assignment and, a disciplinary record will be established and kept on file in the office of the Vice President for Student Affairs for a period of 3 years.

    Details of the Code of Conduct can be found in the Student Handbook.

    VI.

    Outline of Topics:

    A. Networking Overview
    B. Basic Oracle Net Architecture
         1.  Oracle net architecture
         2.  Oracle net services role in client-server connections
         3.  Describing how web client connections are established
    C. Basic Oracle Net Services Server-Side Configuration
         1.  Identifying how the listener responds to incoming connections
         2.  Configuring the listener using Oracle Net Manager
         3.  Controlling the Oracle net listener by using the listener control utility
         4.  Describing dynamic service registration
         5.  Configuring the listener for IIOP and HTTP Connections
    D. Basic Oracle Net Services Client-Side Configuration
         1. Describing the difference between host naming and local service name          resolution
         2. Using Oracle Net Configuration Assistant to configure host naming method,          local naming method, and net service names
         3. Performing simple connection troubleshooting
    E. Usage and Configuration of the Oracle Shared Server
         1. Identifying the components of the Oracle shared server
         2. Describing the Oracle shared server architecture
         3. Configuring shared servers by using initialization parameter
         4. Configuring dispatchers by using initialization parameters
         5. Identifying useful data dictionary views
    F. Backup and Recovery Overview
         1. Describing the basics of database backup, restore, and recovery
         2. Listing the types of failures that may occur in an Oracle environment
         3. Defining a backup and recovery strategy
    G. Instance and Media Recovery Structures
         1. Describing the Oracle processes, memory structures, and files relating to          recovery
         2. Identifying the importance of checkpoints, redo log files, and archived log files
         3. Describing ways to tune instance recovery
    H. Configuration of the Database Archiving Mode
         1. Noarchivelog and archivelog mode configuration
         2. Automatic and manual archiving of redo log files
         3. Multiple archival destinations and processes
    I. Oracle Recovery Manager (RMAN) Overview and Configuration
         1. Identifying the features and components of RMAN
         2. Describing the RMAN repository and control file usage
         3. Describing channel allocation
         4. Describing media management library interface
         5. Connecting to recovery manager
         6. Configuring the RMAN environment
    J. User-Managed Backups
         1. Describing user-managed backup and recovery operations
         2. Performing closed database backups
         3. Performing open database backups
         4. Cleaning Up After a Failed Online Backup
         5. Backing Up the Control File
         6. Discussing backup issues associated with read-only tablespaces
         7. Identifying the backup implications of operations with NOLOGGING Options
         8. Using DBVerify to check for block corruption
    K. RMAN Backups
         1. Identifying RMAN specific backups
         2. Using the RMAN BACKUP command to create backup sets
         3. Backing up the control file
         4. Backing up the archived redo log files
         5. Using the RMAN COPY command to create image copies
    L. User-Managed Complete Recovery
         1. Describing media recovery
         2. Performing recovery in noarchivelog mode
         3. Performing Recovery in archivelog mode
         4. Read-only tablespace recovery
         5. Relocating and recovering a tablespace
    M. RMAN Complete Recovery
         1. Describing the Use of RMAN for restoration and recovery
         2. Performing recovery in noarchivelog mode
         3. Performing completing recovery in archivelog mode
         4. Restoring data files to a different location
         5. Relocating and recovering a tablespace
    N. User-Managed Incomplete Recovery
         1. Describing the steps of incomplete recovery
         2. Identifying the situations which require incomplete recovery
         3. Performing an incomplete recovery
         4. Recovering from the loss of current online redo logs
    O. RMAN Incomplete Recovery
         1. Performing incomplete recovery using UNTIL TIME
         2. Performing incomplete recovery using UNTIL SEQUENCE
    P. RMAN Repository Maintenance
         1. Performing crosschecking of backups and copies
         2. Updating the repository when backups have been deleted
         3. Changing the availability status of backups and copies
         4. Making a backup or copy exempt from the retention policy
         5. Cataloging backups made with operating system commands
    Q. RMAN catalog creation and Usage
          1. Describing the contents of the recovery catalog
          2. Listing the RMAN features which require the recovery catalog
          3. Creating the recovery catalog
          4. Maintaining the recovery catalog by using RMAN commands
          5. Using RMAN to register, resynchronize, and reset a database
          6. Querying the recovery catalog to generate reports and lists
          7. Creating, storing and executing scripts
          8. Describing methods for backing up and recovering the recovery catalog
    R. Transporting Data Between Databases
          1. Export
          2. Import

    VII.

    Methods of Instruction:

    Reading, lecture, discussion, group work, demonstrations , hands-on exercises and projects, assignments, quizzes, and/or tests

    VIII.

    Course Practices Required:

    A.  Appropriate attendance
    B.  Satisfactory completion of lab projects
    C.  Completion of assignments and tests.
    D.  Read textbook and research appropriate manuals as needed

    IX.

    Instructional Materials:

    TEXTBOOK: TBA

    X.

    Methods of Evaluating Student Progress:

    Students will be evaluated on quality of their lab projects, other written and/or oral assignments, quizzes, and exams as specified by the instructor.

    XI.

    Other Course Information:

    If you have a documented learning, psychological, or physical disability you may be entitled to reasonable academic accommodations or services.  To request accommodations or services, contact the ASSIST office in the Learning Center.  All students are expected to fulfill essential course requirements.  The College will not waive any essential skill or requirement of a course or degree program.

    Go to the TOP of the Page

    OAKTON HOME | ACADEMIC PROGRAMS | PREVIOUS PAGE

    Copyright © 2006    Oakton Community College
    Please direct questions or comments about the Oakton web site to the Webmaster.
    For further information or questions about the CIS discipline, please contact the Page Coordinator 
    and the CIS Coordinator,     Michele Reznick, at (847) 635-1904.
    Last updated: