Results 1 to 8 of 8

Thread: Hadr

  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: Hadr

    Hello Team,

    For testing purpose , we initally take an offline db backup on db2v8 production server to disk.

    1) The Backup image was FTPed into new HADR servers say A & B.

    2) DB2V9 installed.

    3) DB migrated through redirect restore on primary server A.

    4) COnfigured HADR by restoring without rollingforward on Secondary server B.

    5) HADR configured on server A as primary and Server B as seconday.

    Now the requirement is to copy the fresh db backup (recent one) on db2v8 production and to replace the db2v9 servers.

    Am planning to do the below tasks:
    ==================================
    1) Take an offline Database of V8 on production server to Disk.

    2) FTP the Backup Image from Production server to New servers A & B.

    3) Stop the HADR DB on both primary and secondary server.

    4) Restore the DB on primary server -

    5) Restore the DB on Secondary Server -(Without rolling forward)

    6) Start the HADR on both the serves as primary and standby respectively.(as earlier).

    Is the way am doing is correct?

    Thanks for your help in advance.

  2. #2
    Join Date
    Sep 2006
    Posts
    105
    Any Idea on this Folks ?

    Thanks for your help in Advance.

  3. #3
    Join Date
    Jan 2010
    Posts
    335
    If you tested it thaat way, why shouldn't it work for your productive migration?

    Do you have automatic failover? To be on the safe side i'ld drop the configuration and recreate it afterwards.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Curious!Did this work?

    Specifically steps 4,5 and 6 in your plan?

    Thanks
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Aug 2008
    Posts
    76
    Hi Meena,

    You can follow this procedure.

    1) Take an offline Database of V8 on production server to Disk.

    2) FTP the Backup Image from Production server to New server A ( Primary ).

    3) Deactivate primary database and stop the primary instance, deactivate standby database and stop standby instance.

    4) Restore the backup on Primary without rolling forward. ( HADR automatically deactivates after a restore).

    5) Take a backup of primary and restore it on the standby without rolling forward.

    6) Start HADR on standby and then start HADR on primary.

    Thanks,
    Panditt

  6. #6
    Join Date
    Aug 2008
    Posts
    76
    Hi Sathya,

    Steps 4,5 and 6 mentioned in Meena's procedure would work if the backup taken was at the same level as the current instance. But as you know HADR must be started on standby first and then primary.

    Since, she is restoring from a previous version it would be very interesting to know if those steps would work.

    Thanks,Pandit

  7. #7
    Join Date
    Sep 2006
    Posts
    105
    Thanks Santhya and Pandit.

    I didn't test the above steps yet . will be trying to perfom this by next week.

    Pandit .. We need to restore without rolling forward on primary as per your steps ?

  8. #8
    Join Date
    Aug 2008
    Posts
    76
    Hi Meena,

    I am sorry it was a typo. You can restore the database on primary either ways i.e. either offline or online backups can be used to restore on primary. But as you know on standby you should not rollforward.


    1) Take an offline Database of V8 on production server to Disk.

    2) FTP the Backup Image from Production server to New server A ( Primary ).

    3) Deactivate primary database and stop the primary instance, deactivate standby database and stop standby instance.

    4) Start primary instance, Restore the backup on Primary . ( HADR automatically deactivates after a restore).

    5) Start standby instance, Take a backup of primary and restore it on the standby without rolling forward.

    6) Start HADR on standby and then start HADR on primary.

Posting Permissions

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