Restoration stuck in the middle... help required

I was restoring the entire informix database 7.13 on hp-UNIX 10.01. My level 0 backup is on different mount points. So I have pointed the first tape mount point in the IDS onconfig file and the restore was restarted. TAPEDEV /BACKUP/BKUP01/bkf.1.091101 Now it is asking for second tape in the occurence and when I am trying to specify second tape, by modifying the onconfig it is still referring to the first tape and it is not accepting tape 2. How I can force ontape to read the second tape from command line or read it from the onconfig file. Please help. see below. Please mount tape 2 on /BACKUP/BKUP01/bkf.1.091101 and press Return to continue ... Tape sequence number is 1, expecting 2 Bad tape.

You can't change the onconfig to point at the next file in sequence, you have to change the filename of the next file (or create a link) to match what's already in the onconfig. That's why a few weeks ago I suggested that you use a fake filename in your onconfig to make moving the files around easier. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > DEEPAK JOSHI > Sent: Monday, November 02, 2009 3:36 PM > To: ids@iiug.org > Subject: Restoration stuck in the middle... help required [17875] > > I was restoring the entire informix database 7.13 on hp-UNIX 10.01. > > My level 0 backup is on different mount points. So I have pointed the > first > tape mount point in the IDS onconfig file and the restore was > restarted. > > TAPEDEV /BACKUP/BKUP01/bkf.1.091101 > > Now it is asking for second tape in the occurence and when I am trying > to > specify second tape, by modifying the onconfig it is still referring to > the > first tape and it is not accepting tape 2. > > How I can force ontape to read the second tape from command line or > read it > from the onconfig file. Please help. > > see below. > > Please mount tape 2 on /BACKUP/BKUP01/bkf.1.091101 and press Return to > continue ... > Tape sequence number is 1, expecting 2 > > Bad tape. > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

You cannot. You will need to set TAPEDEV to a symbolic link that you change to point to each mount point as ontape prompts for each successive tape. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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, Nov 2, 2009 at 4:35 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote: > I was restoring the entire informix database 7.13 on hp-UNIX 10.01. > > My level 0 backup is on different mount points. So I have pointed the first > tape mount point in the IDS onconfig file and the restore was restarted. > > TAPEDEV /BACKUP/BKUP01/bkf.1.091101 > > Now it is asking for second tape in the occurence and when I am trying to > specify second tape, by modifying the onconfig it is still referring to the > first tape and it is not accepting tape 2. > > How I can force ontape to read the second tape from command line or read it > from the onconfig file. Please help. > > see below. > > Please mount tape 2 on /BACKUP/BKUP01/bkf.1.091101 and press Return to > continue ... > Tape sequence number is 1, expecting 2 > > Bad tape. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747b488591e5304776b15ee

You can not change TAPEDEV in the middle of the restore. The solution is to rename tape1 and link tape2 to the old tape1 name, like this: mv /BACKUP/BKUP01/bkf.1.091101 /BACKUP/BKUP01/bkf.1.091101_OLD ln -s <your_tape2_path> /BACKUP/BKUP01/bkf.1.091101 If you have more than two tapes... repeat for each one. Best regards, Javier Gómez IT Specialist Information Management Services - IBM Software Group C/ Santa Hortensia 26-28 28002 Madrid Tlf: 91 397 66 11 Fax: 91 519 39 87 From: "DEEPAK JOSHI" <djoshih@hotmail.com> To: ids@iiug.org Date: 02.11.2009 22:37 Subject: Restoration stuck in the middle... help required [17875] Sent by: ids-bounces@iiug.org I was restoring the entire informix database 7.13 on hp-UNIX 10.01. My level 0 backup is on different mount points. So I have pointed the first tape mount point in the IDS onconfig file and the restore was restarted. TAPEDEV /BACKUP/BKUP01/bkf.1.091101 Now it is asking for second tape in the occurence and when I am trying to specify second tape, by modifying the onconfig it is still referring to the first tape and it is not accepting tape 2. How I can force ontape to read the second tape from command line or read it from the onconfig file. Please help. see below. Please mount tape 2 on /BACKUP/BKUP01/bkf.1.091101 and press Return to continue ... Tape sequence number is 1, expecting 2 Bad tape. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. Salvo indicado de otro modo más arriba / Unless stated otherwise above: International Business Machines, S.A. Santa Hortensia, 26-28, 28002 Madrid Registro Mercantil de Madrid; Folio 1; Tomo 1525; Hoja M-28146 CIF A28-010791

> I was restoring the entire informix database 7.13 on hp-UNIX 10.01. > > My level 0 backup is on different mount points. So I have pointed the first > tape mount point in the IDS onconfig file and the restore was restarted. > another reason to steer clear of archives to disk. Tell me, what recovery would be possible if the machine burns down, or the disks explode in a puff of binary digits? The lesson here is, be conservative, sensible and by the book when taking archives. They ain't a joke anyway, move the completed file to another name, and move the next file into place on the first name. But that's already been said a few times now. --Boundary-00=_1+K8KvpC8vxz2Bo