oops. I missed the 5-10 minute lag max SLA of the first bit of the thread. Carel-Jan's solutions are logically equivalent to as good as you can get in that space, I believe. In the mid-market competition it sure seems like Oracle is stacking the deck against themselves on this issue after they really did some excellent work figuring out the price points and buying strategies for off the shelf deals to beat ConvictedMonopolistSoft. My understanding was they were trying to manage downward the cost of sales and maximize the ease of purchase, so trying to manage negotiations for folks in this space that want site disaster business continuation is probably not a scalable or profitable option. I wonder whether the putative consequent reduction in sales costs Oracle more money than would giving away DataGuard or the like for classes of machines for which the SE offerings are valid. Then again, I've not done a market size study in that space: Small total horsepower required, but needs business continuation/reporting. At least I'm getting good at snip and cut-and-paste address.... Regards, mwf -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Carel-Jan Engel Sent: Monday, September 27, 2004 3:14 PM To: identd@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: options for read only mirror with 10g SE or SE One <snip> Standby in all appearances (except Logical Standby, but that is EE) tends to be in recovery mode. So, there is quite few read-only access possible to the second database, which happened to be the original question. I don't think that opening and closing the database in read-only/recovery mode every five minutes will come close to the SLA that running the reports needs. <snip> -- //www.freelists.org/webpage/oracle-l