Oracle Replication question
Date: Thu, 08 Aug 2002 17:48:01 +0800
Message-ID: <3d523de1$1_at_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