Advanced Database Recovery and Repair in Oracle 10g

Overview/Description
To outline the processes for recovering non-critical files, performing incomplete recoveries, and repairing corrupted components of databases

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration
140 Minutes

Objectives:

Advanced Database Recovery and Repair in Oracle 10g

  • distinguish between the steps to recover non-critical files.
  • perform a suitable incomplete recovery in a given scenario.
  • perform an appropriate incomplete recovery and recoveries of non-critical files in a given scenario.
  • select the appropriate detection method for database corruption scenarios.
  • rank appropriate steps and their associated procedures for using DBMS_REPAIR.
  • use the BLOCKRECOVER command to restore data blocks.
  • implement an appropriate recovery strategy for database corruption.


    • Course Number: 212480_eng