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.

Any Idea on this Folks ?

Thanks for your help in Advance.

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.

Curious!Did this work?

Specifically steps 4,5 and 6 in your plan?

Thanks

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

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

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 ?

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.