Oracle Replication question

From: TOHSH <sh_toh_at_hotmail.com>
Date: Thu, 08 Aug 2002 17:48:01 +0800
Message-ID: <3d523de1$1@news.starhub.net.sg>

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 Received on Thu Aug 08 2002 - 04:48:01 CDT