Thread: HADR - Re-Setup
08-31-09, 16:51 #1Registered User
- Join Date
- Dec 2008
Unanswered: HADR - Re-Setup
DB2 V8.2 WIN 2003
I had to stop the HADR due to the server issue on the Standby system.
Now I want to re-setup the HADR. How can I perform this easily?
Is this steps are correct?
1. Take full backup on the LIVE DB (Primary)
2. Restore the backup to STANDBY Node with Rollforward pending mode
3. Start HADR on Standby server as STANDBY
4. Start HADR on Live node as Primary.
Do I need to configure any parameters? I did not drop the Standby DB and restoring with REPLACE option only.
Please post me your experience.
09-01-09, 01:10 #2Registered User
- Join Date
- May 2003
You will have to change some of the HADR settings on the standby after you restore the primary database on the standby server. The local and remote host names are reversed, as are HADR ports, etc.
Next time, don't stop HADR. Just deactivate the standby database and then stop the instance. Do the reverse when you bring it back on-line (you may have to restart db as standby). Should be OK if you the outage period is not too long (the primary still has all the logs and can replay them).M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390