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 > Q Replication Disaster

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-14-10, 10:25
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
Q Replication Disaster

We are having an issue with Q-replication. We brought down our Q-replication standby database for couple of hours for an OS upgrade. Meanwhile the capture was running on the primary database and was building up the Queue on MQ server. But unfortunately due to disaster we lost all the Queues. Now the replication needs to re-syncehd from primary. It would be grateful if someone could tell me the procedure how to accomplish this without causing an outage to the primary.
Reply With Quote
  #2 (permalink)  
Old 05-17-10, 05:11
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
refresh

you will have to connect to primary and execute export
on target a load to refresh all data
in replication center force a manual full refresh to reset the synchpoint
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old 05-19-10, 14:38
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
Thanks. The problem is that we cannot reset the synchpoint as we have another applier running for the same capture.

We had a staging database in between. We had to take a 10 mins of outage on primary to reset the synchpoint. We restored the production database to the staging database to point in time when outage was started and then kicked of a full refresh to the replicate copy from the staging database. After the refresh was done, we started the applier on replicate. The applier obviously starts applying from the redefined synchpoint which was defined during the outage.

Last edited by blazer789; 05-19-10 at 14:42.
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