A standby database will still have to be shut down and cloned to another
database before you can use it. Standby means just that. The database must
"Stand By" until it is needed. You might want to consider a product from
Quest Software called SharePlex which will capture archive logs from one
database and apply them selectively to another one. From what I hear, you
can replicate just the tables that you need.
> -----Original Message-----
> From: CHUCK_HAMILTON_at_qvc.com [SMTP:CHUCK_HAMILTON_at_qvc.com]
> Sent: Monday, May 01, 2000 12:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Standby database v. advanced replication.
>
> 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
> QVC Inc.
>
> --
> Author:
> INET: CHUCK_HAMILTON_at_qvc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 01 2000 - 14:22:46 CDT
