Oracle Database 10g High Availability with RAC, Flashback & Data Guard / Edition 1

Oracle Database 10g High Availability with RAC, Flashback & Data Guard / Edition 1

by Matthew Hart, Scott Jesse

ISBN-10: 0072254289

ISBN-13: 9780072254280

Pub. Date: 04/21/2004

Publisher: McGraw-Hill Professional Publishing

Attain real solutions for current availability challenges. Based on a “DBA-centric” approach to High Availability, Oracle Database 10g High Availability concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and


Attain real solutions for current availability challenges. Based on a “DBA-centric” approach to High Availability, Oracle Database 10g High Availability concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions. Hardware and application needs are also taken into account. While Oracle Database 10g is the main focus, many of the options discussed are available in earlier database releases. Organized to provide conceptual understanding of High Availability, included are “HA Workshops,” step-by-step instructions to get you through certain implementations, plus real-world inspired case studies.

Product Details

McGraw-Hill Professional Publishing
Publication date:
Oracle Press Series
Product dimensions:
7.30(w) x 9.10(h) x 0.93(d)

Table of Contents

Part ILogical Availability
1Oracle and Availability: Illustrated Downtime Scenarios3
Horatio's Woodscrews4
User-Defined Availability7
Test and Development Availability7
Cyclical Database Resource Requirements8
What Reports Were Those, Exactly?9
Out of Space in the Woodscrew Tablespace10
Downtime for Hardware Fixes11
Restarting Long-Running Transactions12
Slow Crash Recovery12
Dealing with Block Corruption (ORA 1578)13
Waiting for the File to Restore from Tape14
RAC and the Single Point of Failure15
Rewinding the Database15
The Dropped Table16
The Truncated Table17
Connecting Online, Identical Databases18
Complete and Total Disaster18
Where to Go from Here19
2RDBMS Features for Availability21
Enterprise Manager22
Oracle Database Control23
Database Control Console: Navigation23
Oracle Enterprise Manager Grid Control27
Database Configuration on the Fly28
spfile or init.ora?29
Nondynamic Parameters30
Data Architecture and Availability34
Partitioned Tables and Indexes35
Index-Organized Tables42
Materialized Views43
Online Reorganization46
Resource Manager and Scheduler49
Managing Limited Resources49
Heir to the Job Throne: The Scheduler50
LogMiner: Transaction Extraction52
Transportable Tablespaces54
3Tuning Your Database for Availability61
Intelligent Infrastructure62
MMON Background Process62
AWR: Automatic Workload Repository63
What Is AWR?63
Viewing an AWR Report64
Interpreting the Workload Repository Report Output64
Creating Baselines for Comparing the Workload66
ADDM (Automatic Database Diagnostic Monitor)70
Viewing the ADDM Reports70
What Drives ADDM?73
Advisor Central76
SQL Tuning Advisor76
SQL Access Advisor77
Memory Advisor and ASMM78
Additional Advisors81
Automatic Storage Management (ASM)83
ASM Concepts83
Implementing ASM87
Managing ASM Environments with EM91
Part IIReal Application Clusters
4RAC Setup and Configuration99
Cluster-Ready Services (CRS)100
CRS Architecture101
Virtual IP Addresses, or VIPs102
CRS Installation102
Operating System Configuration for CRS103
Storage Requirements for CRS/RAC103
Networking Requirements for CRS and RAC105
Kernel Parameters105
OCR and Voting Disk Requirements106
Preparing for the CRS Install107
Network Configuration110
Shared Storage Configuration115
The Actual CRS Install Itself121
Coexistence of CRS and Local Only Installs121
Installing CRS122
What Just Happened?126
Installing the RDBMS127
ORACLE_HOME on Local or Shared?127
Installing the Product129
Database Creation130
5Database Administration in a RAC Environment137
RAC Essentials138
Instance Naming138
spfile in the RAC World138
RAC-Specific Parameters140
Additional Background Processes in a RAC Instance143
Cache Coherency in a RAC Environment146
Managing REDO and UNDO in a RAC Environment148
Redo Logs and Instance Recovery148
Redo Logs and Media Recovery149
UNDO in RAC157
Adding and Removing Cluster Nodes157
Adding a Cluster Node158
Removing a Cluster Node164
Additional RAC Considerations170
Managing ASM Environments170
Patching in a RAC Environment171
Enterprise Manager Grid Control and RAC171
6Utility Computing: Applications as Services177
Services Concepts178
Services as a Workload178
Services as Applications179
Services from the Database Perspective179
Creating Services181
Viewing Services from Within the Database185
Using SRVCTL to Manage Services189
Node Applications190
Managing Databases and Instances via SRVCTL191
Managing Services via SRVCTL195
Additional Notes on Services197
The Oracle Cluster Registry198
Information in the OCR198
Part IIIDisaster Planning
7Oracle Data Guard: Surviving the Disaster205
Making the Right Choice206
Physical Standby Databases206
Logical Standby Databases207
Creating a Physical Standby208
Creating a Logical Standby214
Is Logical Standby Right for Your Application?214
Log Transport Services220
Defining Log Transport Services Destinations221
Log Transport Services and Security225
Standby Redo Logs225
Protection Modes226
Maximum Protection226
Maximum Availability227
Maximum Performance228
How Data Guard Handles Network Disconnects229
Gap Detection and Resolution230
Methods of Gap Resolution230
Managing a Physical Standby232
Starting a Physical Standby232
Starting Managed Recovery232
Using the Standby in Read-Only Mode235
Accommodating Physical Changes Made on the Primary236
Managing a Logical Standby Database238
Stopping and Starting SQL Apply239
Monitoring SQL Apply Progress239
Protecting the Logical Standby from User Modifications240
Recovering from Errors241
Changing the Default Behavior of the SQL Apply Engine243
Additional DBMS_LOGSTDBY Procedures244
Performing a Role Transition Using Switchover247
Performing a Role Transition Using Failover252
Failover First Steps252
Using Flashback After a Failover254
Data Guard Broker and Clients256
The CLI Interface257
Using the Data Guard GUI259
8Backup and Recovery for High-Availability Environments275
The Importance of Media Backups276
RMAN: A Primer277
RMAN and the Controlfile278
RMAN and the Data Block280
RMAN Command-Line Usage281
RMAN from Enterprise Manager282
Preparing an RMAN Backup Strategy286
The Flashback Recovery Area286
Permanent Configuration Parameters289
Caring for Your Controlfile291
Backing Up the Available Database293
The High-Availability Backup Strategy293
Backing Up the Flashback Recovery Area299
Backup Housekeeping300
Performing Recovery303
Database Recovery: Restore and Recover303
Block Media Recovery306
Media Management Considerations306
The SBT Interface307
Backing Up Directly to Tape308
RMAN and Data Guard309
Using RMAN to Build the Standby Database309
RMAN and RAC316
RMAN Configuration for the Cluster316
Flashback Recovery Area for RAC321
Oracle and Split-Mirror Technologies322
The Split-Mirror Configuration322
RMAN Backups from the Split Mirror323
Use DG Instead326
9Oracle Flashback: Surviving User-Induced Trauma327
Prepared for the Inevitable: Flashback Technology328
Flashback Query329
Flashback and the Undo Segment: A Love Story329
Performing Flashback Query330
Flashback Versions Query with Enterprise Manager331
Flashback Transaction Query336
Flashback Table339
Performing the Flashback Table from SQL340
Flashback Table with Enterprise Manager340
Flashback Drop342
The Recycle Bin343
Flashback Database347
Flashback Logs348
Flashback Retention Target348
Flashback Database: Tuning and Tweaking350
Flashback Database: Opportunity for Different Uses352
Part IVDistributed Database Solutions
10Oracle Streams for High Availability357
Streams at a Glance358
Streams Capture Process360
Streams Propagation360
Streams Apply Process361
Rules, Rules, Rules361
Streams for High Availability362
Streams Replication and Replica DBs362
Setting Up Streams Replication363
Planning for Streams Replication363
Configuring Streams Replication365
Conflict Resolution372
Downstream Capture of LCRs385
Administration of Stream Processes388
Completely Removing a Streams Configuration from the Database389
Streams Summary389
11Oracle Net Configuration for Failover391
Connect-Time Failover392
Transparent Application Failover393
Client-Side Load Balancing394
Server-Side Load Balancing395
Net Configuration396
Using GUI Tools to Generate Configuration Files397
Easy Connect397
Environments Suitable for TAF398
Listener Configuration400
Why a Virtal IP?400

Customer Reviews

Average Review:

Write a Review

and post it to your social network


Most Helpful Customer Reviews

See all customer reviews >