Oracle Database 10g DBA - Part 2

Delegates:
 
This course is designed 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. 

Objectives:
 
This course introduces delegates to the main concepts of Oracle backup and recovery.  They will learn how to plan and implement a backup and recovery strategy using operating system backups, the import and export utilities and Recovery Manager.  Delegates will learn how to monitor and improve database performance.  They will also learn how to control database resources using Resource Manager, automate tasks with the Scheduler and use Automatic Storage Management (ASM).   This course covers the main topics of the Oracle exam #1Z1-043 Oracle Database 10g: Administration II. 

Topics Covered:
 
Plan a Backup Strategy
Plan a Disaster Recovery Strategy
Alter a Database to Archivelog and NoArchivelog Modes
Online and Offline Backups
Complete and Incomplete Database Recovery
Recover a Database from Non-Critical Losses
Perform Logical Backups with Export and Import Utilities
Use RMAN to Perform Backups And Restore
Use Flashback Technology to Recover a Database
Use Flashback to Recover From User Errors
Database Corruption
Diagnostic Sources
Use Automatic Database Management
Monitor and Manage Storage
Use Automatic Storage Management
Monitor and Manage Memory
Control Database Resources Using Resource Manager
Automate Management Tasks with the Scheduler
Secure the Oracle Listener
 

Requirements:
 
A working knowledge of Oracle SQL*Plus and Oracle Database Administration.   This can be obtained by attendance on the pre-requisite courses.   Knowledge of PL/SQL would be beneficial. 

Note:
 
Before taking any exam, ensure you have the recommended experience.