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 > Start HADR cannot complete...

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-28-09, 10:02
rks4sm rks4sm is offline
Registered User
 
Join Date: May 2008
Location: delhi
Posts: 6
Question Start HADR cannot complete...

Hi!

I was trying to setup a HADR for the sample database on two servers
under the windows environment.
I am using IBM DB2 9.5 FP "0" and windows server 2003 SP2.
I set up the configuration parameters correctly on both the primary
server and standby server.
First I tried with GUI which run fune till the point it reaches
"update services file".
and then it threw an error which was like javaw.exe : application
error
and then the control center exits.
Then I tried to set up manually .and It run fine till I start primary
server
DB2 start HADR on db SAMPLE as primary
the error it gives is different when I run it different time with RC=1
and RC=99 and RC=8

SQL1767N Start HADR cannot complete. Reason code = "1".

Standby server is running successfully.

can somebody please tell me what I am missing?

Thanks ,
Rakesh
Reply With Quote
  #2 (permalink)  
Old 07-28-09, 11:55
dbamota dbamota is offline
Registered User
 
Join Date: Sep 2003
Posts: 237
Did you take an online backup of the primary and restore it on the secondary?
__________________
mota
Reply With Quote
  #3 (permalink)  
Old 07-28-09, 11:55
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Quote:
The database was not in roll forward-pending or roll
forward-in-progress state when the START HADR AS STANDBY command
was issued.
this is the explanation for reason code 1

and the user response
Quote:

Initialize the standby database from a backup image or a split
mirror of the primary database, then reissue the START HADR AS
STANDBY command.
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #4 (permalink)  
Old 07-30-09, 01:58
rks4sm rks4sm is offline
Registered User
 
Join Date: May 2008
Location: delhi
Posts: 6
I have taken online backup on the Primary server and restored it on Standby.
Now I am getting the error with reason code:99
All I can find on Info center is :
An internal error occurred during HADR startup.
Reply With Quote
  #5 (permalink)  
Old 07-30-09, 11:48
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
after the restore and setting all db cfg settings - hadr should be started on standby - when this is finished - start hadr on primary that will contact the standby--
the standby db should always be in rollforward state - to apply the log from primary - have a look at info center for details about hadr scenario
Initializing high availability disaster recovery (HADR)
__________________
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
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