Oracle9i New Features: Backup, Recovery, and Performance Tuning

Audience

The audience for this course would be Data Administrators. Required Prerequisites include SQL PL/SQL DBA I II.

Objective

• Identify the new features designed to reduce unplanned downtime improve data protection and provide faster disaster recovery.
• Use LogMiner enhancements.
• Describe the new features used in online operations.
• Identify backup and recovery strategy improvements.
• Recognize Recovery Manager improvements.
• Identify schema and system improvements.
• Describe scalable session state management improvements.

Topics Include

Unit 1: Backup and Recovery Enhancements

• Identify the two major time elements in the new two-pass instance and crash recovery processes.
• Identify the features of Fast-Start Time-Based Recovery.
• Match the functionalities of Oracle Flashback and Failsafe.
• Identify the advantages of Fast Failover in improving data protection and disaster recovery.
• Identify the components which the Data Guard automates using the graphical-user interface.
• Identify the features of the Data Guard Architecture that improve data protection.
• Identify the characteristics of a Physical Standby Database.
• Identify the different log transport modes.
• Match the new parameter options used in LOG_ARCHIVE_DEST_N to their description.
• Match a data protection technology to its feature.
• Identify the new features of the LogMiner.
• Identify the new options of the DBMS_LOGMNR package.
• Identify the considerations applied when implementing the SKIP_CORRUPTION procedure.
• Identify the features of the LogMiner viewer.
• Identify the indexes that support online index rebuild.
• Identify the new functionalities of index-organized tables.
• Sequence the steps in performing an online redefinition of a table.
• Identify the considerations applied when the database is in a quiesced state.
• Identify the RMAN manageability features.
• Match persistent configuration parameter used in RMAN to its functionality.
• Match the backup and restore type to its option.
• Identify the considerations applied when implementing archive log failover and the backup piece failover.
• Identify the benefits of BMR.
• Identity the features of the trial recovery capability of Recovery Manager.

Unit 2: Performance and Tuning Enhancements

• Identify the benefits of IOTs.
• Identify the characteristics of the skip scan algorithm.
• Identify the benefits of the GET_DDL function in the DBMS_METADATA package.
• Identify the benefits of the SIMILAR parameter option used in cursor sharing.
• Match the performance topics to their focus areas.
• Identify the four new features of the Oracle Shared Server.
• Identify the considerations applied in using the external procedure agent.
• Identify the three kinds of threads used in a multi-threaded agent HS architecture.
• Identify the features of OCI Connection Pooling.
• Sequence the steps in using connection pooling in your application.
• Identify the characteristics of the Virtual Interface Protocol Adapter.

Duration

6

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM
Web Based Training