Thanks to everyone who responded. The oracle tools for this are indeed expensive and require "enterprise" versions of both databases as well as extra cost for DataGuard . Unless I was a bank then this would be unreasonable expense for the benifits.
The standard oracle tools allow an offline standby database or shipping and application of redo logs however I do not think that I can apply redo logs in semi-realtime (or without disrupting exisitng transactions or the slave instance). This is something I really need to test. It looks like DBD::Multiplex will do exactly what I want it to. I will need to look into error handling and maybe dropping connections from the "pool" if I experience errors with them. Perl to the rescue again :) Andy __________________________ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. The contents are confidential and may be privileged. Any views or opinions expressed are those of the sender and may not reflect the views or opinions of the company and the company accepts no liability in respect thereof. If you have received this email in error please notify [EMAIL PROTECTED] immediately. ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
