Oracle Database 11g DBA Handbook | Oracle Press

Oracle Database 11g DBA Handbook

Authors: Bob Bryla and Kevin Loney

Published: December 2007

eISBN: 9780071595797 0071595791 | ISBN: 9780071496636

Contents

Acknowledgments

Introduction

Part I: Database Architecture

1 Getting Started with the Oracle Architecture

An Overview of Databases and Instances

Oracle Logical Storage Structures

Oracle Logical Database Structures

Oracle Physical Storage Structures

Multiplexing Database Files

Oracle Memory Structures

Backup/Recovery Overview

Security Capabilities

Real Application Clusters

Oracle Streams

Oracle Enterprise Manager

Oracle Initialization Parameters

2 Upgrading to Oracle Database 11g

Choosing an Upgrade Method

Before Upgrading

Using the Database Upgrade Assistant

Performing a Manual Direct Upgrade

Using Export and Import

Using the Data-Copying Method

After Upgrading

3 Planning and Managing Tablespaces

Tablespace Architecture

Oracle Installation Tablespaces

Segment Segregation

4 Physical Database Layouts and Storage Management

Traditional Disk Space Storage

Automatic Storage Management

Part II: Database Management

5 Developing and Implementing Applications

Tuning by Design: Best Practices

Resource Management and Stored Outlines

Supporting Tables Based on Abstract Datatypes

Quiescing and Suspending the Database

Supporting Iterative Development

Managing Package Development

6 Monitoring Space Usage

Common Space Management Problems

Oracle Segments, Extents, and Blocks

Data Dictionary Views and Dynamic Performance Views

Space Management Methodologies

SYSAUX Monitoring and Usage

Archived Redo Log File Management

Built-in Space Management Tools

Space Management Scripts

Automating and Streamlining the Notification Process

7 Managing Transactions with Undo Tablespaces

Transaction Basics

Undo Basics

Managing Undo Tablespaces

Flashback Features

Migrating to Automatic Undo Management

8 Database Tuning

Tuning Application Design

Tuning SQL

Tuning Memory Usage

Tuning Data Access

Tuning Data Manipulation

Tuning Physical Storage

Reducing Network Traffic

Using the Automatic Workload Repository

Tuning Solutions

9 Database Security and Auditing

Non-Database Security

Database Authentication Methods

Database Authorization Methods

Auditing

Data Encryption Techniques

Part III: High Availability

10 Real Application Clusters

Overview of Real Application Clusters

Installation and Setup

RAC Characteristics

RAC Maintenance

11 Backup and Recovery Options

Capabilities

Logical Backups

Physical Backups

Using Data Pump Export and Import

Data Pump Import Options

Integration of Backup Procedures

12 Using Recovery Manager (RMAN)

RMAN Features and Components

Overview of RMAN Commands and Options

Backup Operations

Recovery Operations

Miscellaneous Operations

13 Oracle Data Guard

Data Guard Architecture

LOG_ARCHIVE_DEST_n Parameter Attributes

Creating the Standby Database Configuration

Using Real-Time Apply

Managing Gaps in Archive Log Sequences

Managing Roles—Switchovers and Failovers

Administering the Databases

14 Miscellaneous High Availability Features

Recovering Dropped Tables Using Flashback Drop

The Flashback Database Command

Using LogMiner

Online Object Reorganization

Part IV: Networked Oracle

15 Oracle Net

Overview of Oracle Net

Using the Oracle Net Configuration Assistant

Using the Oracle Net Manager

Starting the Listener Server Process

Controlling the Listener Server Process

Using Easy Connect Naming

Using Database Links

Tuning Oracle Net

16 Managing Large Databases

Creating Tablespaces in a VLDB Environment

Advanced Oracle Table Types

Using Bitmap Indexes

Oracle Data Pump

17 Managing Distributed Databases

Remote Queries

Remote Data Manipulation: Two-Phase Commit

Dynamic Data Replication

Managing Distributed Data

Managing Distributed Transactions

Monitoring Distributed Databases

Tuning Distributed Databases

Appendix: Installation and Configuration

Software Installation

Index