instance sync up option
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: instance sync up option

  1. #1
    Join Date
    Mar 2006
    Posts
    176

    instance sync up option

    Hi all,

    In Oracle, and I am on 9i what option can we use to sync up the two database for disaster purpose (somehting like standby). I know RAC is one of the option but is there anything else available???

    In MSSQL, we can backup the DB, move it to another server and ship the logs to keep them in Sync????

    any thoughts?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    err a standby database? thats what you want

    RAC is not an option as there is only one database

  3. #3
    Join Date
    Mar 2006
    Posts
    176
    for standby DB, can Oracle automatically push the archive log and sync up the DB in let's say 15 min interval????


    thanks

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what do you mean?

    You can apply a lag of 15 minsutes if thats what you want?, i.e the standby will wait 15 mins before applying the log.

    otherwise it applies the redo as soon as it gets it

  5. #5
    Join Date
    Mar 2006
    Posts
    176
    ok, please correct me if I am wrong. throughout the research I have done, here what I understand.

    prior to 9i (in 8i), Oracle called STANDBY. In 9i , Oracle called DATA GUARD so they are both the same. is this correct???

    and also, does STANDBY or DATA GUARD available to Standard edition????

    thanks

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no not available to standard edition (althought it can be manually done)

    is its basic terms, standby = dataguard but dataguard gives you a while lot more options

  7. #7
    Join Date
    Mar 2006
    Posts
    176
    thanks Davey,

    can you please shed some light when you say "althought it can be manually done" , can you give a method so I can do some testing?

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    http://www.niall.litchfield.dial.pipex.com/, search for standy t has how to do it for windows, but the same techniques can apply to other os's

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