Oracle Database 10g / 11g: Administration II
Summary:
This course provides the information for database administrators to become fully responsible for ongoing Oracle database operations, backup, recovery, tuning and using advanced features of the Oracle database. The first 2-day segment provides in-depth understanding of backup and recovery concepts, backup set-up, and using RMAN in practical backup and recovery scenarios. The remaining 2 days cover advanced administration tasks such as understanding the Oracle self-tuning database approach, utilizing the Oracle scheduler, controlling resource utilization through Resource Plans, comprehensive coverage of the various Flashback technologies, Oracle support for multi-national/lingual functionality and using Automatic Storage Management.
Duration:
4 Days/Lecture & Lab
Audience:
This course is designed for Oracle database administrators.
Topics:
- Course Overview and Introduction
- Securing the Listener
- Overview of Recovery Manager (RMAN)
- Configuring RMAN
- Backing up Using RMAN
- Recovering From Non-Critical Crashes
- Database Recovery
- Flashback Database
- Recovering User Errors
- Handling Block Corruption
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Manager (ADDM) and the Advisor Framework
- Database Resource Management
- The Scheduler
- Globalization Support
- Automatic Storage Management (ASM)
Prerequisites:
SQL and PL/SQL or comparable experience is required. Knowledge of routine database administration tasks is recommended. Students without database administration experience will likely struggle with this class.
Last Update: May 23, 2012
