This paper provides a comprehensive set of test-proven best practices for properly configuring, deploying, and operating an Oracle 10g database on an HP StorageWorks XP12000 Disk Array (XP12000) in an HP-UX environment using HP StorageWorks XP Continuous Access Software as the remote copy infrastructure.
RemotereplicationbestpracticesforOracle10g usingXP ContinuousAccess
Overview ................................ 3
Solutioncon?guration........................... 4
Storageinfrastructure ......................... 4
Servers ............................... 5
Databaseservers......................... 5
HPOpenViewOperationsserver .................. 5
XPCommandViewAdvancedEditionserver ............. 5
BenchmarkFactoryandHPSystemInsightManagerservers....... 5
Software .............................. 5
HPStorageWorksXPContinuousAccessSoftwarereplicationoverview.... 5
Storagecon?guration......................... 6
XP12000con?guration ...................... 6
XP10000con?guration ...................... 6
Databasecon?guration ........................ 7
Primarysite ........................... 7
Secondarysite.......................... 7
SANinfrastructure .......................... 7
Backupandrecovery ......................... 7
Testing ................................. 9
Overallobjectives........................... 9
High-leveloverviewoftestcases .................... 9
Metrics ............................... 9
Baselinetesting............................ 10
XPContinuousAccessSynchronoustesting ................ 12
SynchronousI/OversusasynchronousI/OforHP-UXtesting ........ 14
XPContinuousAccessAsynchronoustesting................ 16
XPContinuousAccessJournaltesting .................. 19
Redologsizeversusside?lecachesizetesting .............. 21
Bestpracticesandresults ......................... 24
Oracledatabaseadministrators..................... 24
HP-UXsystemadministrators ...................... 24
XPstorageadministrators ....................... 24
Conclusion ............................... 25
Keyplanningconsiderations ...................... 25
Keyguidelinesforselectingreplicationmethods.............. 25
Keyoperationalconsiderations..................... 25
Summary .............................. 26
AppendixABillofmaterials ........................ 27
AppendixBXPBusinessCopybackupandrecoverycommands......... 29
Formoreinformation ........................... 30
HPtechnicalreferences ........................ 30
Technicalpapersanduserguides.................. 30
CustomerFocusedTestingsolutions ................. 30
HPstorage ........................... 30
Oracle ............................... 30
Cisco................................ 30
Overview
Although disk-array-based remote copy infrastructures have been in use for over a decade, most users lack the information required to properly con?gure the database, storage system, and software for remote replication. When properly con?gured and deployed, these infrastructures are capable of providing timely recovery from a variety of failures, up to and including the loss of an entire datacenter site. Based on a combination of well-understood technical issues, information from recent customer brie?ngs, and a commissioned study with International Data Corporation (IDC), the key requirement for effective deployment is that remote copying of databases must be done in concert with the native relational database management system (RDBMS) technology in order for the solution to be practical.
This paper provides a comprehensive set of test-proven best practices for properly con?guring, deploying, and operating an Oracle 10g database on an HP StorageWorks XP12000 Disk Array (XP12000) in an HP-UX environment using HP StorageWorks XP Continuous Access Software as the remote copy infrastructure. Speci?cally, the fundamental deployment issues that this paper addresses are as follows:
.Thebe stw ayto co n?gure an Oracle 10g database and the XP12000 for replication
. The impact on database performance and throughput for each method of replication (synchronous, asynchronous, and asynchronous journal)
. The impact of the latency in the remote link on replication behavior, and how it in?uences the choice of replication method
. General considerations for choosing which replication method to use
. Recommended best practices for the major elements of the deployment (servers, storage device, and dat... [download for more]
