If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > HADR - Re-Setup

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-31-09, 15:51
dgunas dgunas is offline
Registered User
 
Join Date: Dec 2008
Location: Chennai
Posts: 110
HADR - Re-Setup

Hello,
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.

Thanks, Gunas.
__________________
Reply With Quote
  #2 (permalink)  
Old 09-01-09, 00:10
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On