Question on restore using ISM

Posted in 2003

Topics: Backup & Restore, Platform-Specific Issues

Don Cutting — Sat, 25 Jan 2003 22:18:06 — 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_01C2C4BF.693F29E0 Content-Type: text/plain We are running on AIX and IDS Version 7.3.1. We ran a DR test today, where we restored the software from the morning of Jan. 22, 2003, when completed, using the ism_catalog command, we added in the volumes from the back up done the night of the 22nd. When we issues the mount command on the 1st tape, it noted that it was part of the catalog and mounted with no issue. When we tried to restore using onbar -r -w it read the tape and then requested the tape from the 21st. Any suggestions on how we would get ism to accept a tape created after the last software back up? Our normal process it to restore the software and the back up from the same time frame. In this case we wanted to test what would occur if they were different. We used the 21st to complete our test. 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_01C2C4BF.693F29E0 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>Question on restore using ISM</TITLE> </HEAD> <BODY> We are running on AIX and IDS Version = 7.3.1. We ran a DR test today, where we restored the software from the = morning of Jan. 22, 2003, when completed, using the ism_catalog = command, we added in the volumes from the back up done the night of the = 22nd. When we issues the mount command on the 1st tape, it noted that = it was part of the catalog and mounted with no issue. When we tried to = restore using onbar -r -w it read the tape and then requested the tape = from the 21st. Any suggestions on how we would get = ism to accept a tape created after the last software back up? Our = normal process it to restore the software and the back up from the same = time frame. In this case we wanted to test what would occur if they = were different. We used the 21st to complete our test. 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_01C2C4BF.693F29E0--

↪ replying to Don Cutting

Martin Fuerderer — Mon, 27 Jan 2003 08:52:44 — source: IIUG Forums & Mailing Lists

Hi, from your description I'm not quite sure I understood what exactly is your problem. However, I think it could have to do with the following known problem PTS-B 133990. Please read about the problem and the solution (workaround) for it : PTS-B 133990 describes the following problem with the Informix Storage Manager (ISM) Version 2.20.UC1x : The command "ism_catalog -create_bootstrap ..." utilizes the "savegrp" command with the default backup/archive level. This level automatically evaluates to "full" upon first command execution, but thereafter evaluates to an incremental level upon all successive command executions. Therefore the media/volume containing the first bootstrap creation is always necessary in order to restore the bootstrap successfully. Workaround : To avoid the need for the first media/volume during bootstrap restore, a bootstrap backup/archive of level "full" needs to be done every time. To accomplish this, the level must be specified explicitely. This is not possible with the "ism_catalog -create_bootstrap ..." command. Instead, the underlying command "savegrp" must be executed directly. Replace the command "ism_catalog -create_bootstrap ..." with the following : $INFORMIXDIR/bin/savegrp -O -l full ISMData where "-O" is a capital-o (not a zero), "ISMData" is the pool name where the bootstrap data should go, the command must be executed as user "root". E.g. in $INFORMIXDIR/bin/onbar (shell script), this replacement should be done by the Informix Server System Administrator. Also the output (both stdout and stderr) of the "savegrp" command should be redirected to the ON-Bar activity log file (BAR_ACT_LOG parameter from onconfig file). Hope it helps, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "Don Cutting " <dcutting@anderinger.com> Sent by: forum.subscriber@iiug.org 25.01.2003 23:18 To: ids@iiug.org cc: Subject: Question on restore using ISM [113] 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_01C2C4BF.693F29E0 Content-Type: text/plain We are running on AIX and IDS Version 7.3.1. We ran a DR test today, where we restored the software from the morning of Jan. 22, 2003, when completed, using the ism_catalog command, we added in the volumes from the back up done the night of the 22nd. When we issues the mount command on the 1st tape, it noted that it was part of the catalog and mounted with no issue. When we tried to restore using onbar -r -w it read the tape and then requested the tape from the 21st. Any suggestions on how we would get ism to accept a tape created after the last software back up? Our normal process it to restore the software and the back up from the same time frame. In this case we wanted to test what would occur if they were different. We used the 21st to complete our test. 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_01C2C4BF.693F29E0 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>Question on restore using ISM</TITLE> </HEAD> <BODY> We are running on AIX and IDS Version = 7.3.1. We ran a DR test today, where we restored the software from the = morning of Jan. 22, 2003, when completed, using the ism_catalog = command, we added in the volumes from the back up done the night of the = 22nd. When we issues the mount command on the 1st tape, it noted that = it was part of the catalog and mounted with no issue. When we tried to = restore using onbar -r -w it read the tape and then requested the tape = from the 21st. Any suggestions on how we would get = ism to accept a tape created after the last software back up? Our = normal process it to restore the software and the back up from the same = time frame. In this case we wanted to test what would occur if they = were different. We used the 21st to complete our test. 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_01C2C4BF.693F29E0--

↪ replying to Don Cutting

NormaJean.Sebastian@tellabs.com — Mon, 27 Jan 2003 14:56:25 — source: IIUG Forums & Mailing Lists

