|< Day Day Up >||
This book is
Real Application Clusters
Disaster Planning and Recovery
Distributed Database Solutions
General Availability refers to those features and techniques that
We begin in Chapter 1, 'Oracle and Availability: Illustrated Downtime Scenarios,' by going through a hypothetical series of downtime situations that happen to a fictional company that sells woodscrews. With each downtime scenario we offer a box that directs you to the technology that would assist the DBA for that particular problem. This is a way for us to show how the technologies discussed in Chapters 2-11 (the rest of the book) apply to very real uptime challenges. We also introduce the embarrassingly simple database tables that will be used throughout the book to
We embark on the journey into the world of dba-centric availability in Chapter 2, 'RDBMS Features for Availability.' Chapter 2 is dedicated to the Oracle options you can currently find hiding in the woodwork of your databases: dynamic parameter modifications, architectural availability options such as partitions and materialized views, logminer, and transportable tablespaces. We
Chapter 3, 'Tuning Your Database for Availability,' is a more
Part 2 is dedicated in its entirety to the setup, configuration, and administration of Real Application Clusters (RAC). The centerpiece of Oracle's availability offerings, RAC provides a clustering solution that found its footing in Oracle9
and now mushrooms into the
Chapter 4, 'RAC Setup and Configuration,' is the definitive guide to RAC Setup, starting with a beginner's guide to the basic architecture, as well as a hands-on lab for configuring a low-cost test cluster to allow you to get your hands dirty with minimal investment. It covers moving through the OS setup, including the setup of Oracle's Cluster File System, as well as raw files. The database configuration is coded step by step for quick RAC
Chapter 5, 'Database Administration in a RAC Environment,' delves deeper into the RAC stack, discussing the finer points of administration and upkeep unique to clustered databases. A closer look at RAC-specific redo and undo processing can be found here. This chapter talks to such availability requisites as rolling patch upgrades, dropping nodes, and adding nodes.
Chapter 6, 'Utility Computing: Applications as Services,' is dedicated to the implementation of services in a RAC environment-viewing applications as Services-a first step toward utility computing. The concepts of services are discussed along with the more important steps for configuration and rollout: services and work distribution.
Part 3 deals with those technologies provided to minimize downtime due to unforeseen problems. This can be complete site loss due to natural disaster or power outage, or a smaller
Chapter 7, 'Oracle Data Guard: Surviving the Disaster,' is an
Chapter 8, 'Backup and Recovery for High-Availability Environments,' takes us through the usage of Oracle's server managed recovery utility, RMAN, and how the usage of RMAN for media
Chapter 9, 'Oracle Flashback: Surviving User-Induced Trauma,' focuses entirely on the new suite of technologies that Oracle collectively refers to as 'Flashback Recovery.' This suite has been developed to provide minimal loss of time and data during those most dreaded of accidents: human error. Flashback Recovery comes in four
In the brief Part 4, we discuss the benefits of exploring a distributed database solution to provide availability. In certain environments it often proves most useful to forego single-site availability and instead use a software solution to push tables to multiple sites, so that everyone sees the same table locally. This act of distributing database operations across a
Chapter 10, 'Oracle Streams for High Availability,' discusses Oracle Streams, a queue-based solution that provides a way to stream updates at independent sites to each other. Here we provide an overview, focusing on the use of Streams to provide a High Availability solution, as well as for Replication of Replica Databases.
Chapter 11, 'Oracle Net Configuration for Failover,' is a brief discussion of Network Configuration at the Oracle listener for various availability solutions. This includes setting up the listener for Transparent Application Failover (TAF), RAC, Data Guard, and Streams.
|< Day Day Up >||