ORA11g202 - Oracle Database 11g R2: Administration II

Course ORA11g202

Table of Contents

Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline

Introduction

The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise.

Return to Top

Audience

The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful.

This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.

Return to Top

At Course Completion

Specific subject areas to be explored and objectives to be reached are:

• Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database.
• Using Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability.
• Controlling resource utilization on database servers whose resource demand exceeds its capacity.
• Automating launching routine maintenance tasks and even application functions using the database Scheduler.
• Handling database corruption.
• Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data.
• Automatic resumption of database operations even in the face of failures and errors.
• User-managed and automatically managed backup strategies and database recovery operations.
• Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, and others.
• Automatic Storage Management (ASM) of some or all database files, providing a database-centric and optimized storage subsystem and volume manager.

Return to Top

Prerequisites

Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory.

Specific course prerequisites for this course are: