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 1424
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
Thanks Steve, that's what I want to know. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Bruce M |
last post by:
Is there a way to run the db2-generated HADR-create script outside of
DB2CC beyond the obvious? My DB2CC generates the HADR script and then
abends because of a java error meaning I can't finish my HADR
creation.
In looking at the script it isn't necessarily obvious which commands
should run on the primary server and which should be run on...
|
by: shindle |
last post by:
Hello -
I am in the process of testing out the new HADR feature of DB2 UDB V8.2
and I have some questions that I was hoping that someone could answer
please.
I have a HADR test set-up with two DB2 instances on the same machine
with the sample database on each set up as an HADR pair in near-synch
mode. I have noticed that when I perform...
|
by: bwmiller16 |
last post by:
Why are 2 ports required for a HADR Pair?
Environment: RH Linux AS3
UDB Express 8.2 with HADR Option
Folks -
Working with HADR and getting this setup to work right.
|
by: Mark A |
last post by:
If server 01 running HADR in the primary role crashes, and the DBA does a
HADR takeover by force on the 02 server to switch roles, then the 02 server
is now the primary.
What happens when the Server 01 is brought back up? It still thinks it is
the primary because that was its role when it crashed and it does not know
about the takeover by...
|
by: Marc |
last post by:
Hi,
I'm working with a customer that is trying to find a solution to
provide geographical redundancy. Our application is currently using
IBM DB2 v8.2. I have a couple of questions with regards to HADR:
1. DB2 HADR (Can it be used to support geographical redundancy in
a
nested fashion (ie. Synchronous HADR at a site, and ASYNCRONOUS...
| |
by: gumby |
last post by:
I'm having trouble getting HADR to work with the sample databases on
two HS20 xSeries blades, Red Hat ES4 up3, DB2 8.2.4, getting the
following error.
SQL1768N Unable to start HADR. Reason code = "7" - The primary
database failed to establish a connection to its standby database
within the HADR timeout interval.
What things should I...
|
by: Challenge |
last post by:
Hi,
I got error, SQL1768N Unable to start HADR. Reason code = "7", when I
tried to start hadr primary database. Here are the hadr configuration
of my primary db:
HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) = testserver
HADR local service name ...
|
by: madzambonis |
last post by:
Here is the situation....
We have Primary Server A linked to Standby Server B via HADR.
Primary Server A has recently installed LOGARCHMETH1 to archive logs
and a 2nd homegrown script that compresses the archived logs once in
the archive log directory.
Standby Server B has our old script that moves logs from active to
archive directories...
|
by: deshaipet |
last post by:
Hi -
We have primary and standby databases on different servers.
Here is my /etc/service entry for HADR pair :
On Primary :
"vi /etc/services
|
by: DB2 Warlord |
last post by:
After countless time I was unabl to find the answer to my HADR questions and getting HADR to work in 9.5 via the Control Center. Please see my fix that seem strange but works.
My error was as follows. When setting up HADR via the CCenter at the last step in a full setup called "START HADR" it would fail with reason 7.
Now trying to solve...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |