Though I think that Dataguard would be the most suitable solution in this case, only one point all you guys ignored, how the Dataguard could do a failover automatically by itself?
You probably need to write some code to monitor the status of the Dataguard, then do a failover when you need it, you also might wanna configure the clients to TAF mode.
Last edited by Calvin_Qiu; 11-26-2002 at 09:13 PM.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Reply With Quote