Oracle Database 10g DBA Part II — A 5 day course

contact usEnquire about this course
Retired Course; no longer available

Synopsis

This course introduces the delegate to advanced administration tools.

Participants will learn how to plan and implement a backup and recovery strategy using operating system backups, the import and export utilities and Recovery Manager. They will also learn how to control database resources using the Resource Manager. How to automate administration tasks with the Scheduler and how to carry out performance monitoring and tuning.

This course covers the main examination topics of the Oracle exam #1Z1-043 Oracle Database 10g: Administration II. Exams are not included as part of the course.

Objectives

The delegate will practise:

Suitable For

Database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle10g databases. This course is also suitable for delegates who need to be able to monitor and improve the database performance.

Prerequisites

Delegates should have a working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be obtained by attendance on the Oracle SQL and Oracle Database 10g DBA Part I courses

Knowledge of PL/SQL would be beneficial

Schedule

This course has been retired and is no longer available.


Contents

Backup and Recovery Considerations

Oracle Recovery Structures and Processes

Using ARCHIVELOG and NOARCHIVELOG Modes

Physical Backup without RMAN

Complete Database Recovery without RMAN

Incomplete Recovery with Archiving

Additional Recovery Issues

Globalization

Troubleshooting Utilities

Recovery Manager Overview

Creating and Maintaining a Recovery Catalog

Backing up with RMAN

Maintaining a Recovery Catalog

Restoring and Recovering with RMAN

Flashback

Managing Resourcse with Resource Manager

Automatic Storage Management

Automating Tasks with the Scheduler

Automatic Database Management

Memory Management, Alert and Waits

SQL Performance Tuning

Securing the Oracle Listener