Re: Oracle Replication question

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