Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!newsfeed.telusplanet.net!news2.telusplanet.net.POSTED!53ab2750!not-for-mail From: "Wujo" Newsgroups: comp.databases.oracle.server Subject: best way to have a standby database? Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Mon, 04 Mar 2002 05:36:36 GMT NNTP-Posting-Host: 142.179.72.24 X-Trace: news2.telusplanet.net 1015220196 142.179.72.24 (Sun, 03 Mar 2002 22:36:36 MST) NNTP-Posting-Date: Sun, 03 Mar 2002 22:36:36 MST Xref: easynews comp.databases.oracle.server:137343 X-Received-Date: Sun, 03 Mar 2002 23:15:53 MST (news.easynews.com) 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?