Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!intgwpad.nntp.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail
Message-ID: <3D524644.A69E1E8F@oracle.com>
From: Richard Foote <Richard.Foote@oracle.com>
Organization: Oracle Corporation
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server,comp.databases.oracle,comp.databases.oracle.misc
Subject: Re: Oracle Replication question
References: <3d523de1$1@news.starhub.net.sg>
Content-Type: multipart/mixed;
 boundary="------------C14DBAED7F5F767773B2190F"
Lines: 67
Date: Thu, 08 Aug 2002 20:21:56 +1000
NNTP-Posting-Host: 144.138.159.96
X-Trace: newsfeeds.bigpond.com 1028802014 144.138.159.96 (Thu, 08 Aug 2002 20:20:14 EST)
NNTP-Posting-Date: Thu, 08 Aug 2002 20:20:14 EST
Xref: easynews comp.databases.oracle.server:157250 comp.databases.oracle:16837 comp.databases.oracle.misc:85313
X-Received-Date: Thu, 08 Aug 2002 03:24:46 MST (news.easynews.com)
--------------C14DBAED7F5F767773B2190F
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi Tohsh,

My recommendation would be not to re-invent the wheel and look at
Oracle's Standby Database (Data Guard in 9i) option. It will provide you
with all the functionality you request, with the assumption that the
server B database be used for read only activity. The other major
benefit is that the whole process of updating the server B database can
be fully controlled and automated. 

There's a lot to it all so read up on the Oracle8i Standby Database
Concepts or the Oracle9i Data Guard Concepts manuals to see if it indeed
offers the functionality you're after (http://tahiti.oracle.com)

I suspect it does.

Cheers

Richard

TOHSH wrote:
> 
> Hi,
> 
> I am having 2 server(HPUX) running Oracle. I would like to implement a
> replication system where the database will be copied from Server A to
> server B on a perodic timing. There is no requirement for real time data
> replication.
> 
> I know that there are a lot of replication software or HA package out in
> the market, but I would only require the most basic and the most cost
> efective solution.
> 
> I have this idea, if is is posible to backup the Oracle DB on line and
> dump the backups to disk. We will put the DB into Backup mode every X
> hour and the things that will be backup are all the table space, archive
> logs, control files and etc from server A. After that we will ftp these
> backup files to server B where we will use the archive logs, control
> files and etc to apply changes to the DB in server B.
> 
> Please comment.
> 
> Thanks,
> TohSH
--------------C14DBAED7F5F767773B2190F
Content-Type: text/x-vcard; charset=UTF-8;
 name="Richard.Foote.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Richard Foote
Content-Disposition: attachment;
 filename="Richard.Foote.vcf"

begin:vcard 
n:;Richard
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:Richard.Foote@oracle.com
fn:Richard Foote
end:vcard

--------------C14DBAED7F5F767773B2190F--