--MIRAPOINT_PART1_3e3547f6 Content-Type: multipart/alternative; boundary=openmail-part-3891b570-00000002 --openmail-part-3891b570-00000002 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline ;Creation-Date="Mon, 27 Jan 2003 08:53:40 -0600" Content-Transfer-Encoding: 8bit Donald, you didn't mention the ixbar.1 file. When doing a cold restore, Informix has no system catalogs to look at, it looks at ixbar.1 Norma Jean -----Original Message----- From: dcutting@anderinger.com [mailto:dcutting@anderinger.com] Sent: Saturday, January 25, 2003 4:18 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Question on restore using ISM [113] 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_01C2C4BF.693F29E0 Content-Type: text/plain We are running on AIX and IDS Version 7.3.1. We ran a DR test today, where we restored the software from the morning of Jan. 22, 2003, when completed, using the ism_catalog command, we added in the volumes from the back up done the night of the 22nd. When we issues the mount command on the 1st tape, it noted that it was part of the catalog and mounted with no issue. When we tried to restore using onbar -r -w it read the tape and then requested the tape from the 21st. Any suggestions on how we would get ism to accept a tape created after the last software back up? Our normal process it to restore the software and the back up from the same time frame. In this case we wanted to test what would occur if they were different. We used the 21st to complete our test. 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_01C2C4BF.693F29E0 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>Question on restore using ISM</TITLE> </HEAD> <BODY> We are running on AIX and IDS Version = 7.3.1. We ran a DR test today, where we restored the software from the = morning of Jan. 22, 2003, when completed, using the ism_catalog = command, we added in the volumes from the back up done the night of the = 22nd. When we issues the mount command on the 1st tape, it noted that = it was part of the catalog and mounted with no issue. When we tried to = restore using onbar -r -w it read the tape and then requested the tape = from the 21st. Any suggestions on how we would get = ism to accept a tape created after the last software back up? Our = normal process it to restore the software and the back up from the same = time frame. In this case we wanted to test what would occur if they = were different. We used the 21st to complete our test. 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_01C2C4BF.693F29E0-- --openmail-part-3891b570-00000002 Content-Type: application/rtf Content-Disposition: attachment; filename="BDY.RTF" ;Creation-Date="Mon, 27 Jan 2003 08:53:40 -0600" Content-Transfer-Encoding: base64 {\\rtf1\\ansi\\ansicpg1252\\fromtext \\deff0{\\fonttbl {\\f0\\fswiss Arial;} {\\f1\\fmodern Courier New;} {\\f2\\fnil\\fcharset2 Symbol;} {\\f3\\fmodern\\fcharset0 Courier New;}} {\\colortbl\\red0\\green0\\blue0;\\red0\\green0\\blue255;} \\uc1\\pard\\plain\\deftab360 \\f0\\fs20 Donald,\\par you didn't mention the ixbar.1 file. When doing a cold restore, Informix has no system catalogs to look at, it looks at ixbar.1\\par Norma Jean\\par \\par -----Original Message-----\\par From: dcutting@anderinger.com [mailto:dcutting@anderinger.com]\\par Sent: Saturday, January 25, 2003 4:18 PM\\par To: ids@iiug.org; forum.subscriber@iiug.org\\par Subject: Question on restore using ISM [113]\\par \\par \\par This message is in MIME format. Since your mail reader does not understand\\par this format, some or all of this message may not be legible.\\par \\par ------_=_NextPart_001_01C2C4BF.693F29E0\\par Content-Type: text/plain\\par \\par \\par We are running on AIX and IDS Version 7.3.1. We ran a DR test today, where\\par we restored the software from the morning of Jan. 22, 2003, when completed,\\par using the ism_catalog command, we added in the volumes from the back up done\\par the night of the 22nd. When we issues the mount command on the 1st tape, it\\par noted that it was part of the catalog and mounted with no issue. When we\\par tried to restore using onbar -r -w it read the tape and then requested the\\par tape from the 21st. \\par \\par Any suggestions on how we would get ism to accept a tape created after the\\par last software back up? Our normal process it to restore the software and the\\par back up from the same time frame. In this case we wanted to test what would\\par occur if they were different. We used the 21st to complete our test. \\par \\par Thanks\\par \\par Donald H. Cutting\\par A. N. Deringer, Inc. \\par Systems Analyst / D.B.A.\\par Tel : 802-524-8172\\par Fax: 802-524-8297\\par www.anderinger.com\\par \\par \\par ------_=_NextPart_001_01C2C4BF.693F29E0\\par Content-Type: text/html\\par Content-Transfer-Encoding: quoted-printable\\par \\par <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">\\par <HTML>\\par <HEAD>\\par <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =\\par charset=3DUS-ASCII">\\par <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =\\par 5.5.2653.12">\\par <TITLE>Question on restore using ISM</TITLE>\\par </H

↪ replying to NormaJean.Sebastian@tellabs.com

vivek.chaudhary@st.com — Mon, 27 Jan 2003 16:58:44 — source: IIUG Forums & Mailing Lists

