Informix 7.3 restore question.

Posted in 2003

Topics: Backup & Restore, Storage & Space Management

Don Cutting — Tue, 21 Jan 2003 19:46:58 — source: IIUG Forums & Mailing Lists

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2C185.A2CB0360 Content-Type: text/plain We are testing our restore on our DR system. We use onbar and used onbar -r -w for the restore option. When we try to bring the server online, it errors out noting it can find the two dbspaces which are marked as temp. We know that temp dbspaces do not restore, the chunks were created on the DR system, but for some reason the informix server is not seeing them. We have done this before and not had this issue. Any thoughts on why this might be occuring? We are going to recreate the chunks and see if that helps. Thanks Donald H. Cutting A. N. Deringer, Inc. Systems Analyst / D.B.A. Tel : 802-524-8172 Fax: 802-524-8297 www.anderinger.com ------_=_NextPart_001_01C2C185.A2CB0360 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>Informix 7.3 restore question.</TITLE> </HEAD> <BODY> We are testing our restore on our DR = system. We use onbar and used onbar -r -w for the restore option. When = we try to bring the server online, it errors out noting it can find the = two dbspaces which are marked as temp. We know that temp dbspaces do = not restore, the chunks were created on the DR system, but for some = reason the informix server is not seeing them. We have done this before = and not had this issue. Any thoughts on why this might be = occuring? We are going to recreate the chunks and see if that = helps. Thanks Donald H. Cutting A. N. Deringer, Inc. Systems Analyst / D.B.A. Tel : 802-524-8172 Fax: 802-524-8297 www.anderinger.com </BODY> </HTML> ------_=_NextPart_001_01C2C185.A2CB0360--

↪ replying to Don Cutting

Martin Fuerderer — Wed, 22 Jan 2003 14:50:09 — source: IIUG Forums & Mailing Lists

Hi, this should not happen. Temp dbspaces that existed BEFORE the archive was done should (automatically) be re-created during/after the restore. They are re-created and not restored (since they are not archived). I admit that I didn't try out this scenario with a whole-system archive and restore in 7.3 for quite some time. I don't think that this is a known problem, at least I can't find any. Any error message about these temp dbspaces in either online.log or in bar_act.log file ? There could be a hint as to why this happened ... [ Path names must be exactly the same on system to be restored. Chunk files must exist prior to starting the restore, owner/group both "informix", access rights -rw-rw---- (660). I assume you've got these things right ... ] In case all this doesn't help/work, more information is needed : - "onstat -d" output of archived system, - ls -l of chunks pathnames on restore system, - log files of the "critical times" during archive and restore, - exact version (oninit -V), - OS name / version. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "Don Cutting " <dcutting@anderinger.com> Sent by: forum.subscriber@iiug.org 21.01.2003 20:46 To: ids@iiug.org cc: Subject: Informix 7.3 restore question. [62] We are testing our restore on our DR system. We use onbar and used onbar -r -w for the restore option. When we try to bring the server online, it errors out noting it can find the two dbspaces which are marked as temp. We know that temp dbspaces do not restore, the chunks were created on the DR system, but for some reason the informix server is not seeing them. We have done this before and not had this issue. Any thoughts on why this might be occuring? We are going to recreate the chunks and see if that helps. Thanks Donald H. Cutting A. N. Deringer, Inc. Systems Analyst / D.B.A. Tel : 802-524-8172 Fax: 802-524-8297 www.anderinger.com

↪ replying to Don Cutting

