RE: Standby Database

</begin_plug>

I usually don't do these kind of posts... but I've seen a lot of activity on this topic lately. 

What is really the problem we are trying to solve here?  Maybe we are using the wrong tool.  

If you are looking for data protection in the event of a failure, or disaster... Or if you are trying to create a real time reporting instance. And you are using standby databases... there is a better solution.   

We provide a product called SharePlex for Oracle... it continually scans the online redo logs for any transactions on the tables that are critical to your environment.  It takes these transactions, and sends them to a target machine over TCP communication, and posts them via standard Oracle SQL.  The target system is completely open and available, while we are posting to it, for reporting and/or verifying that the data is there and available for use in case of a failure or disaster at the primary site. 

It can even be used in a peer to peer replication scheme as well. 

</end_plug>

</begin_shameless_plug>

for more information you can go to http://www.quest.com/shareplex/  
</end_shameless_plug> 

Sorry about the 'sales announcement'  but this list is for helping people, and trying to solve their problems... I see this as a solution.  

Nick Wagner
Technical PM
Quest Software

-----Original Message-----
From: Ed [mailto:mrclark_at_xnet.com]
Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Subject: Standby Database

Quick question.  Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch).  In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases).  Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake?

Am I making sense?

Thanks,

Ed

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed
  INET: mrclark_at_xnet.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).