CTP 247 - Database Administration 2

3 credit hours - Two hours of lecture and two hours of laboratory weekly; one term.
Formerly CSI 225 - Database Administration 2

Focus on advanced topics in database administration. Learn data recovery techniques, performance monitoring, resource management, and database security through structured hands-on exercises. This course is the fourth in the series of Oracle database administration courses. This course addresses the core material of the Oracle Certified Associate exam objectives.

Prerequisite(s): CTP 245 with a grade of C or better or permission of the CTP department chair.

Note: Typically offered OL; spring term.

Course Outcomes:

User Managed Backups
- Cold backups
User Managed Restore and Recovery
- Manual Restore
- Recovery scenarios
Automatic Storage Management (ASM)
- ASM Overview
- ASM Instance
- Disk Group Creation
- Failure Groups and Redundancy
- ASM Operations
RMAN Backups
- Recovery Manager (RMAN) Oracle’s preferred Backup utility
- Configuration of RMAN per database
- RMAN Backup Scenarios
RMAN Catalog
- A Recovery catalog which stores the metadata about the backup
- An integral part of backup and recovery using RMAN
RMAN Recovery
- RMAN Recovery
- RMAN Reports and Lists
- Perform an Advanced Recovery using RMAN
Oracle Flashback Technology
- using Oracle-optimized flashback logs to restore the entire database to a specific point-in-time
Performance Resource Management
- Transportable TS
- Resumable Space Management
Automatic Diagnostics and Performance Management
- Automatic Diagnostic Repository
- Fault Diagnosability Infrastructure
DBMS Scheduler and Task Automation
- Schedule object
- Scheduler Architecture
Globalization Support in Oracle
- Database Character Sets and National Language Support
- Timezones
- Adding Locales