HDR primary state off
After patching the DR server and restoring the secondary (Informix 11.70 on HP-UX), HDR wouldn't restart: onstat showed the secondary's state as 'on' but the primary's as 'off'. The primary's online.log showed DR_ERR -2, 'Failure recovery error (2)', 'Cannot connect to secondary' and a broken network connection (-25582), while the secondary logged 'Received connection request from remote server when DR is not Off'. Suggestions were to verify the onmode -d primary/secondary syntax, check onstat -l current logs, and reset one side to standard mode before re-pairing (possibly re-initialising HDR). The thread records no confirmation that this worked.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Platform Informix 11.70 FC8W1: OS HP-AUX
Good evening,
Over the weekend had to switch off replication as patches were being applied
on the DR server. Then on Monday morning ran restore on secondary server.
after running the restore I switch replication on for both primary and
secondary servers, using command onmode -d primary alias name for primary and
secondary. The issue at hand is that replication is still OFF on primary and
ON secondary. How can put the state of primary to ON again as nothing is being
replicated. But the primary server shows that it is a primary server. It is
just the state of the replication that is off.
Regards
Zanele
Your onmode -d commands were incorrect. Should be:
On primary:
onmode -d primary <secondary name>
On secondary
onmode -d secondary <primary name>
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <masangozanele@gmail.com>
wrote:
> Platform Informix 11.70 FC8W1: OS HP-AUX
>
> Good evening,
>
> Over the weekend had to switch off replication as patches were being
> applied
> on the DR server. Then on Monday morning ran restore on secondary server.
> after running the restore I switch replication on for both primary and
> secondary servers, using command onmode -d primary alias name for primary
> and
> secondary. The issue at hand is that replication is still OFF on primary
> and
> ON secondary. How can put the state of primary to ON again as nothing is
> being
> replicated. But the primary server shows that it is a primary server. It is
> just the state of the replication that is off.
>
> Regards
> Zanele
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Good Morning,
Thank you for your response.
But that exactly what I did.
On primary:
onmode -d primary <secondary name>
On secondary
onmode -d secondary <primary name>
But secondary state is on and primary state is off please see below:
On Primary:
Data Replication at c00000010ae49030:
Type State Paired server Last DR CKPT (id/pg)
Supports Proxy Writes
primary off rafdr_hdr 353073 / 19406
NA
On Secondary
Data Replication at c00000010ae49030:
Type State Paired server Last DR CKPT (id/pg)
Supports Proxy Writes
HDR Secondary on rafcsprd_hdr -1 / -1 N
Regards
Zanele
On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com> wrote:
> Your onmode -d commands were incorrect. Should be:
>
> On primary:
>
> onmode -d primary <secondary name>>
> On secondary
>
> onmode -d secondary <primary name>>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <masangozanele@gmail.com>
> wrote:
>
> > Platform Informix 11.70 FC8W1: OS HP-AUX
> >
> > Good evening,
> >
> > Over the weekend had to switch off replication as patches were being
> > applied
> > on the DR server. Then on Monday morning ran restore on secondary server.
> > after running the restore I switch replication on for both primary and
> > secondary servers, using command onmode -d primary alias name for primary
> > and
> > secondary. The issue at hand is that replication is still OFF on primary
> > and
> > ON secondary. How can put the state of primary to ON again as nothing is
> > being
> > replicated. But the primary server shows that it is a primary server. It
> is
> > just the state of the replication that is off.
> >
> > Regards
> > Zanele
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Check the message log (online.log) for the primary, what does it say?
Regards,
David.
> On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com> wrote:
>
>
> Good Morning,
>
> Thank you for your response.
>
> But that exactly what I did.
> On primary:
>
> onmode -d primary <secondary name>>
> On secondary
>
> onmode -d secondary <primary name>>
> But secondary state is on and primary state is off please see below:
>
> On Primary:
>
> Data Replication at c00000010ae49030:
> Type State Paired server Last DR CKPT (id/pg)
> Supports Proxy Writes
> primary off rafdr_hdr 353073 / 19406
> NA
>
> On Secondary
> Data Replication at c00000010ae49030:
> Type State Paired server Last DR CKPT (id/pg)
> Supports Proxy Writes
> HDR Secondary on rafcsprd_hdr -1 / -1 N
>
> Regards
> Zanele
>
> On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com> wrote:
>
> > Your onmode -d commands were incorrect. Should be:
> >
> > On primary:
> >
> > onmode -d primary <secondary name>> >
> > On secondary
> >
> > onmode -d secondary <primary name>> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <masangozanele@gmail.com>
> > wrote:
> >
> > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > >
> > > Good evening,
> > >
> > > Over the weekend had to switch off replication as patches were being
> > > applied
> > > on the DR server. Then on Monday morning ran restore on secondary server.
> > > after running the restore I switch replication on for both primary and
> > > secondary servers, using command onmode -d primary alias name for primary
> > > and
> > > secondary. The issue at hand is that replication is still OFF on primary
> > > and
> > > ON secondary. How can put the state of primary to ON again as nothing is
> > > being
> > > replicated. But the primary server shows that it is a primary server. It
> > is
> > > just the state of the replication that is off.
> > >
> > > Regards
> > > Zanele
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Good Morning,
Below is the message from online.log file
07:41:03 DR_ERR set to -2
07:41:03 DR: Failure recovery error (2)
07:41:04 DR: Turned off on primary server
07:41:04 DR: Cannot connect to secondary server
07:41:14 DR: Primary server connected
07:41:14 DR: Send error
07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
Network con
nection is broken.
On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <david@smooth1.co.uk>
wrote:
> Check the message log (online.log) for the primary, what does it say?
>
> Regards,
> David.
>
> > On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com> wrote:
> >
> >
> > Good Morning,
> >
> > Thank you for your response.
> >
> > But that exactly what I did.
> > On primary:
> >
> > onmode -d primary <secondary name>> >
> > On secondary
> >
> > onmode -d secondary <primary name>> >
> > But secondary state is on and primary state is off please see below:
> >
> > On Primary:
> >
> > Data Replication at c00000010ae49030:
> > Type State Paired server Last DR CKPT (id/pg)
> > Supports Proxy Writes
> > primary off rafdr_hdr 353073 / 19406
> > NA
> >
> > On Secondary
> > Data Replication at c00000010ae49030:
> > Type State Paired server Last DR CKPT (id/pg)
> > Supports Proxy Writes
> > HDR Secondary on rafcsprd_hdr -1 / -1 N
> >
> > Regards
> > Zanele
> >
> > On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com> wrote:
> >
> > > Your onmode -d commands were incorrect. Should be:
> > >
> > > On primary:
> > >
> > > onmode -d primary <secondary name>> > >
> > > On secondary
> > >
> > > onmode -d secondary <primary name>> > >
> > > Art
> > >
> > > Art S. Kagel, President and Principal Consultant
> > > ASK Database Management
> > > www.askdbmgt.com
> > >
> > > Blog: http://informix-myview.blogspot.com/
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > > and do not reflect on the IIUG, nor any other organization with which
> I am
> > > associated either explicitly, implicitly, or by inference. Neither do
> > > those opinions reflect those of other individuals affiliated with any
> > > entity with which I am affiliated nor those of the entities themselves.
> > >
> > > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> masangozanele@gmail.com>
> > > wrote:
> > >
> > > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > > >
> > > > Good evening,
> > > >
> > > > Over the weekend had to switch off replication as patches were being
> > > > applied
> > > > on the DR server. Then on Monday morning ran restore on secondary
> server.
> > > > after running the restore I switch replication on for both primary
> and
> > > > secondary servers, using command onmode -d primary alias name for
> primary
> > > > and
> > > > secondary. The issue at hand is that replication is still OFF on
> primary
> > > > and
> > > > ON secondary. How can put the state of primary to ON again as
> nothing is
> > > > being
> > > > replicated. But the primary server shows that it is a primary
> server. It
> > > is
> > > > just the state of the replication that is off.
> > > >
> > > > Regards
> > > > Zanele
> > > >
> > > >
> > > > ************************************************************
> > > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
> ************************************************************
> *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
What is in the online.log for the secondary server at the same time?
Regards,
David.
> On 16 May 2017 at 06:42 Zanele Masango <masangozanele@gmail.com> wrote:
>
>
> Good Morning,
>
> Below is the message from online.log file
>
> 07:41:03 DR_ERR set to -2
> 07:41:03 DR: Failure recovery error (2)
> 07:41:04 DR: Turned off on primary server
> 07:41:04 DR: Cannot connect to secondary server
> 07:41:14 DR: Primary server connected
> 07:41:14 DR: Send error
> 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> Network con
> nection is broken.
>
> On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <david@smooth1.co.uk>
> wrote:
>
> > Check the message log (online.log) for the primary, what does it say?
> >
> > Regards,
> > David.
> >
> > > On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com> wrote:
> > >
> > >
> > > Good Morning,
> > >
> > > Thank you for your response.
> > >
> > > But that exactly what I did.
> > > On primary:
> > >
> > > onmode -d primary <secondary name>> > >
> > > On secondary
> > >
> > > onmode -d secondary <primary name>> > >
> > > But secondary state is on and primary state is off please see below:
> > >
> > > On Primary:
> > >
> > > Data Replication at c00000010ae49030:
> > > Type State Paired server Last DR CKPT (id/pg)
> > > Supports Proxy Writes
> > > primary off rafdr_hdr 353073 / 19406
> > > NA
> > >
> > > On Secondary
> > > Data Replication at c00000010ae49030:
> > > Type State Paired server Last DR CKPT (id/pg)
> > > Supports Proxy Writes
> > > HDR Secondary on rafcsprd_hdr -1 / -1 N
> > >
> > > Regards
> > > Zanele
> > >
> > > On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com> wrote:
> > >
> > > > Your onmode -d commands were incorrect. Should be:
> > > >
> > > > On primary:
> > > >
> > > > onmode -d primary <secondary name>> > > >
> > > > On secondary
> > > >
> > > > onmode -d secondary <primary name>> > > >
> > > > Art
> > > >
> > > > Art S. Kagel, President and Principal Consultant
> > > > ASK Database Management
> > > > www.askdbmgt.com
> > > >
> > > > Blog: http://informix-myview.blogspot.com/
> > > >
> > > > Disclaimer: Please keep in mind that my own opinions are my own
> > opinions
> > > > and do not reflect on the IIUG, nor any other organization with which
> > I am
> > > > associated either explicitly, implicitly, or by inference. Neither do
> > > > those opinions reflect those of other individuals affiliated with any
> > > > entity with which I am affiliated nor those of the entities themselves.
> > > >
> > > > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> > masangozanele@gmail.com>
> > > > wrote:
> > > >
> > > > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > > > >
> > > > > Good evening,
> > > > >
> > > > > Over the weekend had to switch off replication as patches were being
> > > > > applied
> > > > > on the DR server. Then on Monday morning ran restore on secondary
> > server.
> > > > > after running the restore I switch replication on for both primary
> > and
> > > > > secondary servers, using command onmode -d primary alias name for
> > primary
> > > > > and
> > > > > secondary. The issue at hand is that replication is still OFF on
> > primary
> > > > > and
> > > > > ON secondary. How can put the state of primary to ON again as
> > nothing is
> > > > > being
> > > > > replicated. But the primary server shows that it is a primary
> > server. It
> > > > is
> > > > > just the state of the replication that is off.
> > > > >
> > > > > Regards
> > > > > Zanele
> > > > >
> > > > >
> > > > > ************************************************************
> > > > > *******************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > >
> > > > ************************************************************
> > > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > >
> > >
> > ************************************************************
> > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Good Day,
online.log Message from secondary server:
10:41:18 DR: Received connection request from remote server when DR is not
Off
[Local type: Secondary, Current state: ?]
[Remote type: Primary]
On Tue, May 16, 2017 at 10:18 AM, david@smooth1.co.uk <david@smooth1.co.uk>
wrote:
> What is in the online.log for the secondary server at the same time?
>
> Regards,
> David.
>
> > On 16 May 2017 at 06:42 Zanele Masango <masangozanele@gmail.com> wrote:
> >
> >
> > Good Morning,
> >
> > Below is the message from online.log file
> >
> > 07:41:03 DR_ERR set to -2
> > 07:41:03 DR: Failure recovery error (2)
> > 07:41:04 DR: Turned off on primary server
> > 07:41:04 DR: Cannot connect to secondary server
> > 07:41:14 DR: Primary server connected
> > 07:41:14 DR: Send error
> > 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> > Network con
> > nection is broken.
> >
> > On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <
> david@smooth1.co.uk>
> > wrote:
> >
> > > Check the message log (online.log) for the primary, what does it say?
> > >
> > > Regards,
> > > David.
> > >
> > > > On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com>
> wrote:
> > > >
> > > >
> > > > Good Morning,
> > > >
> > > > Thank you for your response.
> > > >
> > > > But that exactly what I did.
> > > > On primary:
> > > >
> > > > onmode -d primary <secondary name>> > > >
> > > > On secondary
> > > >
> > > > onmode -d secondary <primary name>> > > >
> > > > But secondary state is on and primary state is off please see below:
> > > >
> > > > On Primary:
> > > >
> > > > Data Replication at c00000010ae49030:
> > > > Type State Paired server Last DR CKPT (id/pg)
> > > > Supports Proxy Writes
> > > > primary off rafdr_hdr 353073 / 19406
> > > > NA
> > > >
> > > > On Secondary
> > > > Data Replication at c00000010ae49030:
> > > > Type State Paired server Last DR CKPT (id/pg)
> > > > Supports Proxy Writes
> > > > HDR Secondary on rafcsprd_hdr -1 / -1 N
> > > >
> > > > Regards
> > > > Zanele
> > > >
> > > > On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com>
> wrote:
> > > >
> > > > > Your onmode -d commands were incorrect. Should be:
> > > > >
> > > > > On primary:
> > > > >
> > > > > onmode -d primary <secondary name>> > > > >
> > > > > On secondary
> > > > >
> > > > > onmode -d secondary <primary name>> > > > >
> > > > > Art
> > > > >
> > > > > Art S. Kagel, President and Principal Consultant
> > > > > ASK Database Management
> > > > > www.askdbmgt.com
> > > > >
> > > > > Blog: http://informix-myview.blogspot.com/
> > > > >
> > > > > Disclaimer: Please keep in mind that my own opinions are my own
> > > opinions
> > > > > and do not reflect on the IIUG, nor any other organization with
> which
> > > I am
> > > > > associated either explicitly, implicitly, or by inference. Neither
> do
> > > > > those opinions reflect those of other individuals affiliated with
> any
> > > > > entity with which I am affiliated nor those of the entities
> themselves.
> > > > >
> > > > > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> > > masangozanele@gmail.com>
> > > > > wrote:
> > > > >
> > > > > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > > > > >
> > > > > > Good evening,
> > > > > >
> > > > > > Over the weekend had to switch off replication as patches were
> being
> > > > > > applied
> > > > > > on the DR server. Then on Monday morning ran restore on secondary
> > > server.
> > > > > > after running the restore I switch replication on for both
> primary
> > > and
> > > > > > secondary servers, using command onmode -d primary alias name for
> > > primary
> > > > > > and
> > > > > > secondary. The issue at hand is that replication is still OFF on
> > > primary
> > > > > > and
> > > > > > ON secondary. How can put the state of primary to ON again as
> > > nothing is
> > > > > > being
> > > > > > replicated. But the primary server shows that it is a primary
> > > server. It
> > > > > is
> > > > > > just the state of the replication that is off.
> > > > > >
> > > > > > Regards
> > > > > > Zanele
> > > > > >
> > > > > >
> > > > > > ************************************************************
> > > > > > *******************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > ************************************************************
> > > > > *******************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > ************************************************************
> > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
> ************************************************************
> *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Hi,
Did you follow the steps at
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/
ids_admin_0931.htm and get all the expected messages?
If you check onstat -l on each server which log is marked current with a "C"
on each server?
I have not tried it but at this point you could try setting the seconday back
to standard and then reconnect everything
- onmode -d standard on the secondary
- onmode -d primary sec_name on the primary
- onmode -d secondary prim_name on the secondary
but you may have to re-initialise HDR again.
Regards,
David
> On 16 May 2017 at 09:43 Zanele Masango <masangozanele@gmail.com> wrote:
>
>
> Good Day,
>
> online.log Message from secondary server:
> 10:41:18 DR: Received connection request from remote server when DR is not
> Off
>
> [Local type: Secondary, Current state: ?]
>
> [Remote type: Primary]
>
> On Tue, May 16, 2017 at 10:18 AM, david@smooth1.co.uk <david@smooth1.co.uk>
> wrote:
>
> > What is in the online.log for the secondary server at the same time?
> >
> > Regards,
> > David.
> >
> > > On 16 May 2017 at 06:42 Zanele Masango <masangozanele@gmail.com> wrote:
> > >
> > >
> > > Good Morning,
> > >
> > > Below is the message from online.log file
> > >
> > > 07:41:03 DR_ERR set to -2
> > > 07:41:03 DR: Failure recovery error (2)
> > > 07:41:04 DR: Turned off on primary server
> > > 07:41:04 DR: Cannot connect to secondary server
> > > 07:41:14 DR: Primary server connected
> > > 07:41:14 DR: Send error
> > > 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> > > Network con
> > > nection is broken.
> > >
> > > On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <
> > david@smooth1.co.uk>
> > > wrote:
> > >
> > > > Check the message log (online.log) for the primary, what does it say?
> > > >
> > > > Regards,
> > > > David.
> > > >
> > > > > On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com>
> > wrote:
> > > > >
> > > > >
> > > > > Good Morning,
> > > > >
> > > > > Thank you for your response.
> > > > >
> > > > > But that exactly what I did.
> > > > > On primary:
> > > > >
> > > > > onmode -d primary <secondary name>> > > > >
> > > > > On secondary
> > > > >
> > > > > onmode -d secondary <primary name>> > > > >
> > > > > But secondary state is on and primary state is off please see below:
> > > > >
> > > > > On Primary:
> > > > >
> > > > > Data Replication at c00000010ae49030:
> > > > > Type State Paired server Last DR CKPT (id/pg)
> > > > > Supports Proxy Writes
> > > > > primary off rafdr_hdr 353073 / 19406
> > > > > NA
> > > > >
> > > > > On Secondary
> > > > > Data Replication at c00000010ae49030:
> > > > > Type State Paired server Last DR CKPT (id/pg)
> > > > > Supports Proxy Writes
> > > > > HDR Secondary on rafcsprd_hdr -1 / -1 N
> > > > >
> > > > > Regards
> > > > > Zanele
> > > > >
> > > > > On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com>
> > wrote:
> > > > >
> > > > > > Your onmode -d commands were incorrect. Should be:
> > > > > >
> > > > > > On primary:
> > > > > >
> > > > > > onmode -d primary <secondary name>> > > > > >
> > > > > > On secondary
> > > > > >
> > > > > > onmode -d secondary <primary name>> > > > > >
> > > > > > Art
> > > > > >
> > > > > > Art S. Kagel, President and Principal Consultant
> > > > > > ASK Database Management
> > > > > > www.askdbmgt.com
> > > > > >
> > > > > > Blog: http://informix-myview.blogspot.com/
> > > > > >
> > > > > > Disclaimer: Please keep in mind that my own opinions are my own
> > > > opinions
> > > > > > and do not reflect on the IIUG, nor any other organization with
> > which
> > > > I am
> > > > > > associated either explicitly, implicitly, or by inference. Neither
> > do
> > > > > > those opinions reflect those of other individuals affiliated with
> > any
> > > > > > entity with which I am affiliated nor those of the entities
> > themselves.
> > > > > >
> > > > > > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> > > > masangozanele@gmail.com>
> > > > > > wrote:
> > > > > >
> > > > > > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > > > > > >
> > > > > > > Good evening,
> > > > > > >
> > > > > > > Over the weekend had to switch off replication as patches were
> > being
> > > > > > > applied
> > > > > > > on the DR server. Then on Monday morning ran restore on secondary
> > > > server.
> > > > > > > after running the restore I switch replication on for both
> > primary
> > > > and
> > > > > > > secondary servers, using command onmode -d primary alias name for
> > > > primary
> > > > > > > and
> > > > > > > secondary. The issue at hand is that replication is still OFF on
> > > > primary
> > > > > > > and
> > > > > > > ON secondary. How can put the state of primary to ON again as
> > > > nothing is
> > > > > > > being
> > > > > > > replicated. But the primary server shows that it is a primary
> > > > server. It
> > > > > > is
> > > > > > > just the state of the replication that is off.
> > > > > > >
> > > > > > > Regards
> > > > > > > Zanele
> > > > > > >
> > > > > > >
> > > > > > > ************************************************************
> > > > > > > *******************
> > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > forum.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > ************************************************************
> > > > > > *******************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > ************************************************************
> > > > *******************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > >
> > > >
> > > > ************************************************************
> > > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > >
> > >
> > ************************************************************
> > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Try putting the primary into standard mode then back to primary mode. Once
you have done that try making the secondary a secondary again.
If that doesn't work post the lines from both online.log files from the
time you try that and also post the output from onstat -l from both servers.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Tue, May 16, 2017 at 4:43 AM, Zanele Masango <masangozanele@gmail.com>
wrote:
> Good Day,
>
> online.log Message from secondary server:
> 10:41:18 DR: Received connection request from remote server when DR is not
> Off
>
> [Local type: Secondary, Current state: ?]
>
> [Remote type: Primary]
>
> On Tue, May 16, 2017 at 10:18 AM, david@smooth1.co.uk <david@smooth1.co.uk
> >
> wrote:
>
> > What is in the online.log for the secondary server at the same time?
> >
> > Regards,
> > David.
> >
> > > On 16 May 2017 at 06:42 Zanele Masango <masangozanele@gmail.com>
> wrote:
> > >
> > >
> > > Good Morning,
> > >
> > > Below is the message from online.log file
> > >
> > > 07:41:03 DR_ERR set to -2
> > > 07:41:03 DR: Failure recovery error (2)
> > > 07:41:04 DR: Turned off on primary server
> > > 07:41:04 DR: Cannot connect to secondary server
> > > 07:41:14 DR: Primary server connected
> > > 07:41:14 DR: Send error
> > > 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> > > Network con
> > > nection is broken.
> > >
> > > On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <
> > david@smooth1.co.uk>
> > > wrote:
> > >
> > > > Check the message log (online.log) for the primary, what does it say?
> > > >
> > > > Regards,
> > > > David.
> > > >
> > > > > On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com>
> > wrote:
> > > > >
> > > > >
> > > > > Good Morning,
> > > > >
> > > > > Thank you for your response.
> > > > >
> > > > > But that exactly what I did.
> > > > > On primary:
> > > > >
> > > > > onmode -d primary <secondary name>> > > > >
> > > > > On secondary
> > > > >
> > > > > onmode -d secondary <primary name>> > > > >
> > > > > But secondary state is on and primary state is off please see
> below:
> > > > >
> > > > > On Primary:
> > > > >
> > > > > Data Replication at c00000010ae49030:
> > > > > Type State Paired server Last DR CKPT (id/pg)
> > > > > Supports Proxy Writes
> > > > > primary off rafdr_hdr 353073 / 19406
> > > > > NA
> > > > >
> > > > > On Secondary
> > > > > Data Replication at c00000010ae49030:
> > > > > Type State Paired server Last DR CKPT (id/pg)
> > > > > Supports Proxy Writes
> > > > > HDR Secondary on rafcsprd_hdr -1 / -1 N
> > > > >
> > > > > Regards
> > > > > Zanele
> > > > >
> > > > > On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com>
> > wrote:
> > > > >
> > > > > > Your onmode -d commands were incorrect. Should be:
> > > > > >
> > > > > > On primary:
> > > > > >
> > > > > > onmode -d primary <secondary name>> > > > > >
> > > > > > On secondary
> > > > > >
> > > > > > onmode -d secondary <primary name>> > > > > >
> > > > > > Art
> > > > > >
> > > > > > Art S. Kagel, President and Principal Consultant
> > > > > > ASK Database Management
> > > > > > www.askdbmgt.com
> > > > > >
> > > > > > Blog: http://informix-myview.blogspot.com/
> > > > > >
> > > > > > Disclaimer: Please keep in mind that my own opinions are my own
> > > > opinions
> > > > > > and do not reflect on the IIUG, nor any other organization with
> > which
> > > > I am
> > > > > > associated either explicitly, implicitly, or by inference.
> Neither
> > do
> > > > > > those opinions reflect those of other individuals affiliated with
> > any
> > > > > > entity with which I am affiliated nor those of the entities
> > themselves.
> > > > > >
> > > > > > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> > > > masangozanele@gmail.com>
> > > > > > wrote:
> > > > > >
> > > > > > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > > > > > >
> > > > > > > Good evening,
> > > > > > >
> > > > > > > Over the weekend had to switch off replication as patches were
> > being
> > > > > > > applied
> > > > > > > on the DR server. Then on Monday morning ran restore on
> secondary
> > > > server.
> > > > > > > after running the restore I switch replication on for both
> > primary
> > > > and
> > > > > > > secondary servers, using command onmode -d primary alias name
> for
> > > > primary
> > > > > > > and
> > > > > > > secondary. The issue at hand is that replication is still OFF
> on
> > > > primary
> > > > > > > and
> > > > > > > ON secondary. How can put the state of primary to ON again as
> > > > nothing is
> > > > > > > being
> > > > > > > replicated. But the primary server shows that it is a primary
> > > > server. It
> > > > > > is
> > > > > > > just the state of the replication that is off.
> > > > > > >
> > > > > > > Regards
> > > > > > > Zanele
> > > > > > >
> > > > > > >
> > > > > > > ************************************************************
> > > > > > > *******************
> > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > forum.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > ************************************************************
> > > > > > *******************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > ************************************************************
> > > > *******************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > >
> > > >
> > > > ************************************************************
> > > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > >
> > >
> > ************************************************************
> > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Restart Informix on the secondary
Clive
> On 16 May 2017, at 06:42, ZANELE MASANGO <masangozanele@gmail.com> wrote:
>
> Good Morning,
>
> Below is the message from online.log file
>
> 07:41:03 DR_ERR set to -2
> 07:41:03 DR: Failure recovery error (2)
> 07:41:04 DR: Turned off on primary server
> 07:41:04 DR: Cannot connect to secondary server
> 07:41:14 DR: Primary server connected
> 07:41:14 DR: Send error
> 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> Network con
> nection is broken.
>
> On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <david@smooth1.co.uk>
> wrote:
>
>> Check the message log (online.log) for the primary, what does it say?
>>
>> Regards,
>> David.
>>
>>> On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com> wrote:
>>>
>>>
>>> Good Morning,
>>>
>>> Thank you for your response.
>>>
>>> But that exactly what I did.
>>> On primary:
>>>
>>> onmode -d primary <secondary name>>>>
>>> On secondary
>>>
>>> onmode -d secondary <primary name>>>>
>>> But secondary state is on and primary state is off please see below:
>>>
>>> On Primary:
>>>
>>> Data Replication at c00000010ae49030:
>>> Type State Paired server Last DR CKPT (id/pg)
>>> Supports Proxy Writes
>>> primary off rafdr_hdr 353073 / 19406
>>> NA
>>>
>>> On Secondary
>>> Data Replication at c00000010ae49030:
>>> Type State Paired server Last DR CKPT (id/pg)
>>> Supports Proxy Writes
>>> HDR Secondary on rafcsprd_hdr -1 / -1 N
>>>
>>> Regards
>>> Zanele
>>>
>>> On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com> wrote:
>>>
>>>> Your onmode -d commands were incorrect. Should be:
>>>>
>>>> On primary:
>>>>
>>>> onmode -d primary <secondary name>>>>>
>>>> On secondary
>>>>
>>>> onmode -d secondary <primary name>>>>>
>>>> Art
>>>>
>>>> Art S. Kagel, President and Principal Consultant
>>>> ASK Database Management
>>>> www.askdbmgt.com
>>>>
>>>> Blog: http://informix-myview.blogspot.com/
>>>>
>>>> Disclaimer: Please keep in mind that my own opinions are my own
>> opinions
>>>> and do not reflect on the IIUG, nor any other organization with which
>> I am
>>>> associated either explicitly, implicitly, or by inference. Neither do
>>>> those opinions reflect those of other individuals affiliated with any
>>>> entity with which I am affiliated nor those of the entities themselves.
>>>>
>>>> On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
>> masangozanele@gmail.com>
>>>> wrote:
>>>>
>>>>> Platform Informix 11.70 FC8W1: OS HP-AUX
>>>>>
>>>>> Good evening,
>>>>>
>>>>> Over the weekend had to switch off replication as patches were being
>>>>> applied
>>>>> on the DR server. Then on Monday morning ran restore on secondary
>> server.
>>>>> after running the restore I switch replication on for both primary
>> and
>>>>> secondary servers, using command onmode -d primary alias name for
>> primary
>>>>> and
>>>>> secondary. The issue at hand is that replication is still OFF on
>> primary
>>>>> and
>>>>> ON secondary. How can put the state of primary to ON again as
>> nothing is
>>>>> being
>>>>> replicated. But the primary server shows that it is a primary
>> server. It
>>>> is
>>>>> just the state of the replication that is off.
>>>>>
>>>>> Regards
>>>>> Zanele
>>>>>
>>>>>
>>>>> ************************************************************
>>>>> *******************
>>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>>
>>>>>
>>>>
>>>>
>>>> ************************************************************
>>>> *******************
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>
>>>>
>>>
>>>
>>>
>> ************************************************************
>> *******************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>
>>
>> ************************************************************
>> *******************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Probably the patch you applied has caused a communication issue between the
primary and secondary.
I would test it by: On secondary -- dbaccess sysmaster@primary
(and perhaps, vice versa)
If this doesn't work, then fix your network configurations. As far as for
Informix, you seem to do it correctly.
Let's go GreenThis email contains 100% recycled electrons.
From: Zanele Masango <masangozanele@gmail.com>
To: ids@iiug.org
Sent: Tuesday, May 16, 2017 1:43 AM
Subject: Re: HDR primary state off [39197]
Good Morning,
Below is the message from online.log file
07:41:03 DR_ERR set to -2
07:41:03 DR: Failure recovery error (2)
07:41:04 DR: Turned off on primary server
07:41:04 DR: Cannot connect to secondary server
07:41:14 DR: Primary server connected
07:41:14 DR: Send error
07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
Network con
nection is broken.
On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <david@smooth1.co.uk>
wrote:
> Check the message log (online.log) for the primary, what does it say?
>
> Regards,
> David.
>
> > On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com> wrote:
> >
> >
> > Good Morning,
> >
> > Thank you for your response.
> >
> > But that exactly what I did.
> > On primary:
> >
> > onmode -d primary <secondary name>> >
> > On secondary
> >
> > onmode -d secondary <primary name>> >
> > But secondary state is on and primary state is off please see below:
> >
> > On Primary:
> >
> > Data Replication at c00000010ae49030:
> > Type State Paired server Last DR CKPT (id/pg)
> > Supports Proxy Writes
> > primary off rafdr_hdr 353073 / 19406
> > NA
> >
> > On Secondary
> > Data Replication at c00000010ae49030:
> > Type State Paired server Last DR CKPT (id/pg)
> > Supports Proxy Writes
> > HDR Secondary on rafcsprd_hdr -1 / -1 N
> >
> > Regards
> > Zanele
> >
> > On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com> wrote:
> >
> > > Your onmode -d commands were incorrect. Should be:
> > >
> > > On primary:
> > >
> > > onmode -d primary <secondary name>> > >
> > > On secondary
> > >
> > > onmode -d secondary <primary name>> > >
> > > Art
> > >
> > > Art S. Kagel, President and Principal Consultant
> > > ASK Database Management
> > > www.askdbmgt.com
> > >
> > > Blog: http://informix-myview.blogspot.com/
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > > and do not reflect on the IIUG, nor any other organization with which
> I am
> > > associated either explicitly, implicitly, or by inference. Neither do
> > > those opinions reflect those of other individuals affiliated with any
> > > entity with which I am affiliated nor those of the entities themselves.
> > >
> > > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> masangozanele@gmail.com>
> > > wrote:
> > >
> > > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > > >
> > > > Good evening,
> > > >
> > > > Over the weekend had to switch off replication as patches were being
> > > > applied
> > > > on the DR server. Then on Monday morning ran restore on secondary
> server.
> > > > after running the restore I switch replication on for both primary
> and
> > > > secondary servers, using command onmode -d primary alias name for
> primary
> > > > and
> > > > secondary. The issue at hand is that replication is still OFF on
> primary
> > > > and
> > > > ON secondary. How can put the state of primary to ON again as
> nothing is
> > > > being
> > > > replicated. But the primary server shows that it is a primary
> server. It
> > > is
> > > > just the state of the replication that is off.
> > > >
> > > > Regards
> > > > Zanele
> > > >
> > > >
> > > > ************************************************************
> > > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
> ************************************************************
> *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Zanele:
Are you certain you can connect from one IDS instance to the other and
authenticate?
i.e. Can you run a DBACCESS session on the primary and query the secondary
server and vice versa?
Best regards,
Martin M. Graney
Queues Enforth Development, Inc.
92 Montvale Ave
Suite 4350
Stoneham, MA 02180-3647
781-870-1131
This electronic message contains information which may be privileged,
confidential, or otherwise protected from disclosure. The information
contained herein is intended for the addressee or recipient only. If you are
not the addressee, or not the intended recipient, any disclosure, copying,
distribution, or use of the contents of this message (including any
attachments) is prohibited. If you have received this electronic message in
error, please notify the sender immediately and destroy the original message
and all copies. (Queues Enforth Development, Inc.)
> On May 16, 2017, at 1:37 PM, Clive Eisen <clive@serendipita.com> wrote:
>
> Restart Informix on the secondary
>
> Clive
>
>> On 16 May 2017, at 06:42, ZANELE MASANGO <masangozanele@gmail.com> wrote:
>>
>> Good Morning,
>>
>> Below is the message from online.log file
>>
>> 07:41:03 DR_ERR set to -2
>> 07:41:03 DR: Failure recovery error (2)
>> 07:41:04 DR: Turned off on primary server
>> 07:41:04 DR: Cannot connect to secondary server
>> 07:41:14 DR: Primary server connected
>> 07:41:14 DR: Send error
>> 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
>> Network con
>> nection is broken.
>>
>> On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <david@smooth1.co.uk>
>> wrote:
>>
>>> Check the message log (online.log) for the primary, what does it say?
>>>
>>> Regards,
>>> David.
>>>
>>>> On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com> wrote:
>>>>
>>>>
>>>> Good Morning,
>>>>
>>>> Thank you for your response.
>>>>
>>>> But that exactly what I did.
>>>> On primary:
>>>>
>>>> onmode -d primary <secondary name>>>>>
>>>> On secondary
>>>>
>>>> onmode -d secondary <primary name>>>>>
>>>> But secondary state is on and primary state is off please see below:
>>>>
>>>> On Primary:
>>>>
>>>> Data Replication at c00000010ae49030:
>>>> Type State Paired server Last DR CKPT (id/pg)
>>>> Supports Proxy Writes
>>>> primary off rafdr_hdr 353073 / 19406
>>>> NA
>>>>
>>>> On Secondary
>>>> Data Replication at c00000010ae49030:
>>>> Type State Paired server Last DR CKPT (id/pg)
>>>> Supports Proxy Writes
>>>> HDR Secondary on rafcsprd_hdr -1 / -1 N
>>>>
>>>> Regards
>>>> Zanele
>>>>
>>>>> On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com> wrote:
>>>>>
>>>>> Your onmode -d commands were incorrect. Should be:
>>>>>
>>>>> On primary:
>>>>>
>>>>> onmode -d primary <secondary name>>>>>>
>>>>> On secondary
>>>>>
>>>>> onmode -d secondary <primary name>>>>>>
>>>>> Art
>>>>>
>>>>> Art S. Kagel, President and Principal Consultant
>>>>> ASK Database Management
>>>>> www.askdbmgt.com
>>>>>
>>>>> Blog: http://informix-myview.blogspot.com/
>>>>>
>>>>> Disclaimer: Please keep in mind that my own opinions are my own
>>> opinions
>>>>> and do not reflect on the IIUG, nor any other organization with which
>>> I am
>>>>> associated either explicitly, implicitly, or by inference. Neither do
>>>>> those opinions reflect those of other individuals affiliated with any
>>>>> entity with which I am affiliated nor those of the entities themselves.
>>>>>
>>>>> On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
>>> masangozanele@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Platform Informix 11.70 FC8W1: OS HP-AUX
>>>>>>
>>>>>> Good evening,
>>>>>>
>>>>>> Over the weekend had to switch off replication as patches were being
>>>>>> applied
>>>>>> on the DR server. Then on Monday morning ran restore on secondary
>>> server.
>>>>>> after running the restore I switch replication on for both primary
>>> and
>>>>>> secondary servers, using command onmode -d primary alias name for
>>> primary
>>>>>> and
>>>>>> secondary. The issue at hand is that replication is still OFF on
>>> primary
>>>>>> and
>>>>>> ON secondary. How can put the state of primary to ON again as
>>> nothing is
>>>>>> being
>>>>>> replicated. But the primary server shows that it is a primary
>>> server. It
>>>>> is
>>>>>> just the state of the replication that is off.
>>>>>>
>>>>>> Regards
>>>>>> Zanele
>>>>>>
>>>>>>
>>>>>> ************************************************************
>>>>>> *******************
>>>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> ************************************************************
>>>>> *******************
>>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>> ************************************************************
>>> *******************
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>
>>>
>>>
>>> ************************************************************
>>> *******************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--Apple-Mail-0BF7D9FE-E3DB-4DE4-AC3A-CE37386E3AE0
Not a communication issue
As per the reply to my question:
"Received connection request from remote server when DR is not Off"
The seconday received the connection request.
Regards,
David.
> On 16 May 2017 at 19:21 Kern Doe <kern_doe@yahoo.com> wrote:
>
>
> Probably the patch you applied has caused a communication issue between the
> primary and secondary.
> I would test it by: On secondary -- dbaccess sysmaster@primary
>
> (and perhaps, vice versa)
> If this doesn't work, then fix your network configurations. As far as for
> Informix, you seem to do it correctly.
>
> Let's go GreenThis email contains 100% recycled electrons.
>
> From: Zanele Masango <masangozanele@gmail.com>
> To: ids@iiug.org
> Sent: Tuesday, May 16, 2017 1:43 AM
> Subject: Re: HDR primary state off [39197]
>
> Good Morning,
>
> Below is the message from online.log file
>
> 07:41:03 DR_ERR set to -2
> 07:41:03 DR: Failure recovery error (2)
> 07:41:04 DR: Turned off on primary server
> 07:41:04 DR: Cannot connect to secondary server
> 07:41:14 DR: Primary server connected
> 07:41:14 DR: Send error
> 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> Network con
> nection is broken.
>
> On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <david@smooth1.co.uk>
> wrote:
>
> > Check the message log (online.log) for the primary, what does it say?
> >
> > Regards,
> > David.
> >
> > > On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com> wrote:
> > >
> > >
> > > Good Morning,
> > >
> > > Thank you for your response.
> > >
> > > But that exactly what I did.
> > > On primary:
> > >
> > > onmode -d primary <secondary name>> > >
> > > On secondary
> > >
> > > onmode -d secondary <primary name>> > >
> > > But secondary state is on and primary state is off please see below:
> > >
> > > On Primary:
> > >
> > > Data Replication at c00000010ae49030:
> > > Type State Paired server Last DR CKPT (id/pg)
> > > Supports Proxy Writes
> > > primary off rafdr_hdr 353073 / 19406
> > > NA
> > >
> > > On Secondary
> > > Data Replication at c00000010ae49030:
> > > Type State Paired server Last DR CKPT (id/pg)
> > > Supports Proxy Writes
> > > HDR Secondary on rafcsprd_hdr -1 / -1 N
> > >
> > > Regards
> > > Zanele
> > >
> > > On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com> wrote:
> > >
> > > > Your onmode -d commands were incorrect. Should be:
> > > >
> > > > On primary:
> > > >
> > > > onmode -d primary <secondary name>> > > >
> > > > On secondary
> > > >
> > > > onmode -d secondary <primary name>> > > >
> > > > Art
> > > >
> > > > Art S. Kagel, President and Principal Consultant
> > > > ASK Database Management
> > > > www.askdbmgt.com
> > > >
> > > > Blog: http://informix-myview.blogspot.com/
> > > >
> > > > Disclaimer: Please keep in mind that my own opinions are my own
> > opinions
> > > > and do not reflect on the IIUG, nor any other organization with which
> > I am
> > > > associated either explicitly, implicitly, or by inference. Neither do
> > > > those opinions reflect those of other individuals affiliated with any
> > > > entity with which I am affiliated nor those of the entities themselves.
> > > >
> > > > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> > masangozanele@gmail.com>
> > > > wrote:
> > > >
> > > > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > > > >
> > > > > Good evening,
> > > > >
> > > > > Over the weekend had to switch off replication as patches were being
> > > > > applied
> > > > > on the DR server. Then on Monday morning ran restore on secondary
> > server.
> > > > > after running the restore I switch replication on for both primary
> > and
> > > > > secondary servers, using command onmode -d primary alias name for
> > primary
> > > > > and
> > > > > secondary. The issue at hand is that replication is still OFF on
> > primary
> > > > > and
> > > > > ON secondary. How can put the state of primary to ON again as
> > nothing is
> > > > > being
> > > > > replicated. But the primary server shows that it is a primary
> > server. It
> > > > is
> > > > > just the state of the replication that is off.
> > > > >
> > > > > Regards
> > > > > Zanele
> > > > >
> > > > >
> > > > > ************************************************************
> > > > > *******************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > >
> > > > ************************************************************
> > > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > >
> > >
> > ************************************************************
> > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Not a communication issue
As per the reply to my question:
"Received connection request from remote server when DR is not Off"
The seconday received the connection request.
Regards,
David.
> On 16 May 2017 at 20:01 "Martin M. Graney" <mgraney@qed.com> wrote:
>
>
> Zanele:
>
> Are you certain you can connect from one IDS instance to the other and
> authenticate?
> i.e. Can you run a DBACCESS session on the primary and query the secondary
> server and vice versa?
>
> Best regards,
> Martin M. Graney
> Queues Enforth Development, Inc.
> 92 Montvale Ave
> Suite 4350
> Stoneham, MA 02180-3647
> 781-870-1131
>
> This electronic message contains information which may be privileged,
> confidential, or otherwise protected from disclosure. The information
> contained herein is intended for the addressee or recipient only. If you are
> not the addressee, or not the intended recipient, any disclosure, copying,
> distribution, or use of the contents of this message (including any
> attachments) is prohibited. If you have received this electronic message in
> error, please notify the sender immediately and destroy the original message
> and all copies. (Queues Enforth Development, Inc.)
>
> > On May 16, 2017, at 1:37 PM, Clive Eisen <clive@serendipita.com> wrote:
> >
> > Restart Informix on the secondary
> >
> > Clive
> >
> >> On 16 May 2017, at 06:42, ZANELE MASANGO <masangozanele@gmail.com> wrote:
> >>
> >> Good Morning,
> >>
> >> Below is the message from online.log file
> >>
> >> 07:41:03 DR_ERR set to -2
> >> 07:41:03 DR: Failure recovery error (2)
> >> 07:41:04 DR: Turned off on primary server
> >> 07:41:04 DR: Cannot connect to secondary server
> >> 07:41:14 DR: Primary server connected
> >> 07:41:14 DR: Send error
> >> 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> >> Network con
> >> nection is broken.
> >>
> >> On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <david@smooth1.co.uk>
> >> wrote:
> >>
> >>> Check the message log (online.log) for the primary, what does it say?
> >>>
> >>> Regards,
> >>> David.
> >>>
> >>>> On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com> wrote:
> >>>>
> >>>>
> >>>> Good Morning,
> >>>>
> >>>> Thank you for your response.
> >>>>
> >>>> But that exactly what I did.
> >>>> On primary:
> >>>>
> >>>> onmode -d primary <secondary name>> >>>>
> >>>> On secondary
> >>>>
> >>>> onmode -d secondary <primary name>> >>>>
> >>>> But secondary state is on and primary state is off please see below:
> >>>>
> >>>> On Primary:
> >>>>
> >>>> Data Replication at c00000010ae49030:
> >>>> Type State Paired server Last DR CKPT (id/pg)
> >>>> Supports Proxy Writes
> >>>> primary off rafdr_hdr 353073 / 19406
> >>>> NA
> >>>>
> >>>> On Secondary
> >>>> Data Replication at c00000010ae49030:
> >>>> Type State Paired server Last DR CKPT (id/pg)
> >>>> Supports Proxy Writes
> >>>> HDR Secondary on rafcsprd_hdr -1 / -1 N
> >>>>
> >>>> Regards
> >>>> Zanele
> >>>>
> >>>>> On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com>
wrote:
> >>>>>
> >>>>> Your onmode -d commands were incorrect. Should be:
> >>>>>
> >>>>> On primary:
> >>>>>
> >>>>> onmode -d primary <secondary name>> >>>>>
> >>>>> On secondary
> >>>>>
> >>>>> onmode -d secondary <primary name>> >>>>>
> >>>>> Art
> >>>>>
> >>>>> Art S. Kagel, President and Principal Consultant
> >>>>> ASK Database Management
> >>>>> www.askdbmgt.com
> >>>>>
> >>>>> Blog: http://informix-myview.blogspot.com/
> >>>>>
> >>>>> Disclaimer: Please keep in mind that my own opinions are my own
> >>> opinions
> >>>>> and do not reflect on the IIUG, nor any other organization with which
> >>> I am
> >>>>> associated either explicitly, implicitly, or by inference. Neither do
> >>>>> those opinions reflect those of other individuals affiliated with any
> >>>>> entity with which I am affiliated nor those of the entities themselves.
> >>>>>
> >>>>> On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> >>> masangozanele@gmail.com>
> >>>>> wrote:
> >>>>>
> >>>>>> Platform Informix 11.70 FC8W1: OS HP-AUX
> >>>>>>
> >>>>>> Good evening,
> >>>>>>
> >>>>>> Over the weekend had to switch off replication as patches were being
> >>>>>> applied
> >>>>>> on the DR server. Then on Monday morning ran restore on secondary
> >>> server.
> >>>>>> after running the restore I switch replication on for both primary
> >>> and
> >>>>>> secondary servers, using command onmode -d primary alias name for
> >>> primary
> >>>>>> and
> >>>>>> secondary. The issue at hand is that replication is still OFF on
> >>> primary
> >>>>>> and
> >>>>>> ON secondary. How can put the state of primary to ON again as
> >>> nothing is
> >>>>>> being
> >>>>>> replicated. But the primary server shows that it is a primary
> >>> server. It
> >>>>> is
> >>>>>> just the state of the replication that is off.
> >>>>>>
> >>>>>> Regards
> >>>>>> Zanele
> >>>>>>
> >>>>>>
> >>>>>> ************************************************************
> >>>>>> *******************
> >>>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>> ************************************************************
> >>>>> *******************
> >>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>> ************************************************************
> >>> *******************
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>>
> >>>
> >>>
> >>> ************************************************************
> >>> *******************
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>>
> >>
> >>
> >>
> >
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --Apple-Mail-0BF7D9FE-E3DB-4DE4-AC3A-CE37386E3AE0
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hi Zanele,
Let us know when you have the answers to my questions below.
Regards,
David.
> On 16 May 2017 at 12:29 "david@smooth1.co.uk" <david@smooth1.co.uk> wrote:
>
>
> Hi,
>
> Did you follow the steps at
>
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/
ids_admin_0931.htm
> and get all the expected messages?
>
> If you check onstat -l on each server which log is marked current with a "C"
> on each server?
>
> I have not tried it but at this point you could try setting the seconday back
> to standard and then reconnect everything
>
> - onmode -d standard on the secondary
> - onmode -d primary sec_name on the primary
> - onmode -d secondary prim_name on the secondary
>
> but you may have to re-initialise HDR again.
>
> Regards,
> David
>
> > On 16 May 2017 at 09:43 Zanele Masango <masangozanele@gmail.com> wrote:
> >
> >
> > Good Day,
> >
> > online.log Message from secondary server:
> > 10:41:18 DR: Received connection request from remote server when DR is not
> > Off
> >
> > [Local type: Secondary, Current state: ?]
> >
> > [Remote type: Primary]
> >
> > On Tue, May 16, 2017 at 10:18 AM, david@smooth1.co.uk <david@smooth1.co.uk>
> > wrote:
> >
> > > What is in the online.log for the secondary server at the same time?
> > >
> > > Regards,
> > > David.
> > >
> > > > On 16 May 2017 at 06:42 Zanele Masango <masangozanele@gmail.com> wrote:
> > > >
> > > >
> > > > Good Morning,
> > > >
> > > > Below is the message from online.log file
> > > >
> > > > 07:41:03 DR_ERR set to -2
> > > > 07:41:03 DR: Failure recovery error (2)
> > > > 07:41:04 DR: Turned off on primary server
> > > > 07:41:04 DR: Cannot connect to secondary server
> > > > 07:41:14 DR: Primary server connected
> > > > 07:41:14 DR: Send error
> > > > 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> > > > Network con
> > > > nection is broken.
> > > >
> > > > On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <
> > > david@smooth1.co.uk>
> > > > wrote:
> > > >
> > > > > Check the message log (online.log) for the primary, what does it say?
> > > > >
> > > > > Regards,
> > > > > David.
> > > > >
> > > > > > On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com>
> > > wrote:
> > > > > >
> > > > > >
> > > > > > Good Morning,
> > > > > >
> > > > > > Thank you for your response.
> > > > > >
> > > > > > But that exactly what I did.
> > > > > > On primary:
> > > > > >
> > > > > > onmode -d primary <secondary name>> > > > > >
> > > > > > On secondary
> > > > > >
> > > > > > onmode -d secondary <primary name>> > > > > >
> > > > > > But secondary state is on and primary state is off please see
below:
> > > > > >
> > > > > > On Primary:
> > > > > >
> > > > > > Data Replication at c00000010ae49030:
> > > > > > Type State Paired server Last DR CKPT (id/pg)
> > > > > > Supports Proxy Writes
> > > > > > primary off rafdr_hdr 353073 / 19406
> > > > > > NA
> > > > > >
> > > > > > On Secondary
> > > > > > Data Replication at c00000010ae49030:
> > > > > > Type State Paired server Last DR CKPT (id/pg)
> > > > > > Supports Proxy Writes
> > > > > > HDR Secondary on rafcsprd_hdr -1 / -1 N
> > > > > >
> > > > > > Regards
> > > > > > Zanele
> > > > > >
> > > > > > On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com>
> > > wrote:
> > > > > >
> > > > > > > Your onmode -d commands were incorrect. Should be:
> > > > > > >
> > > > > > > On primary:
> > > > > > >
> > > > > > > onmode -d primary <secondary name>> > > > > > >
> > > > > > > On secondary
> > > > > > >
> > > > > > > onmode -d secondary <primary name>> > > > > > >
> > > > > > > Art
> > > > > > >
> > > > > > > Art S. Kagel, President and Principal Consultant
> > > > > > > ASK Database Management
> > > > > > > www.askdbmgt.com
> > > > > > >
> > > > > > > Blog: http://informix-myview.blogspot.com/
> > > > > > >
> > > > > > > Disclaimer: Please keep in mind that my own opinions are my own
> > > > > opinions
> > > > > > > and do not reflect on the IIUG, nor any other organization with
> > > which
> > > > > I am
> > > > > > > associated either explicitly, implicitly, or by inference.
Neither
> > > do
> > > > > > > those opinions reflect those of other individuals affiliated with
> > > any
> > > > > > > entity with which I am affiliated nor those of the entities
> > > themselves.
> > > > > > >
> > > > > > > On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> > > > > masangozanele@gmail.com>
> > > > > > > wrote:
> > > > > > >
> > > > > > > > Platform Informix 11.70 FC8W1: OS HP-AUX
> > > > > > > >
> > > > > > > > Good evening,
> > > > > > > >
> > > > > > > > Over the weekend had to switch off replication as patches were
> > > being
> > > > > > > > applied
> > > > > > > > on the DR server. Then on Monday morning ran restore on
> secondary
> > > > > server.
> > > > > > > > after running the restore I switch replication on for both
> > > primary
> > > > > and
> > > > > > > > secondary servers, using command onmode -d primary alias name
> for
> > > > > primary
> > > > > > > > and
> > > > > > > > secondary. The issue at hand is that replication is still OFF
on
> > > > > primary
> > > > > > > > and
> > > > > > > > ON secondary. How can put the state of primary to ON again as
> > > > > nothing is
> > > > > > > > being
> > > > > > > > replicated. But the primary server shows that it is a primary
> > > > > server. It
> > > > > > > is
> > > > > > > > just the state of the replication that is off.
> > > > > > > >
> > > > > > > > Regards
> > > > > > > > Zanele
> > > > > > > >
> > > > > > > >
> > > > > > > > ************************************************************
> > > > > > > > *******************
> > > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > > forum.
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > ************************************************************
> > > > > > > *******************
> > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > ************************************************************
> > > > > *******************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > > >
> > > > >
> > > > >
> > > > > ************************************************************
> > > > > *******************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > ************************************************************
> > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > > ********
Hi Guys,
Thank very much for your help. State for HDR for both environment is now
ON.
What I did is. I did a restore again then I stated secondary database with
oninit -D command (to start it without replication) .
Then I executed onclean -ky (clean the segments)
Then oninit -PHY command
Then run the command below.
On primary:
onmode -d primary <secondary name>
On secondary
onmode -d secondary <primary name>
Regards
Zanele
On Tue, May 16, 2017 at 9:01 PM, Martin M. Graney <mgraney@qed.com> wrote:
> Zanele:
>
> Are you certain you can connect from one IDS instance to the other and
> authenticate?
> i.e. Can you run a DBACCESS session on the primary and query the secondary
> server and vice versa?
>
> Best regards,
> Martin M. Graney
> Queues Enforth Development, Inc.
> 92 Montvale Ave
> Suite 4350
> Stoneham, MA 02180-3647
> 781-870-1131
>
> This electronic message contains information which may be privileged,
> confidential, or otherwise protected from disclosure. The information
> contained herein is intended for the addressee or recipient only. If you
> are
> not the addressee, or not the intended recipient, any disclosure, copying,
> distribution, or use of the contents of this message (including any
> attachments) is prohibited. If you have received this electronic message in
> error, please notify the sender immediately and destroy the original
> message
> and all copies. (Queues Enforth Development, Inc.)
>
> > On May 16, 2017, at 1:37 PM, Clive Eisen <clive@serendipita.com> wrote:
> >
> > Restart Informix on the secondary
> >
> > Clive
> >
> >> On 16 May 2017, at 06:42, ZANELE MASANGO <masangozanele@gmail.com>
> wrote:
> >>
> >> Good Morning,
> >>
> >> Below is the message from online.log file
> >>
> >> 07:41:03 DR_ERR set to -2
> >> 07:41:03 DR: Failure recovery error (2)
> >> 07:41:04 DR: Turned off on primary server
> >> 07:41:04 DR: Cannot connect to secondary server
> >> 07:41:14 DR: Primary server connected
> >> 07:41:14 DR: Send error
> >> 07:41:14 dr_prsend thread : asfcode = -25582: oserr = 0: errstr = :
> >> Network con
> >> nection is broken.
> >>
> >> On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <
> david@smooth1.co.uk>
> >> wrote:
> >>
> >>> Check the message log (online.log) for the primary, what does it say?
> >>>
> >>> Regards,
> >>> David.
> >>>
> >>>> On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com>
> wrote:
> >>>>
> >>>>
> >>>> Good Morning,
> >>>>
> >>>> Thank you for your response.
> >>>>
> >>>> But that exactly what I did.
> >>>> On primary:
> >>>>
> >>>> onmode -d primary <secondary name>> >>>>
> >>>> On secondary
> >>>>
> >>>> onmode -d secondary <primary name>> >>>>
> >>>> But secondary state is on and primary state is off please see below:
> >>>>
> >>>> On Primary:
> >>>>
> >>>> Data Replication at c00000010ae49030:
> >>>> Type State Paired server Last DR CKPT (id/pg)
> >>>> Supports Proxy Writes
> >>>> primary off rafdr_hdr 353073 / 19406
> >>>> NA
> >>>>
> >>>> On Secondary
> >>>> Data Replication at c00000010ae49030:
> >>>> Type State Paired server Last DR CKPT (id/pg)
> >>>> Supports Proxy Writes
> >>>> HDR Secondary on rafcsprd_hdr -1 / -1 N
> >>>>
> >>>> Regards
> >>>> Zanele
> >>>>
> >>>>> On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com>
> wrote:
> >>>>>
> >>>>> Your onmode -d commands were incorrect. Should be:
> >>>>>
> >>>>> On primary:
> >>>>>
> >>>>> onmode -d primary <secondary name>> >>>>>
> >>>>> On secondary
> >>>>>
> >>>>> onmode -d secondary <primary name>> >>>>>
> >>>>> Art
> >>>>>
> >>>>> Art S. Kagel, President and Principal Consultant
> >>>>> ASK Database Management
> >>>>> www.askdbmgt.com
> >>>>>
> >>>>> Blog: http://informix-myview.blogspot.com/
> >>>>>
> >>>>> Disclaimer: Please keep in mind that my own opinions are my own
> >>> opinions
> >>>>> and do not reflect on the IIUG, nor any other organization with which
> >>> I am
> >>>>> associated either explicitly, implicitly, or by inference. Neither do
> >>>>> those opinions reflect those of other individuals affiliated with any
> >>>>> entity with which I am affiliated nor those of the entities
> themselves.
> >>>>>
> >>>>> On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <
> >>> masangozanele@gmail.com>
> >>>>> wrote:
> >>>>>
> >>>>>> Platform Informix 11.70 FC8W1: OS HP-AUX
> >>>>>>
> >>>>>> Good evening,
> >>>>>>
> >>>>>> Over the weekend had to switch off replication as patches were being
> >>>>>> applied
> >>>>>> on the DR server. Then on Monday morning ran restore on secondary
> >>> server.
> >>>>>> after running the restore I switch replication on for both primary
> >>> and
> >>>>>> secondary servers, using command onmode -d primary alias name for
> >>> primary
> >>>>>> and
> >>>>>> secondary. The issue at hand is that replication is still OFF on
> >>> primary
> >>>>>> and
> >>>>>> ON secondary. How can put the state of primary to ON again as
> >>> nothing is
> >>>>>> being
> >>>>>> replicated. But the primary server shows that it is a primary
> >>> server. It
> >>>>> is
> >>>>>> just the state of the replication that is off.
> >>>>>>
> >>>>>> Regards
> >>>>>> Zanele
> >>>>>>
> >>>>>>
> >>>>>> ************************************************************
> >>>>>> *******************
> >>>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>> ************************************************************
> >>>>> *******************
> >>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>> ************************************************************
> >>> *******************
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>>
> >>>
> >>>
> >>> ************************************************************
> >>> *******************
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>>
> >>
> >>
> >>
> >
> ************************************************************
> *******************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >
> >
> >
> ************************************************************
> *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --Apple-Mail-0BF7D9FE-E3DB-4DE4-AC3A-CE37386E3AE0
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
For setting up an HDR or RSS secondary server, you'd start with a=20
'physical restore', as opposed to 'a restore' which would be a combined=20
physical and logical restore.
Doing so you'd already land in the state that would allow 'onmode -d=20
secondary', and all of those oninit -D, onclean -ky and oninit -PHY=20
would not be required.
NOT doing so, that is not restricting the restore to a physical only=20
restore, would end in a 'quiescent mode' server state, with at least one=20
checkpoint being conducted independently from opposite (primary) side -=20
which is fatal for HDR. As soon as an (existing or to-be) HDR secondary=20
gets a chance for writing its own, independent checkpoint, you'd have what =
we call split-brain, and the two would not be able to synchronize any=20
more.
Regards,
Andreas
From: "Zanele Masango" <masangozanele@gmail.com>
To: ids@iiug.org
Date: 17.05.2017 10:27
Subject: Re: HDR primary state off [39215]
Sent by: ids-bounces@iiug.org
Hi Guys,=20
Thank very much for your help. State for HDR for both environment is now=20
ON.=20
What I did is. I did a restore again then I stated secondary database with =
oninit -D command (to start it without replication) .=20
Then I executed onclean -ky (clean the segments)=20
Then oninit -PHY command=20
Then run the command below.=20
On primary:=20
onmode -d primary <secondary name>=20
On secondary=20
onmode -d secondary <primary name>=20
Regards=20
Zanele=20
On Tue, May 16, 2017 at 9:01 PM, Martin M. Graney <mgraney@qed.com> wrote: =
> Zanele:=20
>=20
> Are you certain you can connect from one IDS instance to the other and=20
> authenticate?=20
> i.e. Can you run a DBACCESS session on the primary and query the=20
secondary=20
> server and vice versa?=20
>=20
> Best regards,=20
> Martin M. Graney=20
> Queues Enforth Development, Inc.=20
> 92 Montvale Ave=20
> Suite 4350=20
> Stoneham, MA 02180-3647=20
> 781-870-1131=20
>=20
> This electronic message contains information which may be privileged,=20
> confidential, or otherwise protected from disclosure. The information=20
> contained herein is intended for the addressee or recipient only. If you =
> are=20
> not the addressee, or not the intended recipient, any disclosure,=20
copying,=20
> distribution, or use of the contents of this message (including any=20
> attachments) is prohibited. If you have received this electronic message =
in=20
> error, please notify the sender immediately and destroy the original=20
> message=20
> and all copies. (Queues Enforth Development, Inc.)=20
>=20
> > On May 16, 2017, at 1:37 PM, Clive Eisen <clive@serendipita.com>=20
wrote:=20
> >=20
> > Restart Informix on the secondary=20
> >=20
> > Clive=20
> >=20
> >> On 16 May 2017, at 06:42, ZANELE MASANGO <masangozanele@gmail.com>=20
> wrote:=20
> >>=20
> >> Good Morning,=20
> >>=20
> >> Below is the message from online.log file=20
> >>=20
> >> 07:41:03 DR=5FERR set to -2=20
> >> 07:41:03 DR: Failure recovery error (2)=20
> >> 07:41:04 DR: Turned off on primary server=20
> >> 07:41:04 DR: Cannot connect to secondary server=20
> >> 07:41:14 DR: Primary server connected=20
> >> 07:41:14 DR: Send error=20
> >> 07:41:14 dr=5Fprsend thread : asfcode =3D -25582: oserr =3D 0: errstr =
=3D :=20
> >> Network con=20
> >> nection is broken.=20
> >>=20
> >> On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <=20
> david@smooth1.co.uk>=20
> >> wrote:=20
> >>=20
> >>> Check the message log (online.log) for the primary, what does it=20
say?=20
> >>>=20
> >>> Regards,=20
> >>> David.=20
> >>>=20
> >>>> On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com>=20
> wrote:=20
> >>>>=20
> >>>>=20
> >>>> Good Morning,=20
> >>>>=20
> >>>> Thank you for your response.=20
> >>>>=20
> >>>> But that exactly what I did.=20
> >>>> On primary:=20
> >>>>=20
> >>>> onmode -d primary <secondary name>=20
> >>>>=20> >>>> On secondary=20
> >>>>=20
> >>>> onmode -d secondary <primary name>=20
> >>>>=20> >>>> But secondary state is on and primary state is off please see=20
below:=20
> >>>>=20
> >>>> On Primary:=20
> >>>>=20
> >>>> Data Replication at c00000010ae49030:=20
> >>>> Type State Paired server Last DR CKPT (id/pg)=20
> >>>> Supports Proxy Writes=20
> >>>> primary off rafdr=5Fhdr 353073 / 19406=20
> >>>> NA=20
> >>>>=20
> >>>> On Secondary=20
> >>>> Data Replication at c00000010ae49030:=20
> >>>> Type State Paired server Last DR CKPT (id/pg)=20
> >>>> Supports Proxy Writes=20
> >>>> HDR Secondary on rafcsprd=5Fhdr -1 / -1 N=20
> >>>>=20
> >>>> Regards=20
> >>>> Zanele=20
> >>>>=20
> >>>>> On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com>=20
> wrote:=20
> >>>>>=20
> >>>>> Your onmode -d commands were incorrect. Should be:=20
> >>>>>=20
> >>>>> On primary:=20
> >>>>>=20
> >>>>> onmode -d primary <secondary name>=20
> >>>>>=20> >>>>> On secondary=20
> >>>>>=20
> >>>>> onmode -d secondary <primary name>=20
> >>>>>=20
> >>>>> Art=20
> >>>>>=20> >>>>> Art S. Kagel, President and Principal Consultant=20
> >>>>> ASK Database Management=20
> >>>>> www.askdbmgt.com=20
> >>>>>=20
> >>>>> Blog: http://informix-myview.blogspot.com/=20
> >>>>>=20
> >>>>> Disclaimer: Please keep in mind that my own opinions are my own=20
> >>> opinions=20
> >>>>> and do not reflect on the IIUG, nor any other organization with=20
which=20
> >>> I am=20
> >>>>> associated either explicitly, implicitly, or by inference. Neither =
do=20
> >>>>> those opinions reflect those of other individuals affiliated with=20
any=20
> >>>>> entity with which I am affiliated nor those of the entities=20
> themselves.=20
> >>>>>=20
> >>>>> On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <=20
> >>> masangozanele@gmail.com>=20
> >>>>> wrote:=20
> >>>>>=20
> >>>>>> Platform Informix 11.70 FC8W1: OS HP-AUX=20
> >>>>>>=20
> >>>>>> Good evening,=20
> >>>>>>=20
> >>>>>> Over the weekend had to switch off replication as patches were=20
being=20
> >>>>>> applied=20
> >>>>>> on the DR server. Then on Monday morning ran restore on secondary =
> >>> server.=20
> >>>>>> after running the restore I switch replication on for both=20
primary=20
> >>> and=20
> >>>>>> secondary servers, using command onmode -d primary alias name for =
> >>> primary=20
> >>>>>> and=20
> >>>>>> secondary. The issue at hand is that replication is still OFF on=20
> >>> primary=20
> >>>>>> and=20
> >>>>>> ON secondary. How can put the state of primary to ON again as=20
> >>> nothing is=20
> >>>>>> being=20
> >>>>>> replicated. But the primary server shows that it is a primary=20
> >>> server. It=20
> >>>>> is=20
> >>>>>> just the state of the replication that is off.=20
> >>>>>>=20
> >>>>>> Regards=20
> >>>>>> Zanele=20
> >>>>>>=20
> >>>>>>=20
> >>>>>> ************************************************************=
Thank You
On Wed, May 17, 2017 at 3:32 PM, Andreas Legner <andreas.legner@de.ibm.com>
wrote:
> For setting up an HDR or RSS secondary server, you'd start with a=20
> 'physical restore', as opposed to 'a restore' which would be a combined=20
> physical and logical restore.
>
> Doing so you'd already land in the state that would allow 'onmode -d=20
> secondary', and all of those oninit -D, onclean -ky and oninit -PHY=20
> would not be required.
>
> NOT doing so, that is not restricting the restore to a physical only=20
> restore, would end in a 'quiescent mode' server state, with at least one=20
> checkpoint being conducted independently from opposite (primary) side -=20
> which is fatal for HDR. As soon as an (existing or to-be) HDR secondary=20
> gets a chance for writing its own, independent checkpoint, you'd have what
> =
>
> we call split-brain, and the two would not be able to synchronize any=20
> more.
>
> Regards,
> Andreas
>
> From: "Zanele Masango" <masangozanele@gmail.com>
> To: ids@iiug.org
> Date: 17.05.2017 10:27
> Subject: Re: HDR primary state off [39215]
> Sent by: ids-bounces@iiug.org
>
> Hi Guys,=20
>
> Thank very much for your help. State for HDR for both environment is now=20
> ON.=20
>
> What I did is. I did a restore again then I stated secondary database with
> =
>
> oninit -D command (to start it without replication) .=20>
> Then I executed onclean -ky (clean the segments)=20
> Then oninit -PHY command=20
>
> Then run the command below.=20
>
> On primary:=20
>
> onmode -d primary <secondary name>=20>
> On secondary=20
>
> onmode -d secondary <primary name>=20>
> Regards=20
> Zanele=20
>
> On Tue, May 16, 2017 at 9:01 PM, Martin M. Graney <mgraney@qed.com>
> wrote: =
>
> > Zanele:=20
> >=20
> > Are you certain you can connect from one IDS instance to the other and=20
> > authenticate?=20
> > i.e. Can you run a DBACCESS session on the primary and query the=20
> secondary=20
> > server and vice versa?=20
> >=20
> > Best regards,=20
> > Martin M. Graney=20
> > Queues Enforth Development, Inc.=20
> > 92 Montvale Ave=20
> > Suite 4350=20
> > Stoneham, MA 02180-3647=20
> > 781-870-1131=20
> >=20
> > This electronic message contains information which may be privileged,=20
> > confidential, or otherwise protected from disclosure. The information=20
> > contained herein is intended for the addressee or recipient only. If you
> =
>
> > are=20
> > not the addressee, or not the intended recipient, any disclosure,=20
> copying,=20
> > distribution, or use of the contents of this message (including any=20
> > attachments) is prohibited. If you have received this electronic message
> =
>
> in=20
> > error, please notify the sender immediately and destroy the original=20
> > message=20
> > and all copies. (Queues Enforth Development, Inc.)=20
> >=20
> > > On May 16, 2017, at 1:37 PM, Clive Eisen <clive@serendipita.com>=20
> wrote:=20
> > >=20
> > > Restart Informix on the secondary=20
> > >=20
> > > Clive=20
> > >=20
> > >> On 16 May 2017, at 06:42, ZANELE MASANGO <masangozanele@gmail.com>=20
> > wrote:=20
> > >>=20
> > >> Good Morning,=20
> > >>=20
> > >> Below is the message from online.log file=20
> > >>=20
> > >> 07:41:03 DR=5FERR set to -2=20
> > >> 07:41:03 DR: Failure recovery error (2)=20
> > >> 07:41:04 DR: Turned off on primary server=20
> > >> 07:41:04 DR: Cannot connect to secondary server=20
> > >> 07:41:14 DR: Primary server connected=20
> > >> 07:41:14 DR: Send error=20
> > >> 07:41:14 dr=5Fprsend thread : asfcode =3D -25582: oserr =3D 0: errstr
> =
> =3D :=20
> > >> Network con=20
> > >> nection is broken.=20
> > >>=20
> > >> On Tue, May 16, 2017 at 7:38 AM, david@smooth1.co.uk <=20
> > david@smooth1.co.uk>=20
> > >> wrote:=20
> > >>=20
> > >>> Check the message log (online.log) for the primary, what does it=20
> say?=20
> > >>>=20
> > >>> Regards,=20
> > >>> David.=20
> > >>>=20
> > >>>> On 16 May 2017 at 06:30 Zanele Masango <masangozanele@gmail.com>=20
> > wrote:=20
> > >>>>=20
> > >>>>=20
> > >>>> Good Morning,=20
> > >>>>=20
> > >>>> Thank you for your response.=20
> > >>>>=20
> > >>>> But that exactly what I did.=20
> > >>>> On primary:=20
> > >>>>=20
> > >>>> onmode -d primary <secondary name>=20
> > >>>>=20> > >>>> On secondary=20
> > >>>>=20
> > >>>> onmode -d secondary <primary name>=20
> > >>>>=20> > >>>> But secondary state is on and primary state is off please see=20
> below:=20
> > >>>>=20
> > >>>> On Primary:=20
> > >>>>=20
> > >>>> Data Replication at c00000010ae49030:=20
> > >>>> Type State Paired server Last DR CKPT (id/pg)=20
> > >>>> Supports Proxy Writes=20
> > >>>> primary off rafdr=5Fhdr 353073 / 19406=20
> > >>>> NA=20
> > >>>>=20
> > >>>> On Secondary=20
> > >>>> Data Replication at c00000010ae49030:=20
> > >>>> Type State Paired server Last DR CKPT (id/pg)=20
> > >>>> Supports Proxy Writes=20
> > >>>> HDR Secondary on rafcsprd=5Fhdr -1 / -1 N=20
> > >>>>=20
> > >>>> Regards=20
> > >>>> Zanele=20
> > >>>>=20
> > >>>>> On Mon, May 15, 2017 at 10:12 PM, Art Kagel <art.kagel@gmail.com
> >=20
> > wrote:=20
> > >>>>>=20
> > >>>>> Your onmode -d commands were incorrect. Should be:=20
> > >>>>>=20
> > >>>>> On primary:=20
> > >>>>>=20
> > >>>>> onmode -d primary <secondary name>=20
> > >>>>>=20> > >>>>> On secondary=20
> > >>>>>=20
> > >>>>> onmode -d secondary <primary name>=20
> > >>>>>=20
> > >>>>> Art=20
> > >>>>>=20> > >>>>> Art S. Kagel, President and Principal Consultant=20
> > >>>>> ASK Database Management=20
> > >>>>> www.askdbmgt.com=20
> > >>>>>=20
> > >>>>> Blog: http://informix-myview.blogspot.com/=20
> > >>>>>=20
> > >>>>> Disclaimer: Please keep in mind that my own opinions are my own=20
> > >>> opinions=20
> > >>>>> and do not reflect on the IIUG, nor any other organization with=20
> which=20
> > >>> I am=20
> > >>>>> associated either explicitly, implicitly, or by inference. Neither
> =
>
> do=20
> > >>>>> those opinions reflect those of other individuals affiliated
> with=20
> any=20
> > >>>>> entity with which I am affiliated nor those of the entities=20
> > themselves.=20
> > >>>>>=20
> > >>>>> On Mon, May 15, 2017 at 2:56 PM, ZANELE MASANGO <=20
> > >>> masangozanele@gmail.com>=20
> > >>>>> wrote:=20
> > >>>>>=20
> > >>>>>> Platform Informix 11.70 FC8W1: OS HP-AUX=20
> > >>>>>>=20
> > >>>>>> Good evening,=20
> > >>>>>>=20
> > >>>>>> Over the weekend had to switch off replication as patches were=20
> being=20
> > >>>>>> applied=20
> > >>>>>> on the DR server. Then on Monday morning ran restore on secondary
> =
>
> > >>> server.=20
> > >>>>>> after running the restore I switch replication on for both=20
> primary=20
> > >>> and=20
> > >>>>>> secondary servers, using command onmode -d primary alias name for
> =
>
> > >>> primary=20
> > >>>>>> and=20
> > >>>>>> s
Related threads
- System Or Internal Error InterruptedIOException
- 25582 error on high volume of short live trans
- ASF Echo-Thread Server: asfcode = -25582 oserr = 4