best way to have a standby database?

From: Wujo <Wujo_at_wujo.wujo>
Date: Mon, 04 Mar 2002 05:36:36 GMT
Message-ID: <EJDg8.34475$DS6.1183455@news2.telusplanet.net>

running wintel (W2000 workstation) Oracle 8.17, 5 clients, 500MB database, 1500 records being added per day.

Server is PIII-1Gig, 3 x 18GB SCSI (no RAID)

Looking to setup a "standby" server without getting into "clustering" or something expensive & complex.

What is the best way to do it?

The standby server does not have to go immediately online or have the very latest data (the newer the better though) if the main server fails.

Automated Import/Export Scripts (after every 200 records added or something)?
Failsafe?

Any suggestions? Received on Sun Mar 03 2002 - 23:36:36 CST