Maricopa Community Colleges  CIS117DQ   19996-20015 
Official Course Description:   MCCCD Approval:  02/23/99
CIS117DQ     19996-20015 L+L 2 Credit(s) 3 Period(s)
Oracle: Backup and Recovery
Various backup, failure, restore, and recovery scenarios that apply to Oracle database environments. Backup methodologies based on business requirements in a mission critical enterprise. Multiple strategies and Oracle tools such as Recovery Manager. Prerequisites: (CIS117DO and CIS117DP) or permission of the instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS117DQ   19996-20015 Oracle: Backup and Recovery
1. Diagnose and troubleshoot database problems. (I)
2. Perform various backup, failure, restore, and recovery scenarios. (II, III)
3. Use Oracle tools such as Recovery Manager to perform backups, restore, and recover operations. (II, III)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS117DQ   19996-20015 Oracle: Backup and Recovery
    I. Backup and recovery strategies
            a. Key issues involved when defining an effective backup and recovery strategy
            b. Methods for restoring Oracle recovery structures and processes
            c. Oracle backup and recovery configuration
            d. Implementing different types of backup methods using the various Oracle DBA tools
      II. Components of the Oracle Recovery Manager architecture
              a. Oracle recovery catalog maintenance
              b. Different Oracle backup methods
              c. Physical backups with and without Oracle recovery manager
              d. Logical backups using the export utility
              e. Appropriate restore and recovery operations to resolve database failure
              f. Diagnosing and troubleshooting database problems and failures
        III. Recovery Methods
                a. Recovering a database with and without archiving
                b. Complete and incomplete Oracle recovery with archiving
                c. Oracle export/import utilities
                d. Oracle standby databases
                e. Configuring a standby database to minimize primary database downtime
                f. Developing confidence of recovery techniques through various workshop scenarios
        Go to Description    Go to top of Competencies    Go to top of Outline