Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    62

    Unanswered: Implement standby database which lags behind primary for certain time ?

    Hi,

    To prevent logical mistake I want to implement standby database which lags behind primary database for certain time. I mean primary db is in operation and copies logs to standby database, while standby database waits certain time (for example 24h) and applies these logs - so basically standby database is 24 hours behind primary db.
    The goal is to prevent logical mistake like accidental table deletion which basically doesn't break things but further work is not possible. There are other mechanisms on this system to prevent such errors as node down.

    How do I implement that ? I was reading about db2 HADR and there are similarities - but one problem - standby database applies logs in no time - it doesn't wait any period of time. So how do I implement that - by using HADR options, or by other method ?


    thanks
    Vilius

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    try log shipping
    copy the archived logs to new system and rollforward at any time
    to get the db active, you need to bring it out of rollforward state
    to continue the log shipping - restore is needed
    also with hadr - the standby db can not be accessed while in rollforward mode
    maybe replication can help for you and start apply at certain times, so db is always available and up-to-date to whatever moment needed
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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