HADR
in [DB2]
|
Prev: Question on SUM()
Next: No remote connections available
From: Gladiator on 23 Jun 2006 04:33 Hai everyone...... i was trying to implement the HADR concept ........ i tried using the following commands ...... On server_1 db2 backup database prod to /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_1 HADR_REMOTE_HOST server_2 HADR_LOCAL_SVC port_s1 HADR_REMOTE_SVC port_s2 HADR_REMOTE_INST db2inst2 db2 start hadr on database prod as primary On server_2 db2 restore database prod from /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_2 HADR_REMOTE_HOST server_1 HADR_LOCAL_SVC port_s2 HADR_REMOTE_SVC port_s1 HADR_REMOTE_INST db2inst1 db2 start hadr on database prod as standby but when i am giving tht "db2 start hadr " command its giving cannot start hadr... can anyone tell me do i need to do anything other than this ........... pls let me know if anything wrong........ Thanks Kamal....
From: Mark A on 23 Jun 2006 04:36 "Gladiator" <vkamalnath1237(a)gmail.com> wrote in message news:1151051597.831895.129050(a)r2g2000cwb.googlegroups.com... > Hai everyone...... > i was trying to implement the HADR concept > ....... i tried using the following commands ...... > > On server_1 > db2 backup database prod to /backup_dir > db2 update db cfg for prod using > HADR_LOCAL_HOST server_1 > HADR_REMOTE_HOST server_2 > HADR_LOCAL_SVC port_s1 > HADR_REMOTE_SVC port_s2 > HADR_REMOTE_INST db2inst2 > db2 start hadr on database prod as primary > > On server_2 > db2 restore database prod from /backup_dir > db2 update db cfg for prod using > HADR_LOCAL_HOST server_2 > HADR_REMOTE_HOST server_1 > HADR_LOCAL_SVC port_s2 > HADR_REMOTE_SVC port_s1 > HADR_REMOTE_INST db2inst1 > db2 start hadr on database prod as standby > > > but when i am giving tht "db2 start hadr " command its giving cannot > start hadr... can anyone tell me do i need to do anything other than > this ........... pls let me know if anything wrong........ > > > Thanks > Kamal.... > Don't issue the command "db2 start hadr on database prod as primary" until you have started HADR on standby first. Also, make sure you have logretain on (or using exit program or archive log path, etc).
From: Gladiator on 23 Jun 2006 06:45 Mark A wrote: > "Gladiator" <vkamalnath1237(a)gmail.com> wrote in message > news:1151051597.831895.129050(a)r2g2000cwb.googlegroups.com... > > Hai everyone...... > > i was trying to implement the HADR concept > > ....... i tried using the following commands ...... > > > > On server_1 > > db2 backup database prod to /backup_dir > > db2 update db cfg for prod using > > HADR_LOCAL_HOST server_1 > > HADR_REMOTE_HOST server_2 > > HADR_LOCAL_SVC port_s1 > > HADR_REMOTE_SVC port_s2 > > HADR_REMOTE_INST db2inst2 > > db2 start hadr on database prod as primary > > > > On server_2 > > db2 restore database prod from /backup_dir > > db2 update db cfg for prod using > > HADR_LOCAL_HOST server_2 > > HADR_REMOTE_HOST server_1 > > HADR_LOCAL_SVC port_s2 > > HADR_REMOTE_SVC port_s1 > > HADR_REMOTE_INST db2inst1 > > db2 start hadr on database prod as standby > > > > > > but when i am giving tht "db2 start hadr " command its giving cannot > > start hadr... can anyone tell me do i need to do anything other than > > this ........... pls let me know if anything wrong........ > > > > > > Thanks > > Kamal.... > > > > Don't issue the command "db2 start hadr on database prod as primary" until > you have started HADR on standby first. > > Also, make sure you have logretain on (or using exit program or archive log > path, etc). Thanks a lot.... kamal
From: Gladiator on 23 Jun 2006 07:33 Mark A wrote: > "Gladiator" <vkamalnath1237(a)gmail.com> wrote in message > news:1151051597.831895.129050(a)r2g2000cwb.googlegroups.com... > > Hai everyone...... > > i was trying to implement the HADR concept > > ....... i tried using the following commands ...... > > > > On server_1 > > db2 backup database prod to /backup_dir > > db2 update db cfg for prod using > > HADR_LOCAL_HOST server_1 > > HADR_REMOTE_HOST server_2 > > HADR_LOCAL_SVC port_s1 > > HADR_REMOTE_SVC port_s2 > > HADR_REMOTE_INST db2inst2 > > db2 start hadr on database prod as primary > > > > On server_2 > > db2 restore database prod from /backup_dir > > db2 update db cfg for prod using > > HADR_LOCAL_HOST server_2 > > HADR_REMOTE_HOST server_1 > > HADR_LOCAL_SVC port_s2 > > HADR_REMOTE_SVC port_s1 > > HADR_REMOTE_INST db2inst1 > > db2 start hadr on database prod as standby > > > > > > but when i am giving tht "db2 start hadr " command its giving cannot > > start hadr... can anyone tell me do i need to do anything other than > > this ........... pls let me know if anything wrong........ > > > > > > Thanks > > Kamal.... > > > > Don't issue the command "db2 start hadr on database prod as primary" until > you have started HADR on standby first. > > Also, make sure you have logretain on (or using exit program or archive log > path, etc). Now its working....... Does the stand by database automatically takes over after the primary one fails??? or do we need to manually give the takeover command...........
From: Knokmans on 23 Jun 2006 08:42
"Gladiator" <vkamalnath1237(a)gmail.com> wrote in message news:1151062392.801515.129100(a)g10g2000cwb.googlegroups.com... > > Mark A wrote: >> "Gladiator" <vkamalnath1237(a)gmail.com> wrote in message >> news:1151051597.831895.129050(a)r2g2000cwb.googlegroups.com... >> > Hai everyone...... >> > i was trying to implement the HADR concept >> > ....... i tried using the following commands ...... >> > >> > On server_1 >> > db2 backup database prod to /backup_dir >> > db2 update db cfg for prod using >> > HADR_LOCAL_HOST server_1 >> > HADR_REMOTE_HOST server_2 >> > HADR_LOCAL_SVC port_s1 >> > HADR_REMOTE_SVC port_s2 >> > HADR_REMOTE_INST db2inst2 >> > db2 start hadr on database prod as primary >> > >> > On server_2 >> > db2 restore database prod from /backup_dir >> > db2 update db cfg for prod using >> > HADR_LOCAL_HOST server_2 >> > HADR_REMOTE_HOST server_1 >> > HADR_LOCAL_SVC port_s2 >> > HADR_REMOTE_SVC port_s1 >> > HADR_REMOTE_INST db2inst1 >> > db2 start hadr on database prod as standby >> > >> > >> > but when i am giving tht "db2 start hadr " command its giving cannot >> > start hadr... can anyone tell me do i need to do anything other than >> > this ........... pls let me know if anything wrong........ >> > >> > >> > Thanks >> > Kamal.... >> > >> >> Don't issue the command "db2 start hadr on database prod as primary" >> until >> you have started HADR on standby first. >> >> Also, make sure you have logretain on (or using exit program or archive >> log >> path, etc). > > > > > > > Now its working....... Does the stand by database automatically takes > over after the primary one fails??? or do we need to manually give the > takeover command........... > NO automatic failover will happen !! One thing you absolutely want to prevent is having 2 primaries. And this might happen when doing an automatic failover where -for example- the primary's network interface may fail for a few seconds, the standby takes over HADR, and then the primary returns again. Knokmans |