poor man's standby

Hello,

Is there a way to make something similar to DataGuard ( Standby ) work on two installations of Oracle Standard ?

What I need is one database being the "main" server and the second one as up-to-date as possible ( through applying archived redos for example ) and recoverable and able to function as the main database in minutes.

The closest thing I've gotten to work this far is:

( Linux RedHat AS 2.1 , Oracle Standard v. 9.2.0.1 )

Database D1 operates on machine M1. The logs and control files are multiplexed over nfs mount to M2. D2 is a copy of D1. D1 is stopped. D2 'startup mount' -ed and 'recover'-ed ( with all the ctl-s and logs in their proper places ).

This works fine, but what I'd need to do is to incrementally apply the new archived redo logs (as they are generated by D1) to the previously already recovered database to minimize the recovery time when D2 would actually be needed as the main DB.

I'd really appreciate your advice on this one.

thank you,

K.L. Received on Mon Jun 09 2003 - 07:35:51 CDT