SEO

#1 (**permalink**) 02-27-2008, 12:45 PM

Hi,

our comapny plans to deploy SYNC mode HADR in a new production
environment. I am doing the research. I have a question needs to be
clarified:

when network down, primary and standby databases won't be in PEER
mode, although both of them up and running. In this case, is there any
method to re-establish the HADR except backup/restore? for example,
can I find out where they have been synchronized, manually ftp log
files that have not been replayed on standby to the standby database,
roll forward the standby database to the end of logs?

#2 (**permalink**) 02-27-2008, 12:46 PM

I will assume for the moment that you are concerned with catching up
the standby after the network is again available. If this is not what
you're after, please clarify the scenario you are concerned with.

One cannot issue a ROLLFORWARD command on an HADR standby. However,
after the network is again available, HADR will attempt to catch up on
its own. The standby will reconnect to the primary and pull log pages
from the primary starting where it left off.

You can also manually move log files from the primary to the standby
if you believe you have a faster means to do so. To be safe,
deactivate the standby while placing log files in the log path. And
make sure only correct log files are placed on standby (i.e., not from
some other db or some other incarnation of this same db).

If the network was down for a long time, and in your opinion it would
be faster to re-initialize the standby from a new backup of the
primary, then that is another option.

Regards,
- Steve P.
--
Steve Pearson, DB2 for Linux, UNIX, and Windows, IBM Software Group
"Portland" Development Team, IBM Beaverton Lab, Beaverton, OR, USA

#3 (**permalink**) 02-27-2008, 12:46 PM

Thanks Steve, that's what I want to know.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

HADR questions