Date: Thu, 08 Aug 2002 17:48:01 +0800
From: TOHSH <sh_toh@hotmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.1b) Gecko/20020721
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server,comp.databases.oracle,comp.databases.oracle.misc
Subject: Oracle Replication question
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 192.245.59.98
Message-ID: <3d523de1$1@news.starhub.net.sg>
X-Trace: 8 Aug 2002 17:46:09 +0800, 192.245.59.98
Organization: StarHub Internet Pte Ltd
Lines: 23
Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!news.stealth.net!news.stealth.net!newsvr.starhub.net.sg!news.starhub.net.sg!192.245.59.98
Xref: easynews comp.databases.oracle.server:157249 comp.databases.oracle:16834 comp.databases.oracle.misc:85312
X-Received-Date: Thu, 08 Aug 2002 02:46:03 MST (news.easynews.com)

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