I concur with Norma. ISM looks at ixbar.<serverid> file. While backing up, this is the most important file. I could suggest some file massaging ideas but they are dangerous if not done properly. If you have ixbar file from that day then restore it on the DRS and then verify if your savesets from ixbar file matches with the files on the system. Vivek > -----Original Message----- > From: NormaJean.Sebastian [mailto:NormaJean.Sebastian@tellabs.com] > Sent: Monday, January 27, 2003 7:56 AM > To: ids; forum.subscriber; NormaJean.Sebastian > Subject: RE: Question on restore using ISM [127] > > > > --MIRAPOINT_PART1_3e3547f6 > Content-Type: multipart/alternative; > boundary=openmail-part-3891b570-00000002 > > --openmail-part-3891b570-00000002 > Content-Type: text/plain; charset=ISO-8859-1 > Content-Disposition: inline > ;Creation-Date="Mon, 27 Jan 2003 08:53:40 -0600" > Content-Transfer-Encoding: 8bit > > Donald, > you didn't mention the ixbar.1 file. When doing a cold restore, > Informix has no system catalogs to look at, it looks at ixbar.1 > Norma Jean > > -----Original Message----- > From: dcutting@anderinger.com [mailto:dcutting@anderinger.com] > Sent: Saturday, January 25, 2003 4:18 PM > To: ids@iiug.org; forum.subscriber@iiug.org > Subject: Question on restore using ISM [113] > > > 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_01C2C4BF.693F29E0 > Content-Type: text/plain > > > We are running on AIX and IDS Version 7.3.1. We ran a DR test today, > where > we restored the software from the morning of Jan. 22, 2003, when > completed, > using the ism_catalog command, we added in the volumes from > the back up > done > the night of the 22nd. When we issues the mount command on > the 1st tape, > it > noted that it was part of the catalog and mounted with no > issue. When we > tried to restore using onbar -r -w it read the tape and then requested > the > tape from the 21st. > > Any suggestions on how we would get ism to accept a tape created after > the > last software back up? Our normal process it to restore the > software and > the > back up from the same time frame. In this case we wanted to test what > would > occur if they were different. We used the 21st to complete our test. > > 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_01C2C4BF.693F29E0 > 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>Question on restore using ISM</TITLE> > </HEAD> > <BODY> > > > We are running on AIX and > IDS Version = > 7.3.1. We ran a DR test today, where we restored the software > from the = > morning of Jan. 22, 2003, when completed, using the ism_catalog = > command, we added in the volumes from the back up done the > night of the > = > 22nd. When we issues the mount command on the 1st tape, it > noted that = > it was part of the catalog and mounted with no issue. When we > tried to = > restore using onbar -r -w it read the tape and then requested > the tape = > from the 21st. > > Any suggestions on how we would get = > ism to accept a tape created after the last software back up? Our = > normal process it to restore the software and the back up > from the same > = > time frame. In this case we wanted to test what would occur if they = > were different. We used the 21st to complete our test. > > 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_01C2C4BF.693F29E0-- > > > > --openmail-part-3891b570-00000002 > Content-Type: application/rtf > Content-Disposition: attachment; filename="BDY.RTF" > ;Creation-Date="Mon, 27 Jan 2003 08:53:40 -0600" > Content-Transfer-Encoding: base64 > > {\\rtf1\\ansi\\ansicpg1252\\fromtext \\deff0{\\fonttbl > {\\f0\\fswiss Arial;} > {\\f1\\fmodern Courier New;} > {\\f2\\fnil\\fcharset2 Symbol;} > {\\f3\\fmodern\\fcharset0 Courier New;}} > {\\colortbl\\red0\\green0\\blue0;\\red0\\green0\\blue255;} > \\uc1\\pard\\plain\\deftab360 \\f0\\fs20 Donald,\\par > you didn't mention the ixbar.1 file. When doing a cold restore, Informix has no system catalogs to look at, it looks at ixbar.1\\par > Norma Jean\\par > \\par > -----Original Message-----\\par > From: dcutting@anderinger.com [mailto:dcutting@anderinger.com]\\par > Sent: Saturday, January 25, 2003 4:18 PM\\par > To: ids@iiug.org; forum.subscriber@iiug.org\\par > Subject: Question on restore using ISM [113]\\par > \\par > \\par > This message is in MIME format. Since your mail reader does not understand\\par > this format, some or all of this message may not be legible.\\par > \\par > ------_=_NextPart_001_01C2C4BF.693F29E0\\par > Content-Type: text/plain\\par > \\par > \\par > We are running on AIX and IDS Version 7.3.1. We ran a DR test today, where\\par > we restored the software from the morning of Jan. 22, 2003, when completed,\\par > using the ism_catalog command, we added in the volumes from the back up done\\par > the night of the 22nd. When we issues the mount command on the 1st tape, it\\par > noted that it was part of the catalog and mounted with no issue. When we\\par > tried to restore using onbar -r -w it read the tape and then requested the\\par > tape from the 21st. \\par > \\par > Any suggestions on how we would get ism to accept a t

Question on restore using ISM

Related threads

Glossary

Your privacy choices