Oracle DataBase replication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle DataBase replication

  1. #1
    Join Date
    Jan 2004
    Location
    Douala-Cameroun
    Posts
    21

    Oracle DataBase replication

    Hi,
    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
    secured.
    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
    backuped quickly.
    Please advice on the best way or solution to achieve that goal.
    Thanks
    Consty
    Consty

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    export is not a backup

    usr rman

  3. #3
    Join Date
    Jan 2004
    Location
    Douala-Cameroun
    Posts
    21
    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.
    Thanks
    Consty
    Consty

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    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

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width