Book Image

Oracle Database 11g : Underground Advice for Database Administrators

By : April Sims
Book Image

Oracle Database 11g : Underground Advice for Database Administrators

By: April Sims

Overview of this book

Today DBAs are expected to deploy and manage large databases with quality service and little to no downtime. The DBA's main focus is on increasing productivity and eliminating idle redundancy throughout the enterprise. However, there is no magic set of best practices or hard and fast rules that DBAs need to follow, and this can make life difficult. But if DBAs follow some basic approaches and best practices, tasks can be performed more efficiently and effectively.This survival guide offers previously unwritten underground advice for DBAs. The author provides extensive information to illuminate where you fit in, and runs through many of the tasks that you need to be watchful of, extensively covering solutions to the most common problems encountered by newcomers to the world of Oracle databases.The book will quickly introduce you to your job responsibilities, as well as the skills, and abilities needed to be successful as a DBA. It will show you how to overcome common problems and proactively prevent disasters by implementing distributed grid computing—scalable and robust—with the ability to redeploy or rearchitect when business needs change. Reduce downtime across your enterprise by standardizing hardware, software, tools, utilities, commands, and architectural components.This book will also help you in situations where you need to install Oracle Database 11g or migrate to new hardware making it compliant with a Maximum Availability Architecture. By the end of this book you will have learned a lot and gained confidence in your abilities. You will be armed with knowledge as to which tools are best used to accomplish tasks while proactively moving towards an automated environment.

Related Content you might be interested in

Current Title:

Small book image
Oracle Database 11g : Underground Advice for Database Administrators
April Sims
Apr, 2010 | 348 pages
No titles found
Table of Contents (14 chapters)
Oracle Database 11g—Underground Advice for Database Administrators
Oracle Database 11g—Underground Advice for Database Administrators
Credits
Credits
About the author
About the author
About the reviewers
About the reviewers
Preface
Preface
Free Chapter
1
When to Step Away from the Keyboard
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
2
Maintaining Oracle Standards
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
3
Tracking the Bits and Bytes
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
4
Achieving Maximum Uptime
Achieving Maximum Uptime
Maximum Availability Architecture (MAA)
Optimizing Oracle Database High Availability
Grid Control High Availability and Disaster Recovery
Summary
5
Data Guard and Flashback
Data Guard and Flashback
Physical, snapshot, and logical standbys
Summary
6
Extended RMAN
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
7
Migrating to 11g: A Step-Ordered Approach
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
8
11g Tuning Tools
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
Index

Index

A

B

  • background_dump_dest parameter /
  • backup
    • sets /
    • image copy /
    • incremental levels /
    • unused block compression /
    • incremental backups /
    • full backup /
    • logical backup /
    • incremental merge backup /
    • incremental merge backup, controlfile /
    • need for /
    • types /
    • default configuration details /
  • backup strategy, Oracle
    • features /
    • downsides /
    • restore and recovery comparison /
    • Traditional Backup Restore /
    • RMAN catalog, versus controlfile /
    • RMA stored scripts /
    • rentention policy /
  • BACKUP VALIDATE command
    • about /
  • BIGFILE
    • about /
  • binary components
    • removing, strings used /
  • Bind Peeking / Bind peeking and Adaptive Cursor Sharing

C

D

E

F

  • fault diagnosability infrastructure
    • about /
  • Flashback
    • using /
    • enabling, on physical standby /
    • web resources /
  • Flashback Logs
    • Flashback Table /
    • Flashback Transaction Query /
    • Flashback Transaction Backout /
  • Flashback Table
    • about /
  • Flashback Transaction Backout
    • about /
  • Flashback Transaction Query
    • about /
    • with Pseudo columns /
  • forecasting
  • FOREVER command
    • about /
  • FRA
    • about /
    • disk space, calculating /

G

  • 11g diagnosability framework
    • about /
    • checkers /
    • advisors /
    • missing temp files, recreating /
  • GC
    • about /
    • features /
    • recommended installation, for GC 10.2.0.5+ /
    • separate database, installing /
    • repositories, migrating /
    • TT migrations /
    • repository, keeping highly available /
    • repository imports /
    • repository resotres /
    • repository backups /
    • physical standby repository /
    • OMS /
    • intelligent agents, cloning /
    • recommendations, from MAA website /
  • GC 10.2.0.5
    • about /
    • management packs and enhancements /
  • GC 10.2.0.5+
    • recommended installation for /
  • GC High Availability (HA) console
    • features /
    • using /
  • GC repositories
    • migrating /
    • keeping, highly available /
    • imports /
    • restores /
    • backups /
    • post-repository import EM steps /
  • GC repositories database migration
    • about /
    • MOS documents /
  • Graphic-based tools / Choosing your tools
  • Grid control
    • repository database, migrating /
  • GUI-based command line-based Unix scripting, with SQL*PLUS / Choosing your tools
  • guidelines, scripting
    • configuration file, separating /
    • variable part, separating /
    • configuration file, referencing /
    • hidden password file, using /
    • variables, putting at top /
    • functions, moving to centralized file /
    • script, validating /
    • SQL, used for generating code /
    • Unix commands /

H

I

J

L

  • local_listener parameter /
  • log files
    • about /
  • logical corruption
    • about /
    • detecting /
    • DBVERIFY command /
    • BACKUP VALIDATE command /
    • RMAN VALIDATE command /
    • CTAS command /
    • export utility /
    • Data Pump /
    • utility, choosing /
  • logical standby database
    • about /
    • creating /
    • using /
    • limitations /
  • Log Miner
    • about /
    • archivelog mode, enabling /
    • supplemental logging, adding /
    • Identification key logging /
    • table-level supplemental logging /
    • using /
    • restoring data, determining /
    • timestamp, restoring /
    • SCN, restoring /
    • Log Sequence Number, restoring /
    • Pseudo column ORA_ROWSCN /
    • Flashback Logs, enabling /
    • binary components, removing /
  • lost write corruption, detecting
    • database state /
    • scenarious, testing /
    • failed primary scenario, reinstating /
    • logical standby, troubleshooting /
    • SQL Apply process errors, resolving /
    • single transaction, skipping /
  • lsnrctl
  • LTOM / Reactive diagnostic and tracing tools

M

  • MAA
    • policies, IT organization /
    • about /
  • major blunder list, DBA
    • about /
  • mass deployment utility
    • about /
  • Maximum Availability Architecture (MAA) / Protecting and defending
  • Merge Request
    • about /
  • migration
  • mixed environment
    • major issues /
  • MMA
    • about /
    • planned downtime /
    • with, commodity hardware /
  • MMA recommendations
    • Database /
    • Application Server /
    • Grid Control /
    • Applications /
  • MOS Service Request / Insisting on help
  • most recent controlfile backup, restore and recovery
    • finding /
    • controlfile, restoring /
    • database, restoring /
    • database, full recovery /
    • database, PITR /
    • verifying /
  • MSSM
    • about /
  • MTTR
    • about /
    • enabling /
    • goals, accomplishing /
  • multiple operating system accounts
    • implementing, with OFA standards /
  • multiple ORACLE_HOME(s)
    • about /
  • multiple standby sites
    • using /
  • My Oracle Support (MOS) / Insisting on help
  • My Oracle Support website
    • about /

N

O

P

R

S

T

U

V

W

Previous Section
End of Chapter
Next Chapter