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

Oracle Database 11g—Underground Advice for Database Administrators

Credits

About the author

About the reviewers

Preface

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

Summary

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

Summary

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

Summary

Achieving Maximum Uptime

Maximum Availability Architecture (MAA)

Optimizing Oracle Database High Availability

Grid Control High Availability and Disaster Recovery

Summary

Data Guard and Flashback

Physical, snapshot, and logical standbys

Summary

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

Summary

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

RMAN

Transportable Tablespaces (TTS)

Post-11g upgrade tasks

Summary

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

Summary

Index