Don Cutting — Wed, 22 Jan 2003 15:03:41 — source: IIUG Forums & Mailing Lists

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2C227.37845E10 Content-Type: text/plain Martin, Thanks for the information. We contacted IBM Informix support and they pretty much noted the same. We checked a number of things and everything looked fine - no errors in our logs and the restore log noted that all spaces were restored with no errors. We made the call to refresh the DR system at the AIX level and tried the restore again, and this time it worked fine. Our system staff is now in the process of checking to see what was done different between the two times they loaded the AIX level software. We had a staff change in that area, so we are expecting that something in the DR document was not followed. Again, thank you for your response and have a good day! Thanks! Donald H. Cutting A. N. Deringer, Inc. Systems Analyst / D.B.A. Tel : 802-524-8172 Fax: 802-524-8297 www.anderinger.com > -----Original Message----- > From: Martin Fuerderer [SMTP:martinfu@de.ibm.com] > Sent: Wednesday, January 22, 2003 9:46 AM > To: Don Cutting > Cc: forum.subscriber@iiug.org; ids@iiug.org > Subject: Re: Informix 7.3 restore question. [62] > > Hi, > > this should not happen. > Temp dbspaces that existed BEFORE the archive was done > should (automatically) be re-created during/after the restore. > They are re-created and not restored (since they are not archived). > > I admit that I didn't try out this scenario with a whole-system > archive and restore in 7.3 for quite some time. I don't think > that this is a known problem, at least I can't find any. > > Any error message about these temp dbspaces in either online.log > or in bar_act.log file ? There could be a hint as to why this happened ... > > [ Path names must be exactly the same on system to be restored. > Chunk files must exist prior to starting the restore, owner/group both > "informix", access rights -rw-rw---- (660). I assume you've got these > things right ... ] > > In case all this doesn't help/work, more information is needed : > - "onstat -d" output of archived system, > - ls -l of chunks pathnames on restore system, > - log files of the "critical times" during archive and restore, > - exact version (oninit -V), > - OS name / version. > > Regards, > Martin > -- > Martin Fuerderer > IBM Informix Development Munich > Data Management Solutions > > > > > > "Don Cutting " <dcutting@anderinger.com> > Sent by: forum.subscriber@iiug.org > 21.01.2003 20:46 > > To: ids@iiug.org > cc: > Subject: Informix 7.3 restore question. [62] > > > > > We are testing our restore on our DR system. We use onbar and used onbar > -r > -w for the restore option. When we try to bring the server online, it > errors > out noting it can find the two dbspaces which are marked as temp. We know > that temp dbspaces do not restore, the chunks were created on the DR > system, > but for some reason the informix server is not seeing them. We have done > this before and not had this issue. > > Any thoughts on why this might be occuring? We are going to recreate the > chunks and see if that helps. > > Thanks > > Donald H. Cutting > A. N. Deringer, Inc. > Systems Analyst / D.B.A. > Tel : 802-524-8172 > Fax: 802-524-8297 > www.anderinger.com ------_=_NextPart_001_01C2C227.37845E10 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: Informix 7.3 restore question. [62]</TITLE> </HEAD> <BODY> Martin,         Thanks for the information. We contacted IBM = Informix support and they pretty much noted the same. We checked a = number of things and everything looked fine - no errors in our logs and = the restore log noted that all spaces were restored with no errors. We = made the call to  refresh  the DR system = at the AIX level and tried the restore again, and this time it worked = fine. Our system staff is now in the process of checking to see what = was done different between the two times they loaded the AIX level = software. We had a staff change in that area, so we are expecting that = something in the DR document was not followed.         Again, thank you for your response and have a = good day! Thanks!        =20        =20 Donald H. Cutting A. N. Deringer, Inc. Systems Analyst / D.B.A. Tel : 802-524-8172 Fax: 802-524-8297 www.anderinger.com <UL> -----Original Message----- From:   Martin Fuerderer = [SMTP:martinfu@de.ibm.com] Sent:   Wednesday, January 22, 2003 9:46 AM To:     Don Cutting Cc:     forum.subscriber@iiug.org; ids@iiug.org Subject:       = Re: Informix 7.3 restore question. = [62] Hi, this should not happen. Temp dbspaces that existed BEFORE the = archive was done should (automatically) be re-created = during/after the restore. <FONT SIZE=3D2 FACE=3D"Arial@@D

Informix 7.3 restore question.

Related threads

Glossary

Your privacy choices