Disk array-based remote copy infrastructures have been available and in use for over a decade, though many users continue to seek the required details that describe how to properly configure the database, storage system, and software for remote replication. When properly configured and deployed, a remote copy infrastructure can provide a very timely recovery from a variety of failures -- up to and including the loss of an entire datacenter site.
This solution provides a comprehensive set of test-proven best practices to properly configure, deploy and operate an Oracle 10g database with ASM on an HP Enterprise Virtual Array using Continuous Access as the remote copy infrastructure. The test results describe the impact of both synchronous and asynchronous replication on the performance of the database. Also included is information describing the use of the new Enhanced Asynchronous replication feature available with the EVA array.
Included is detailed information that addresses the following deployment considerations:
- The optimal way to configure an Oracle 10g database on the EVA for replication
- How this required configuration differs from a standalone (non-replicated) configuration
- How the bandwidth and latency of the remote link influence replication behavior
- The impact of the distance between sites
- Planning considerations to properly size the remote link
- The impact to database performance for both synchronous and enhanced asynchronous replication
- The practical considerations for choosing which replication method to use
- Recommended best practices for the major elements of the deployment -- servers, storage, interconnect, and database
The methods and best practices provided are designed to facilitate both the productive planning and the timely deployment of a fully operational remote copy infrastructure to ensure:
- Predictable performance characteristics
- Ease of operation
- Accelerated time to deployment
- Reduced risk while minimizing total costs
|
Printable version
