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.
Learning Objectives
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 the recycle bin to recover data
- use Flashback Database
- use Flashback Data Archive
- use the recycle bin in Enterprise Manager