Server restores
User performed a full system restore and brought the server online, then realized they needed to apply additional logical logs from production. When attempting to apply logs while the server was in quiescent mode, they received error -27002 (no connections allowed in quiescent mode). The resolution was to shut down the instance first, then perform logical restore.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi All,
I'm cutting my teeth on doing back up and restores. Today I did a full system
restore from or production machine to a new machine we will be using as the
back up after more testing is done. Today I used the command
/opt/informix/bin/onbar r to restore the the server and then it restored the
logical logs. After it was complete I issued the onmode m to bring everything
back on line. After doing this I found out that maybe I shouldn't have brought
it back on-line because tomorrow I need to bring over today's logical logs
from production and apply them to the server. When I found this out I put the
server in quiescent mode with onmode -s. I then went to the production server
to get the oldest log file to see if I could apply it. I issued the command
onbar -r -l and checked the online.log to see what was happening, I found this
error.
15:33:36 listener-thread: err = -27002: oserr = 0: errstr = : No connections ar
e allowed in quiescent mode.
Can anyone tell me the steps I would take to start applying the lattest
logical logs.
Thank you.
During restore the server is in fast recovery stage. Once restore is complete
it goes to quiescent mode.Shutdown the instance and start the logical restore.
From: "JOHN HENRY" <jhenry@gwkinvest.com>
Sent: Fri, 27 Oct 2017 01:39:12 GMT+0530
To: ids@iiug.org
Subject: Server restores [40102]
Hi All,
I'm cutting my teeth on doing back up and restores. Today I did a full system
restore from or production machine to a new machine we will be using as the
back up after more testing is done. Today I used the command
/opt/informix/bin/onbar r to restore the the server and then it restored the
logical logs. After it was complete I issued the onmode m to bring everything
back on line. After doing this I found out that maybe I shouldn't have brought
it back on-line because tomorrow I need to bring over today's logical logs
from production and apply them to the server. When I found this out I put the
server in quiescent mode with onmode -s. I then went to the production server
to get the oldest log file to see if I could apply it. I issued the command
onbar -r -l and checked the online.log to see what was happening, I found this
error.
15:33:36 listener-thread: err = -27002: oserr = 0: errstr = : No
connections
ar
e allowed in quiescent mode.
Can anyone tell me the steps I would take to start applying the lattest
logical logs.
Thank you.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Not going to work. Once a logical restore completed there's no way to get
it to do more logical restore - logically impossible.
What you had wanted probably is 'continuous log restore' which you can feed
new log backups as they become available:
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids_bar_152.htm
From: "JOHN HENRY" <jhenry@gwkinvest.com>
To: ids@iiug.org
Date: 10/26/2017 10:08 PM
Subject: Server restores [40102]
Sent by: ids-bounces@iiug.org
Hi All,
I'm cutting my teeth on doing back up and restores. Today I did a full
system
restore from or production machine to a new machine we will be using as the
back up after more testing is done. Today I used the command
/opt/informix/bin/onbar –r to restore the the server and then it restored
the
logical logs. After it was complete I issued the onmode –m to bring
everything
back on line. After doing this I found out that maybe I shouldn't have
brought
it back on-line because tomorrow I need to bring over today's logical logs
from production and apply them to the server. When I found this out I put
the
server in quiescent mode with onmode -s. I then went to the production
server
to get the oldest log file to see if I could apply it. I issued the command
onbar -r -l and checked the online.log to see what was happening, I foundthis
error.
15:33:36 listener-thread: err = -27002: oserr = 0: errstr = : No
connections
ar
e allowed in quiescent mode.
Can anyone tell me the steps I would take to start applying the lattest
logical logs.
Thank you.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
So nice of you to participate :)
On Fri, Oct 27, 2017 at 9:14 AM, Andreas Legner1 <Andreas.Legner1@de.ibm.com
> wrote:
> Not going to work. Once a logical restore completed there's no way to get
> it to do more logical restore - logically impossible.
>
> What you had wanted probably is 'continuous log restore' which you can feed
> new log backups as they become available:
> https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids_bar_152.htm
>
>
>
> From: "JOHN HENRY" <jhenry@gwkinvest.com>
> To: ids@iiug.org
> Date: 10/26/2017 10:08 PM
> Subject: Server restores [40102]
> Sent by: ids-bounces@iiug.org
>
>
>
> Hi All,
> I'm cutting my teeth on doing back up and restores. Today I did a full
> system
> restore from or production machine to a new machine we will be using as the
>
> back up after more testing is done. Today I used the command
> /opt/informix/bin/onbar –r to restore the the server and then it restored
> the
> logical logs. After it was complete I issued the onmode –m to bring
> everything
> back on line. After doing this I found out that maybe I shouldn't have
> brought
> it back on-line because tomorrow I need to bring over today's logical logs
> from production and apply them to the server. When I found this out I put
> the
> server in quiescent mode with onmode -s. I then went to the production
> server
> to get the oldest log file to see if I could apply it. I issued the command
>
> onbar -r -l and checked the online.log to see what was happening, I found> this
> error.
>
> 15:33:36 listener-thread: err = -27002: oserr = 0: errstr = : No
> connections
> ar
> e allowed in quiescent mode.
>
> Can anyone tell me the steps I would take to start applying the lattest
> logical logs.
>
> Thank you.
>
>
> *******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
hmmmm, had only sent following three lines of text:
Not going to work. Once a logical restore completed there's no way to get
it to do more logical restore - logically impossible.
What you had wanted probably is 'continuous log restore' which you can feed
new log backups as they become available:
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids
_bar_152.htm
From: "Fernando Nunes" <domusonline@gmail.com>
To: ids@iiug.org
Date: 10/27/2017 11:19 AM
Subject: Re: Server restores [40107]
Sent by: ids-bounces@iiug.org
So nice of you to participate :)
On Fri, Oct 27, 2017 at 9:14 AM, Andreas Legner1
<Andreas.Legner1@de.ibm.com
> wrote:
> Not going to work. Once a logical restore completed there's no way to get
> it to do more logical restore - logically impossible.
>
> What you had wanted probably is 'continuous log restore' which you can feed
> new log backups as they become available:
> https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids_bar_152.htm
>
>
>
> From: "JOHN HENRY" <jhenry@gwkinvest.com>
> To: ids@iiug.org
> Date: 10/26/2017 10:08 PM
> Subject: Server restores [40102]
> Sent by: ids-bounces@iiug.org
>
>
>
> Hi All,
> I'm cutting my teeth on doing back up and restores. Today I did a full
> system
> restore from or production machine to a new machine we will be using as the
>
> back up after more testing is done. Today I used the command
> /opt/informix/bin/onbar –r to restore the the server and then it restored
> the
> logical logs. After it was complete I issued the onmode –m to bring
> everything
> back on line. After doing this I found out that maybe I shouldn't have
> brought
> it back on-line because tomorrow I need to bring over today's logical logs
> from production and apply them to the server. When I found this out I put
> the
> server in quiescent mode with onmode -s. I then went to the production
> server
> to get the oldest log file to see if I could apply it. I issued the command
>
> onbar -r -l and checked the online.log to see what was happening, I found> this
> error.
>
> 15:33:36 listener-thread: err = -27002: oserr = 0: errstr = : No
> connections
> ar
> e allowed in quiescent mode.
>
> Can anyone tell me the steps I would take to start applying the lattest
> logical logs.
>
> Thank you.
>
>
> *******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks everyone, i'll look at the link that was just forwarded before I do anything this morning.
Maybe take a look at HDR where the logs are fed automat= ically for you. John =0A =0A =0A-= ------- Original Message -------- =0ASubject: Re: Server restores [4010= 9] =0AFrom: "Andreas Legner1" <[1]Andreas.Legner1@de.ibm.com> =0ADate: Fri, October 27, 201= 7 2:49 am =0ATo: [2]ids@iiug.org =0A= =0Ahmmmm, had only sent following three lines of text: =0A =0ANo= t going to work. Once a logical restore completed there's no way to get =0Ait to do more logical restore - logically impossible. =0A =0AWha= t you had wanted probably is 'continuous log restore' which you can feed =0Anew log backups as they become available: =0A =0A[3]https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.= 0/com.ibm.bar.doc/ids_bar_152.htm =0A =0AFrom: "Fernando Nunes" = <[4]domusonline@gmail.com> = =0ATo: [5]ids@iiug.org =0ADate: 10= /27/2017 11:19 AM =0ASubject: Re: Server restores [40107] =0ASent b= y: [6]ids-bounces@iiug.org =0A= =0ASo nice of you to participate :) =0A =0AOn Fri, Oct 27, 2017 = at 9:14 AM, Andreas Legner1 =0A<[7]Andreas.Legner1@de.ibm.com =0A> wrote: =0A =0A&= gt; Tm90IGdvaW5nIHRvIHdvcmsuICAgT25jZSBhIGxvZ2ljYWwgcmVzdG9yZSBj =0A>= ; b21wbGV0ZWQgdGhl =0A> cmUncyBubyB3YXkgdG8gZ2V0DQppdCB0byBkbyBtb3Jl= IGxvZ2ljYWwgcmVz =0A> dG9yZSAtIGxvZ2lj =0A> YWxseSBpbXBvc3NpY= mxlLg0KDQpXaGF0IHlvdSBoYWQgd2FudGVkIHByb2Jh =0A> Ymx5IGlzICdjb250 =0A> aW51b3VzIGxvZyByZXN0b3JlJyB3aGljaCB5b3UgY2FuIGZlZWQNCm5ldyBs = =0A> b2cgYmFja3VwcyBh =0A> cyB0aGV5IGJlY29tZSBhdmFpbGFibGU6DQpodH= RwczovL3d3dy5pYm0uY29t =0A> L3N1cHBvcnQva25v =0A> d2xlZGdlY2V= udGVyL2VuL1NTR1U4R18xMi4xLjAvY29tLmlibS5iYXIuZG9j =0A> L2lkc19iYXJfM= TUy =0A> Lmh0bQ0KDQoNCg0KRnJvbToJIkpPSE4gSEVOUlkiIDxqaGVucnlAZ3draW5= 2 =0A> ZXN0LmNvbT4NClRv =0A> OglpZHNAaWl1Zy5vcmcNCkRhdGU6CTEw= LzI2LzIwMTcgMTA6MDggUE0NClN1 =0A> YmplY3Q6CVNlcnZl =0A> ciByZ= XN0b3JlcyAgWzQwMTAyXQ0KU2VudCBieToJaWRzLWJvdW5jZXNAaWl1 =0A> Zy5vcmc= NCg0KDQoN =0A> CkhpIEFsbCwNCkknbSBjdXR0aW5nIG15IHRlZXRoIG9uIGRvaW5nI= GJhY2sg =0A> dXAgYW5kIHJlc3Rv =0A> cmVzLiBUb2RheSBJIGRpZCBhIG= Z1bGwNCnN5c3RlbQ0KcmVzdG9yZSBmcm9t =0A> IG9yIHByb2R1Y3Rp =0A>= b24gbWFjaGluZSB0byBhIG5ldyBtYWNoaW5lIHdlIHdpbGwgYmUgdXNpbmcg =0A> Y= XMgdGhlDQoNCmJh =0A> Y2sgdXAgYWZ0ZXIgbW9yZSB0ZXN0aW5nIGlzIGRvbmUuIFR= vZGF5IEkgdXNl =0A> ZCB0aGUgY29tbWFu =0A> ZA0KL29wdC9pbmZvcm1p= eC9iaW4vb25iYXIg4oCTciB0byByZXN0b3JlIHRo =0A> ZSB0aGUgc2VydmVy = =0A> IGFuZCB0aGVuIGl0IHJlc3RvcmVkDQp0aGUNCmxvZ2ljYWwgbG9ncy4gQWZ0 = =0A> ZXIgaXQgd2FzIGNv =0A> bXBsZXRlIEkgaXNzdWVkIHRoZSBvbm1vZGUg4o= CTbSB0byBicmluZw0KZXZl =0A> cnl0aGluZw0KYmFj =0A> ayBvbiBsaW5= lLiBBZnRlciBkb2luZyB0aGlzIEkgZm91bmQgb3V0IHRoYXQg =0A> bWF5YmUgSSBza= G91 =0A> bGRuJ3QgaGF2ZQ0KYnJvdWdodA0KaXQgYmFjayBvbi1saW5lIGJlY2F1c2U= g =0A> dG9tb3Jyb3cgSSBu =0A> ZWVkIHRvIGJyaW5nIG92ZXIgdG9kYXkn= cyBsb2dpY2FsIGxvZ3MNCmZyb20g =0A> cHJvZHVjdGlvbiBh =0A> bmQgY= XBwbHkgdGhlbSB0byB0aGUgc2VydmVyLiBXaGVuIEkgZm91bmQgdGhp =0A> cyBvdXQ= gSSBwdXQN =0A> CnRoZQ0Kc2VydmVyIGluIHF1aWVzY2VudCBtb2RlIHdpdGggb25tb= 2RlIC1z =0A> LiBJIHRoZW4gd2Vu =0A> dCB0byB0aGUgcHJvZHVjdGlvbg= 0Kc2VydmVyDQp0byBnZXQgdGhlIG9sZGVz =0A> dCBsb2cgZmlsZSB0 =0A>= byBzZWUgaWYgSSBjb3VsZCBhcHBseSBpdC4gSSBpc3N1ZWQgdGhlIGNvbW1h =0A> b= mQNCg0Kb25iYXIg =0A> LXIgLWwgYW5kIGNoZWNrZWQgdGhlIG9ubGluZS5sb2cgdG8= gc2VlIHdoYXQg =0A> d2FzIGhhcHBlbmlu =0A> ZywgSSBmb3VuZA0KdGhp= cw0KZXJyb3IuDQoNCjE1OjMzOjM2IGxpc3RlbmVy =0A> LXRocmVhZDogZXJy = =0A> ID0gLTI3MDAyOiBvc2VyciA9IDA6IGVycnN0ciA9IDogTm8NCmNvbm5lY3Rp = =0A> b25zDQphcg0KZSBh =0A> bGxvd2VkIGluIHF1aWVzY2VudCBtb2RlLg0KDQ= pDYW4gYW55b25lIHRlbGwg =0A> bWUgdGhlIHN0ZXBz =0A> IEkgd291bGQ= gdGFrZSB0byBzdGFydCBhcHBseWluZyB0aGUgbGF0dGVzdA0K =0A> bG9naWNhbCBsb= 2dz =0A> Lg0KDQpUaGFuayB5b3UuDQoNCg0KKioqKioqKioqKioqKioqKioqKioqKio= q =0A> KioqKioqKioqKioq =0A> KioqKioqKioqKioqKioqKioqKioqKioq= KioqKioqKioqKioqKioqKioqKg0K =0A> DQogIEZvcnVtIE5v =0A> dGU6I= FVzZSAiUmVwbHkiIHRvIHBvc3QgYSByZXNwb25zZSBpbiB0aGUgZGlz =0A> Y3Vzc2l= vbiBmb3J1 =0A> bS4NCg0KDQo=3D =0A> =0A> =0A> **= ********************************************************** =0A> ****= *************** =0A> Forum Note: Use "Reply" to post a response in t= he discussion forum. =0A> =0A> =0A =0A-- =0AFernan= do Nunes =0APortugal =0A =0A[8]http://informix-technology.blogspot.com =0AMy email= works... but I don't check it frequently... =0A =0A =0A*********= ********************************************************************** = =0A =0AForum Note: Use "Reply" to post a response in the discussion foru= m. =0A =0A =0A***************************************************= **************************** =0A Forum Note: Use "Reply" to post a res= ponse in the discussion forum. =0A =0A=0A =0A References 1. 3D"mailto:Andreas.Legner1@de.i= 2. 3D"mailto:ids@iiug.org" 3. file://localhost/tmp/3D"htt= 4. 3D"mailto:domusonline@gmail.com" 5. 3D"mailto:ids@iiug.org" 6. 3D"mailto:ids-bounces@iiug.org" 7. 3D"mailto:Andreas.Legner1@de= 8. 3D"http://informix-technolog=/