Replication and backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Replication and backup

  1. #1
    Join Date
    Sep 2000
    Posts
    103
    Hi ,

    I'm trying to implement a multimaster replication for our database here. Can someone provide me with info on how to do the backups for this system. If I have two master sites , one in UK and the other in US, how will I do the backup?? Should it be done at each end?

    Please advise.
    Thanks a lot
    pst

  2. #2
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    Yes!

    You can do hot backups OR if one site is down due to cold backup or even a site crash, the working site will collect it's DML transactions in the deferred queue until the other site comes online. When the other site comes on-line, the propogation (the PUSH job) will begin.

    Make certain that the tablespace that REPADMIN writes to can handle a few hours of building deferred transactions.

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