PacktLib: Oracle Database 11g – Underground Advice for Database Administrators

Oracle Database 11g—Underground Advice for Database Administrators


About the author

About the reviewers


When to Step Away from the Keyboard

Protecting and defending

Choosing your tools

Staying away from dinosaurs

Insisting on help

What does a DBA do all day?

SLAs: Why isn't the database down anymore?

Avoiding major blunders


Maintaining Oracle Standards

Adapting to constant change

Oracle's Optimal Flexible Architecture (OFA)

Automating day-to-day tasks

11g Diagnosability Framework

Environmental variables and scripting

Reducing operating system differences with common tools

Configuration management, release management, and change control

Where, when, and who to call for help


Tracking the Bits and Bytes

Dump block

Oracle's RDBMS Log Miner utility

Flash(back) Recovery Area (FRA)

Automatic Undo Management (AUM)

When to use Log Miner


Achieving Maximum Uptime

Maximum Availability Architecture (MAA)

Optimizing Oracle Database High Availability

Grid Control High Availability and Disaster Recovery


Data Guard and Flashback

Physical, snapshot, and logical standbys


Extended RMAN

Recovery goals determine backup configuration

Backup types and the default configuration

Oracle's recommended backup strategy

Corruption detection

Data Recovery Adviser

What does RMAN backup, restore, and recover?

What doesn't RMAN backup, restore, and recover?

What do I do before starting a restore and recovery?

RMAN cloning and standbys—physical, snapshot, or logical


Migrating to 11g: A Step-Ordered Approach

Oracle net services

Client compatibility (SQL*Net, JDBC, ODBC)

RMAN binary, virtual/catalog, and database

Grid Control—database repository and agents

ASM, CFS, and RDBMS within an Oracle Grid infrastructure

Recommended order of migration

Installation of major versions, maintenance releases, and patches

Database upgrade methods


Transportable Tablespaces (TTS)

Post-11g upgrade tasks


11g Tuning Tools

Hardware load testing and forecasting

Monitoring hidden or underlying problems

Reactive diagnostic and tracing tools

Bind peeking and Adaptive Cursor Sharing

Gathering statistics

SQL Plan Management (SPM)

Upgrading the Optimizer