+612 9045 4394


Oracle Press

Paperback Published: 10th May 2004
ISBN: 9780072254280
Number Of Pages: 448

Share This Book:


or 4 easy payments of $23.70 with Learn more
Ships in 7 to 10 business days

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 10"g" 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 10"g" 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.

Acknowledgmentsp. xiii
Introductionp. xvii
Logical Availability
Oracle and Availability: Illustrated Downtime Scenariosp. 3
Horatio's Woodscrewsp. 4
User-Defined Availabilityp. 7
Test and Development Availabilityp. 7
Cyclical Database Resource Requirementsp. 8
What Reports Were Those, Exactly?p. 9
Out of Space in the Woodscrew Tablespacep. 10
Downtime for Hardware Fixesp. 11
Restarting Long-Running Transactionsp. 12
Slow Crash Recoveryp. 12
Dealing with Block Corruption (ORA 1578)p. 13
Waiting for the File to Restore from Tapep. 14
RAC and the Single Point of Failurep. 15
Rewinding the Databasep. 15
The Dropped Tablep. 16
The Truncated Tablep. 17
Connecting Online, Identical Databasesp. 18
Complete and Total Disasterp. 18
Where to Go from Herep. 19
RDBMS Features for Availabilityp. 21
Enterprise Managerp. 22
Oracle Database Controlp. 23
Database Control Console: Navigationp. 23
Oracle Enterprise Manager Grid Controlp. 27
Database Configuration on the Flyp. 28
spfile or init.ora?p. 29
Nondynamic Parametersp. 30
Data Architecture and Availabilityp. 34
Partitioned Tables and Indexesp. 35
Index-Organized Tablesp. 42
Materialized Viewsp. 43
Online Reorganizationp. 46
Resource Manager and Schedulerp. 49
Managing Limited Resourcesp. 49
Heir to the Job Throne: The Schedulerp. 50
LogMiner: Transaction Extractionp. 52
Transportable Tablespacesp. 54
Tuning Your Database for Availabilityp. 61
Intelligent Infrastructurep. 62
MMON Background Processp. 62
AWR: Automatic Workload Repositoryp. 63
What Is AWR?p. 63
Viewing an AWR Reportp. 64
Interpreting the Workload Repository Report Outputp. 64
Creating Baselines for Comparing the Workloadp. 66
ADDM (Automatic Database Diagnostic Monitor)p. 70
Viewing the ADDM Reportsp. 70
What Drives ADDM?p. 73
Advisor Centralp. 76
SQL Tuning Advisorp. 76
SQL Access Advisorp. 77
Memory Advisor and ASMMp. 78
Additional Advisorsp. 81
Automatic Storage Management (ASM)p. 83
ASM Conceptsp. 83
Implementing ASMp. 87
Managing ASM Environments with EMp. 91
Real Application Clusters
RAC Setup and Configurationp. 99
Cluster-Ready Services (CRS)p. 100
CRS Architecturep. 101
Virtual IP Addresses, or VIPsp. 102
CRS Installationp. 102
Operating System Configuration for CRSp. 103
Storage Requirements for CRS/RACp. 103
Networking Requirements for CRS and RACp. 105
Kernel Parametersp. 105
OCR and Voting Disk Requirementsp. 106
Preparing for the CRS Installp. 107
Network Configurationp. 110
Shared Storage Configurationp. 115
The Actual CRS Install Itselfp. 121
Coexistence of CRS and Local Only Installsp. 121
Installing CRSp. 122
What Just Happened?p. 126
Installing the RDBMSp. 127
ORACLE_HOME on Local or Shared?p. 127
Installing the Productp. 129
Database Creationp. 130
Database Administration in a RAC Environmentp. 137
RAC Essentialsp. 138
Instance Namingp. 138
spfile in the RAC Worldp. 138
RAC-Specific Parametersp. 140
Additional Background Processes in a RAC Instancep. 143
Cache Coherency in a RAC Environmentp. 146
Managing REDO and UNDO in a RAC Environmentp. 148
Redo Logs and Instance Recoveryp. 148
Redo Logs and Media Recoveryp. 149
UNDO in RACp. 157
Adding and Removing Cluster Nodesp. 157
Adding a Cluster Nodep. 158
Removing a Cluster Nodep. 164
Additional RAC Considerationsp. 170
Managing ASM Environmentsp. 170
Patching in a RAC Environmentp. 171
Enterprise Manager Grid Control and RACp. 171
Utility Computing: Applications as Servicesp. 177
Services Conceptsp. 178
Services as a Workloadp. 178
Services as Applicationsp. 179
Services from the Database Perspectivep. 179
Creating Servicesp. 181
Viewing Services from Within the Databasep. 185
Using SRVCTL to Manage Servicesp. 189
Node Applicationsp. 190
Managing Databases and Instances via SRVCTLp. 191
Managing Services via SRVCTLp. 195
Additional Notes on Servicesp. 197
The Oracle Cluster Registryp. 198
Information in the OCRp. 198
Disaster Planning
Oracle Data Guard: Surviving the Disasterp. 205
Making the Right Choicep. 206
Physical Standby Databasesp. 206
Logical Standby Databasesp. 207
Creating a Physical Standbyp. 208
Creating a Logical Standbyp. 214
Is Logical Standby Right for Your Application?p. 214
Log Transport Servicesp. 220
Defining Log Transport Services Destinationsp. 221
Log Transport Services and Securityp. 225
Standby Redo Logsp. 225
Protection Modesp. 226
Maximum Protectionp. 226
Maximum Availabilityp. 227
Maximum Performancep. 228
How Data Guard Handles Network Disconnectsp. 229
Gap Detection and Resolutionp. 230
Methods of Gap Resolutionp. 230
Managing a Physical Standbyp. 232
Starting a Physical Standbyp. 232
Starting Managed Recoveryp. 232
Using the Standby in Read-Only Modep. 235
Accommodating Physical Changes Made on the Primaryp. 236
Managing a Logical Standby Databasep. 238
Stopping and Starting SQL Applyp. 239
Monitoring SQL Apply Progressp. 239
Protecting the Logical Standby from User Modificationsp. 240
Recovering from Errorsp. 241
Changing the Default Behavior of the SQL Apply Enginep. 243
Additional DBMS_LOGSTDBY Proceduresp. 244
Performing a Role Transition Using Switchoverp. 247
Performing a Role Transition Using Failoverp. 252
Failover First Stepsp. 252
Using Flashback After a Failoverp. 254
Data Guard Broker and Clientsp. 256
The CLI Interfacep. 257
Using the Data Guard GUIp. 259
Backup and Recovery for High-Availability Environmentsp. 275
The Importance of Media Backupsp. 276
RMAN: A Primerp. 277
RMAN and the Controlfilep. 278
RMAN and the Data Blockp. 280
RMAN Command-Line Usagep. 281
RMAN from Enterprise Managerp. 282
Preparing an RMAN Backup Strategyp. 286
The Flashback Recovery Areap. 286
Permanent Configuration Parametersp. 289
Caring for Your Controlfilep. 291
Backing Up the Available Databasep. 293
The High-Availability Backup Strategyp. 293
Backing Up the Flashback Recovery Areap. 299
Backup Housekeepingp. 300
Performing Recoveryp. 303
Database Recovery: Restore and Recoverp. 303
Block Media Recoveryp. 306
Media Management Considerationsp. 306
The SBT Interfacep. 307
Backing Up Directly to Tapep. 308
RMAN and Data Guardp. 309
Using RMAN to Build the Standby Databasep. 309
RMAN and RACp. 316
RMAN Configuration for the Clusterp. 316
Flashback Recovery Area for RACp. 321
Oracle and Split-Mirror Technologiesp. 322
The Split-Mirror Configurationp. 322
RMAN Backups from the Split Mirrorp. 323
Use DG Insteadp. 326
Oracle Flashback: Surviving User-Induced Traumap. 327
Prepared for the Inevitable: Flashback Technologyp. 328
Flashback Queryp. 329
Flashback and the Undo Segment: A Love Storyp. 329
Performing Flashback Queryp. 330
Flashback Versions Query with Enterprise Managerp. 331
Flashback Transaction Queryp. 336
Flashback Tablep. 339
Performing the Flashback Table from SQLp. 340
Flashback Table with Enterprise Managerp. 340
Flashback Dropp. 342
The Recycle Binp. 343
Flashback Databasep. 347
Flashback Logsp. 348
Flashback Retention Targetp. 348
Flashback Database: Tuning and Tweakingp. 350
Flashback Database: Opportunity for Different Usesp. 352
Distributed Database Solutions
Oracle Streams for High Availabilityp. 357
Streams at a Glancep. 358
Streams Capture Processp. 360
Streams Propagationp. 360
Streams Apply Processp. 361
Rules, Rules, Rulesp. 361
Streams for High Availabilityp. 362
Streams Replication and Replica DBsp. 362
Setting Up Streams Replicationp. 363
Planning for Streams Replicationp. 363
Configuring Streams Replicationp. 365
Conflict Resolutionp. 372
Downstream Capture of LCRsp. 385
Administration of Stream Processesp. 388
Completely Removing a Streams Configuration from the Databasep. 389
Streams Summaryp. 389
Oracle Net Configuration for Failoverp. 391
Definitionsp. 392
Connect-Time Failoverp. 392
Transparent Application Failoverp. 393
Client-Side Load Balancingp. 394
Server-Side Load Balancingp. 395
Net Configurationp. 396
Using GUI Tools to Generate Configuration Filesp. 397
Easy Connectp. 397
Environments Suitable for TAFp. 398
Listener Configurationp. 400
Why a Virtal IP?p. 400
Bibliographyp. 403
Indexp. 415
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072254280
ISBN-10: 0072254289
Series: Oracle Press
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 448
Published: 10th May 2004
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.4 x 18.9  x 2.5
Weight (kg): 0.75
Edition Number: 1

This product is categorised by