Skip to Content
0

IBM DB2 HADR Standby fail

May 16, 2017 at 03:40 PM

136

avatar image
Former Member

Hi Sap Gurus,

We have setup on IBM DB2 10.05 HADR on AIX 7.1, but standby database the lastest transaction timestamp or received logs on standby database was 01/10/2017 12:23:02 (January 10). How to make to update standby database again?

Best regards,

Anderson C.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Juan Reyes
May 17, 2017 at 01:42 PM
0

Hi Anderson,

I presume HADR is down, so first thing you can do is to try starting the database as standby. If the remote catchup works then you are in business... if it doesn't then the best thing to do is to restore from a backup of the primary and start the standby again.

Is there any particular error you are getting?

Regards, JP

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 18, 2017 at 02:59 PM
0

Hi Juan,

Thanks for your answer. The hadr_state is remote_catchup, but the standby database is down continously becauseprimary_log_time and standby_replay_log_time are since 01/10/2017.

Enclose picture.

db2-start-hadr.png


db2-start-hadr.png (25.9 kB)
Share
10 |10000 characters needed characters left characters exceeded
Juan Reyes
May 19, 2017 at 02:29 PM
0

Any error on the db2diag.log?

have you try to stop and start HADR?.... having said that if you not keeping all the archived logs since January you might as well restore from primary and re-enable HADR

Regards, JP

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 19, 2017 at 04:15 PM
0

Hi Juan.

Do you know if can i restore from redirect method and then re-enable HADR.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Standard restore, no redirect required as its the same instance.

db2 restore db <instance> load <location> taken at <timestamp> replace history file

No need to rollforward, remote catchup will take care of that.... then simply enable HADR

Please read the documentation before proceeding

Regards, JP

0
Former Member

Ok, Juan.

Thanks a lot!

0