Oracle9i Database Backup & Recovery (DBA II)

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 5-day 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.

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

Target audience

This course has been developed for all IT professionals including developers, database administrators and web administrators. Also non-technical professionals including project managers, business analysts and executives will benefit. Students should have attended the following courses or have equivalent knowledge and experience:

• Introduction To Oracle9i SQL
• Introduction To Oracle9i PL/SQL Language
• Introduction To Oracle9i Advanced SQL
• Oracle9i Database Administration (DBA I)

Course content

Database recovery structures The mechanisms for recovery • SQL statement execution • Examining the recovery components

Identifying the data structures Data structures within the database • Identifying the tablespaces • Identifying the control files • Identifying the alert and trace files • Identifying the redo log files

Archiving Development of backup and recovery strategies • Managing the archive options

User-managed physical backups Backup characteristics • Performing a full backup • Performing an offline tablespace backup • Performing an online tablespace backup • Performing suspend mode backups • Performing a control mode backup

An overview to database recovery The recovery • Identifying the type of failure

Instance recovery and fast-start

User-managed complete media recovery Media failure concepts • Complete closed recovery • Complete open recovery • Handling special situations

User-managed incomplete media recovery About incomplete recovery • Point in-time based recovery

Handling and anticipating stuck recoveries About stuck recoveries • Handling corruption of data • Performing trial recovery

User-managed recovery troubleshooting Move data file location • Recovery with no data file backup • Handling read only tablespaces • Handling the loss of control files

Using the recovery manager (RMAN) Using the recovery catalog • Confirming registration and other operations • Using run blocks and scripts • Allocating channels • Accessing RMAN via OEM

Server-managed backups with RMAN Performing full backups • Performing incremental backups

Exploring enhanced RMAN capabilities Resume failed backup operations • Establishing a backup retention policy • Show all configuration settings • Generate catalog reports • Report schema • List incarnation

Server-managed recovery with RMAN Recovery manager recovery • Performing restoration and file media recovery • Performing block media recovery

Standby databases with Oracle Data Guard About the Data Guard architecture • Data Guard interfaces

Data Guard configuration and operation
Configuring log transport • Configuring log apply • Database switchover operations • Database failure operation • Monitoring the standby database

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today