Availability Features in Oracle9i

Overview/Description
To explain how the new features of an Oracle9i database support the maximum availability of a database

Target Audience
Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database

Prerequisites
Experience in Oracle database administration; familiarity with RDBMS technologies

Expected Duration
320 Minutes

Objectives:

Availability Features in Oracle9i

  • use the new features in an Oracle9i database to prevent unplanned downtime and reduce planned downtime.
  • describe and implement new online features, such as index rebuilding, index-organized tables, and online table reorganization in an Oracle9i database.
  • explain how to use Flashback in an Oracle9i database.
  • use Flashback in an Oracle9i database.
  • describe the enhancements of the Oracle9i LogMiner and explain how to use it.
  • use the Oracle9i database LogMiner Viewer.
  • use the Oracle9i database LogMiner Viewer to view database redo logs.
  • describe the features of the Oracle9i database Data Guard and its components and explain how to use it.
  • describe the concepts and operations of the physical standby database in Oracle9i.
  • explain the concept of the Oracle9i database Log Transport Services and the benefits it provides.
  • outline and describe the manageability enhancements provided for standby databases in an Oracle9i database.
  • set the new persistent configuration parameters in the Oracle9i database RMAN.
  • explain the new manageability features related to the Oracle9i database RMAN.
  • explain the new reliability features of the Oracle9i database RMAN.
  • describe the Oracle9i database RMAN enhancements and outline its features, such as the new reporting capabilities and catalog maintenance.
  • use the Oracle9i database RMAN to perform backup and recovery functions.


    • Course Number: 58171_eng