Re: Oracle Replication question

Retrofitting an existing system with Oracle replication is a risky proposition and IMO, and a mis-application of technology for what you seem to want to accomplish. Also IMO, the most cost effective solution is to perform standard scripted backup (a combination of cold and hot using RMAN) and recovery procedures. If you want to achieve continuous uptime you need to spend money. We are using EMC technology to perform what you want to do. We put our database in backup mode around 2AM, then we quickly update a BCV and then end backup mode. On Sunday morning we shutdown and update the BCV for a cold image. The cold image is then backed up to tape. Downtime is minimal. Just my $0.02 worth.

Stephen Ferracioli
Database Administrator

"TOHSH" <sh_toh_at_hotmail.com> wrote in message news: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
>
Received on Thu Aug 08 2002 - 12:28:00 CDT