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.