Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
120 minutes

Description
Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic Repository can also be used, which holds diagnostic information about critical error events. Flashback technology can be used when a logical corruption occurs in the Oracle database and you need to recover data quickly and easily. With the use of a Flashback Table, you can recover a set of tables to a specific point in time without having to perform traditional point-in-time recovery operations. This course explains how to use the Data Recovery Advisor and how to set up Automatic Diagnostic Repository, how to use the Support Workbench, run health checks, as well as detect and repair database corruption within the Oracle Database 11g environment. This course discusses how to use the Oracle Flashback technologies, including Flashback query, table and transaction, as well as Flashback Data Archive. It also discusses how to restore items from the Recycle Bin and how to flash back a database using Flashback Database.
This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.

Objective

Diagnosing the Oracle Database

  • use Data Recovery Advisor to detect, analyze, and repair database failures
  • handle block corruption in an Oracle Database
  • view diagnostic data
  • monitor the health of a database

Flashback Technologies

  • use Flashback Query
  • use Flashback Table
  • use Flashback Transaction
  • use Flashback Data Archive
  • use the recycle bin to recover data
  • use Flashback Database
  • use Flashback Data Archive
  • use the recycle bin in Enterprise Manager
  • use Flashback Database

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.