| |
May 06, 2024
|
|
|
|
|
2022-2023 Catalog [ARCHIVED CATALOG]
|
DBMS 250 - Oracle Database Administration II
PREREQUISITES: DBMS 150 - Database Administration .
PROGRAM: Data Analytics
CREDIT HOURS MIN: 3
LECTURE HOURS MIN: 2
LAB HOURS MIN: 2
DATE OF LAST REVISION: Fall, 2016
Students explore the automatic database management, monitoring, and tuning facilities in an Oracle database environment. Topics include the recovery from user errors and database failures including flashback data archive and flashback transaction backout along with the Total Recall capability. Oracle Database Administration II includes topics controlling resource utilization, using database scheduler, handling database corruption, and troubleshooting database problems. Students will set up user-managed/automatically managed backup strategies and database recovery operations. Additionally, students will explore advanced use of Enterprise Manager Wizards, tools, and automatic storage management. Students are required to demonstrate course objectives through the appropriate Oracle certification exam preparation materials.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course the student will be expected to:
- Utilize Automatic Storage Management (ASM) to initialize, startup and shut down instances and to administer ASM disk groups.
- Configure database for recoverability using tools such as archive logs, retention policy and Flash Recovery Area.
- Use the RMAN Recovery Catalog including Creating, Configuring, and Synchronizing, backing up, and storing scripts.
- Configure Backup Specifications.
- Use RMAN to create multiple backup types, perform recoveries and duplicate databases.
- Perform User Managed Backup and Recovery.
- Perform Tablespace Point-in-Time Recovery (TSPITR).
- Monitor and Tune RMAN.
- Utilize Flashback Technology.
- Diagnose the Database using Automatic Diagnostice Repository, Support Workbench and Block Media Recovery.
- Manage Memory using Automatic memory management, SGA and PGA parameters.
- Manage Database Performance using SQL Tuning Advisor, SQL Access Advisor, and Database Replay.
- Manage space including resumable space allocation, transportable tablespaces and databases, and segment shrinking.
- Manage resources using the Database Resource Manager Components.
- Automate Tasks with the Scheduler.
- Administer the Scheduler to create Windows and Job classes and prioritize jobs.
COURSE CONTENT: Topical areas of study include -
- Memory Management
- Storage Mgmt & the Segment Advisor
- Resource Management
- Globalization
- Task Automation -The Scheduler (Basic)
- Database Diagnostics
- Task Automation -Scheduler (Advanced)
- Automatic Storage Management
- Recovery Concepts
- Oracle Flashback Technology
- Instance Recovery
- RMAN Configuration
- RMAN Backup and Recovery
- RMAN Management with EM
- User-Managed Recovery Operations
- Recovery Catalog
- Using the RMAN
- Advanced RMAN Capabilities
Course Addendum - Syllabus (Click to expand)
|
|
