Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Standby database v. advanced replication.

Standby database v. advanced replication.

From: <CHUCK_HAMILTON_at_qvc.com>
Date: Mon, 1 May 2000 11:50:41 -0400
Message-Id: <10484.104555@fatcity.com>


I have a requirement for a new 24x7 mission critical database. Occasional outages of < 5 minutes can be tolerated, but no longer. The fail-over options being considered are: (1) a standby database, and (2) advanced replication. OPS is not being considered because it does nothing to provide fast recovery from a media failure.

I'm leaning towards a standby database because I've had bad experiences in the past with Oracle snapshots. Unless I'm mistaken, that's the same technology that advanced replication is based on. Oracle would always lose track of the fact that a fast refresh could be done and try to do a full refresh. Some of the tables in this database will contain up to 20m rows and 8g of data. Way too much to attempt a full refresh.

Standby databases look like they're easier to implement and might be more reliable, but switching back I'm told is a problem.

Has anyone out there made a similar comparison? What would your recommendation be? If you have any experiences to relate I'd like to hear about them.

--
Chuck Hamilton
Oracle DBA
Received on Mon May 01 2000 - 10:50:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US