WA1381 Oracle Database 10g: Administration II
Description :
One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This course presents all the standard failure scenarios and the best recovery strategies for each. Backup strategies for cold backups, on-line backups, complete and partial backups are discussed. Extensive exercises allow students to simulate failures and perform actual recovery within the workshop.
Course Prerequisites

Mandatory prerequisites for this course are the following courses:

• The course Oracle Database 10g: Introduction to SQL
• The course Oracle Database 10g: Program With PL/SQL
• The course Oracle Database 10g: Administration I

Course Objectives:
The objective of this course is to equip database administrators with the skills necessary to backup a production Oracle database and to recover as much information as possible in the event of a major failure. Significant subjects to be considered are:

• Consider the various archive modes that the database may operate in and the effect on recovery capabilities of each mode.
• Consider advanced database configuration options that assist recovery of lost data.
• Build a backup and recovery strategy with user-managed techniques.
• Build a backup and recovery strategy with server-managed techniques and the RMAN tool.
• Configure standby databases as part of disaster recovery using Oracle Data Guard.
• Learn about advanced techniques that not only recover lost data but endeavor to do so efficiently and rapidly, allowing a quick return to normal operations.

Duration:
Five days.
More Information
Schedule this course
Course Outline
Download this page as a word document