Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard

Contents......Page 18
Acknowledgments......Page 28
Introduction......Page 32
Part I: Oracle’s Grid Infrastructure......Page 42
1 Architecting the Oracle Database Grid......Page 44
LunarTrax: To the Moon and Beyond!......Page 45
Planning the Grid......Page 46
The Grid and Planned Maintenance......Page 47
Recovering Quickly from Failures......Page 49
Protecting Against and Recovering from User Errors......Page 51
Planning for Expansion and Future Growth......Page 52
Disaster Recovery......Page 54
What Next?......Page 55
Go Forth and Conquer......Page 58
2 Oracle VM......Page 60
Oracle VM......Page 61
Using Oracle VM Manager......Page 70
Using Oracle VM Server......Page 80
Multiple VM Servers Using iSCSI for Shared Discs......Page 83
Using Prebuilt Oracle RAC Templates......Page 85
Summary......Page 86
3 Grid Infrastructure......Page 88
Cluster Ready Services......Page 89
CRS Concepts......Page 90
CRS Architecture......Page 107
Clusterware Trace Files......Page 115
Summary......Page 117
4 Grid Infrastructure Installation and Configuration......Page 118
GI Installation Choices and Requirements......Page 119
Cluster Verification Utility......Page 125
Grid Infrastructure Install......Page 138
Adding and Removing Nodes from a Cluster......Page 157
Upgrading to GI......Page 160
What’s New for 11.2.0.2......Page 163
Summary......Page 165
5 Oracle Automatic Storage Management......Page 166
ASM Concepts......Page 167
ASM Cluster File System......Page 189
Summary......Page 210
Part II: Oracle Real Application Clusters (Oracle RAC)......Page 212
6 Oracle RAC Setup/Configuration......Page 214
Oracle RAC/RDBMS Install Options......Page 215
cluvfy......Page 217
Installing Oracle RAC......Page 221
Enabling Archiving......Page 231
Extending Oracle RAC Databases to New Nodes......Page 232
Deleting an Instance from the Oracle RAC Database......Page 234
Installing Earlier RDBMS Releases......Page 235
Oracle RAC on Extended Distance Clusters......Page 239
Summary......Page 243
7 Oracle RAC Administration......Page 244
Oracle RAC vs. Single-Instance: Additional Processes......Page 245
Oracle RAC vs. Single-Instance: The Basics......Page 247
Redo and Rollback with Oracle RAC......Page 250
Parallelism in an Oracle RAC Environment......Page 252
Monitoring the Environment......Page 254
Tuning with AWR and ADDM......Page 259
Archiving and Backing Up......Page 267
Patches and Patchsets......Page 270
Managing the Oracle RAC Database with SRVCTL......Page 274
Management Through Policies......Page 278
Managing Diagnostic Data......Page 280
Summary......Page 282
8 Utility Computing: Applications as Services......Page 284
Services Concepts......Page 285
Distributing Work Among Oracle RAC Nodes for Performance......Page 289
Event Notification......Page 290
Creating Services and Callouts......Page 294
Using SRVCTL to Manage Services and Node Applications......Page 300
Cluster Listener Configuration......Page 305
Transparent Application Failover......Page 311
Summary......Page 321
Part III: Disaster Planning......Page 322
9 Oracle Data Guard......Page 324
Making the Right Choice......Page 325
Creating a Physical Standby......Page 329
Creating a Snapshot Standby......Page 339
Creating a Logical Standby......Page 341
Log Transport Services......Page 346
Standby Redo Logs......Page 350
Protection Modes......Page 351
Handling Network Disconnects......Page 354
Gap Detection and Resolution......Page 355
Managing a Physical Standby Database......Page 357
Managing a Logical Standby Database......Page 367
Performing a Role Transition Using Switchover......Page 373
Performing a Role Transition Using Failover......Page 376
Summary......Page 381
10 Backup and Recovery for MAA Environments......Page 382
The Importance of Media Backups......Page 383
RMAN: A Primer......Page 385
Preparing an RMAN Backup Strategy......Page 389
Backups for the MAA Database......Page 399
Performing Recovery......Page 412
Media Management Considerations......Page 423
RMAN and Oracle Data Guard......Page 426
RMAN and Oracle RAC......Page 432
Summary......Page 437
11 Flashback Recovery......Page 438
Being Prepared for the Inevitable: Flashback Technology......Page 439
Laying the Groundwork......Page 440
Flashback Query and Flashback Table......Page 441
Flashback Drop......Page 447
Flashback Transaction......Page 449
Flashback Database......Page 454
Summary......Page 461
Part IV: Enhancing Availability with Additional Features......Page 462
12 Oracle Data Guard Broker......Page 464
Oracle Data Guard Broker Architecture Overview......Page 465
Oracle Data Guard Broker Configuration......Page 466
Monitoring an Oracle Data Guard Broker Configuration......Page 468
Modifying a Broker-Managed Oracle Data Guard Configuration......Page 470
Role Transitions with Oracle Data Guard Broker......Page 472
Increasing Database Availability with Fast-Start Failover......Page 477
Enhancing Application Availability with Fast Application Notification and Role-Based Services......Page 481
Summary......Page 483
13 Oracle Grid Control......Page 484
What Is Oracle Grid Control?......Page 485
Grid Control Architecture......Page 487
Preparing to Install Oracle Grid Control 11g Release 1......Page 488
Oracle Management Agents......Page 512
Administration of Grid Control......Page 514
Monitoring......Page 519
Notifications......Page 521
MAA Environment Administration Using Grid Control......Page 523
Summary......Page 530
A......Page 532
B......Page 534
C......Page 535
D......Page 536
E......Page 538
F......Page 539
G......Page 540
I......Page 541
L......Page 542
M......Page 543
O......Page 545
P......Page 549
R......Page 551
S......Page 553
T......Page 555
W......Page 556