replication HDR
Posted in 2008
Topics: High Availability & Replication, Server Administration, Logging & Checkpoints, Networking & sqlhosts Configuration
Hi,
Last night I recycled informix engine 10.00 FC7 (which is also primary in hdr
pair) and brought back up in half a minute. It sent replication failure
immediately on secondary server online message. but when I brought primary
back online, it gave this message in online:
DR: Failure recovery from disk in progress ..
and no other checkpoint or log message after that in online log. When I run
onstat -g dri on primary or secondary it told me primary online and secondary(read only) as expected but why don't I see any activity in secondary online
log after the message mentioned above. Last time when I recycled primary
engine I had to run onmode -d secondary (primarydbservername) on secondary as
it had broken the replication but this time it didn't so I didn't do anything
but I don't know what is going on. How can I make sure if secondary is
accepting data from primary? I didn't reboot secondary when I rebooted primary
last night.
Please respond asap as I am not sure if replication is running or not.
Fyi...I have DRAUTO set to 0 on primary onconfig but no such parameter in
secondary onconfig. Maybe because we don't switch when we go down on primary.
Thanks,
Sunita
Have you tried creating a test table or database on the primary to see if it
creates on the secondary?
Thanks,
**************************************
Ernie Knox
Sears Holding Co.
IT Database Administrator Specialist
IT Service Management, Strategy & Architecture
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Fax: (847) 645-3874
Pager: (800) 759-8352 Pin#: 7271042
Email: eknox@sears.com
" It's always a great day to watch Football ! "
**************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SUNITA
RAINA
Sent: Friday, March 07, 2008 10:12 AM
To: ids@iiug.org
Subject: replication HDR [11533]
Hi,
Last night I recycled informix engine 10.00 FC7 (which is also primary in hdr
pair) and brought back up in half a minute. It sent replication failure
immediately on secondary server online message. but when I brought primary
back online, it gave this message in online:
DR: Failure recovery from disk in progress ..
and no other checkpoint or log message after that in online log. When I run
onstat -g dri on primary or secondary it told me primary online and secondary(read only) as expected but why don't I see any activity in secondary online
log after the message mentioned above. Last time when I recycled primary
engine I had to run onmode -d secondary (primarydbservername) on secondary as
it had broken the replication but this time it didn't so I didn't do anything
but I don't know what is going on. How can I make sure if secondary is
accepting data from primary? I didn't reboot secondary when I rebooted primary
last night.
Please respond asap as I am not sure if replication is running or not.
Fyi...I have DRAUTO set to 0 on primary onconfig but no such parameter in
secondary onconfig. Maybe because we don't switch when we go down on primary.
Thanks,
Sunita
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g