Oracle DataBase replication
We have 10 sites remote sites and one central site running Oracle,
to backup the remotes sites on the central, we dump the database,
compress it then tranfert it with ftp, the method is manual and not
We are looking for a solution like incremental backup or replication to
transfert small quantities of data per file transfert to get all the sites
Please advice on the best way or solution to achieve that goal.
export is not a backup
Ok for RMAN, now the remote sites are far from the central
site and we are using Internet to transfert files, do you think
RMAN is suitable for that ? I would like to get more information
about how it works.
I would be looking at Oracle Streams for this kind of requirement rather then RMAN or any other backup solution.
Configuire streams on your central site and propogation and apply queues on the bespoke sites to receive changed data.
I am not sure internet is the best way to go about doing replication or for that matter transferring files backed up.
You need to spend some $$ to setup a dedicated network connecting all the sites
Click Here to Expand Forum to Full Width