Exam # 1Z0-032: Oracle9i DBA Fundamentals II

Oracle9i: DBA Fundamentals II (Exam #1Z0-032) is a core requirement for both the Oracle 9i OCA (Oracle Certified Associate) and OCP (Oracle Certified Professional) certifications. It is designed for intermediate to advanced level database personnel. In addition, we cover the following topics:

Chapter 1: Networking Overview

Explain Solutions Included with Oracle9i for Managing Complex Networks

Describe Oracle Networking Add-on Solutions

The Key Components of the Oracle Net Layered Architecture

Oracle Net Services Role in Client Server Connections

Chapter 2: Overview of Backup and Recovery

Factors Impacting Backup and Recovery

Understanding why Systems Fail

Types of Oracle Failures

Scenario Testing

Understanding your Hardware

Backing up Different Environments

Factors Impacting Strategies

Oracle Backup Options

Types of Oracle Recovery

Database Files

Views used in Backup and Recovery

Chapter 3: Managing Instance Recovery

The LRU and Dirty Lists

Server Processes and the Buffer Cache

DBWR and the Buffer Cache

Checkpoint Events

LOG CHECKPOINT Parameters

MTTR and Checkpoint intervals

Oracle8i Methods for Controlling Check

Chapter 4: Oracle9i

V$INSTANCE_RECOVERY View

Minimal I/O Recovery

Setting different levels of Checkpointing

Checkpoint and File Queues

Checkpoint Queue

Instance Recovery

Rolling Forward and Backward

FAST_START_PARALLEL_ROLLBACK

Controlling DBWR Activity

Multiple DBWR IO Processes

DB_BLOCK_CHECKING

Dynamic Views for Parallel Recovery

Chapter 5: Fundamentals of Oracle Backups

Good Design Fundamentals and Guidelines

What Needs to Be Backed Up?

Different Types of Backups

Logical and Physical Backups

Operating System Backups

Cold Backups

Hot Backups

Logical Backups

Automating Backup and Recovery Tasks

Basic Unix commands

Chapter 6: Recovery

Recovery from Media Failure

Restore a Database to a New Location

Datafile Loss in NOARCHIVELOG Mode

Advantages and Disadvantages of

Chapter 7: Diagnostics and Troubleshooting

Detecting Software Corrupt Blocks

DBVERIFY Parameters

DBVERIFY Output

The DBMS_REPAIR Package

DBMS_REPAIR Restrictions

DBMS_REPAIR Constants

DBMS_REPAIR Exceptions

DBMS_REPAIR.ADMIN_TABLES

Chapter 8: Procedure

The Log Miner Utility

LogMiner Packages

V$LOGMNR_CONTENTS

Creating a LogMiner Data Dictionary File

Using LogMiner to Analyze Log Files

Analyzing the Log Files with

START_LOGMNR and END_LOGMNR

ANALYZE VALIDATE STRUCTURE

Chapter 9: Recovery Manager Overview

Issues with Managing Backups

What is Recovery Manager?

RMAN Interfaces

Working with Recovery Manager

RMAN Compatibility

Using Recovery Manager

Using RMAN with Multiple Platforms

Advantages of RMAN

Disadvantages of RMAN

Oracle9i RMAN Enhancements

Improved Error Output

Recovery Manager Terminology

Chapter 10: Catalog

Contents of the Recovery Catalog

Catalog Considerations

Advantages of the Recovery Catalog

Disadvantages of the Recovery Catalog

Creating a Catalog Database 0

Connecting to a Catalog Database

Connecting without a Recovery Catalog

Connect to a Target Database with a Recovery

Chapter 11: Managing Recovery Manager

Types of RMAN Commands

Standalone and Job Commands

Executing Recovery Manager Commands

Customizable Configuration Parameters

CONFIGURE - SHOW ALL

Channel Allocation

Server Parameter and Control File Autobackup

SPFILE Option

Cleaning Up Backups or Copies

Force Option of DELETE Command

Performing Trial Recovery

REPORT Need Backup and Obsolete

Chapter 12: Commands

The LIST Command

Additional LIST Options

Recovery Manager Data Dictionary Views:

Reserved words

Oracle9i Recommended Syntax

Chapter 13: Backup and Restore Workshop

Types of RMAN Backups

Automatic Tags for Backups

RMAN Backup Integrity Check

Perform a Full Database Consistent Backup

Crosschecking the Backup

Chapter 14: Server Side Configuration

Oracle Network Terminology

The Role of the Listener

LISTENER.ORA File Format

The TNSNAMES.ORA File

The Automatic Service Registration Feature

Methods for Configuring the LISTENER.ORA

Chapter 15: Client Side Configuration

Client Configuration Files

Configuration Files: TNSNAMES.ORA

Configuration Files: SQLNET.ORA

Installing Net Services on the Client

Troubleshooting

Would you like to learn Oracle9i DBA Fundamentals II? We provide home tutoring service.

Please contact us for any additional information.

---