Database 10g: DBA Level 2

Course Overview

This course introduces delegates to the main concepts of Oracle backup and recovery.

Audience

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.

Skills Gained

Delegates will learn to:

• Plan and implement a backup and recovery strategy using operating system backups
• Import and export utilities and Recovery Manager
• Monitor and improve database performance
• Control database resources using Resource Manager
• Automate tasks with the Scheduler
• Automatic Storage Management (ASM)

Examinations

This course relates to the following exam:

• Oracle exam #1Z1-043 Oracle Database 10g: Administration II.

Prerequisites

Delegates are required to meet the following prerequisites:

• SQL (OSP)
• Oracle Database 10g DBA - Part I (O10GDBAI)

Course Outline

• 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
• Load Data into a Database
• 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
• Use Globalization Support

Follow On Courses

Oracle 10g Application Server Administration (O10GAS)