IDS Forum

IDS 7.31/SunOS 5.7 ontape restore problem

Posted By: MARSHALL HAHN-TAYLOR
Date: Wednesday, 6 January 2010, at 2:26 p.m.

Hello and Happy 2010!

On Xmas eve 2009 one of the disks on a server that I admin went offline,
taking with it an Informix database that is much missed. First I
re-initialized the database chunks by executing the following:

touch mytest_db1
touch mytest_db2
touch mytest_db3
chmod 660 mydb*
onspaces -c -d mytestdb -p /mytest_db1 -o 0 -s 2000000
onspaces -a mytestdb -p /mytest_db2 -o 0 -s 2000000
onspaces -a mytestdb -p /mytest_db3 -o 0 -s 2000000

I made sure that the chunk size matched the chunk size of the missing
chunks (2 GB). I've read some posts on the net that say that one need
not create the chunks, merely touch the files and set the correct 660
permissions. I didn't know what to believe, so I made the chunks.

Then I snapped the database symlinks for my missing databases (mytestdb)
to above newly created chunks. My understanding is that only the symlink
paths needs to stay the same, not the target to which the links point.

I then attempted cold restoring from the last known good 8mm Exabyte tape backup
for our database.

mt -f /dev/rmt/0cbn rewind
onmode -yuck
ontape -r

Archive Tape Information

Tape type: Archive Backup Tape
Online version: Informix Dynamic Server Version 7.31.UC4
Archive date: Wed Jun 27 12:31:22 2007
User id: informix
Terminal id: /dev/pts/4
Archive level: 0
Tape device: /dev/rmt/0cbn
Tape blocksize (in k): 1024
Tape size (in k): 138240000
Tape number in series: 1

Spaces to restore:1 [rootdbs ]
2 [livedb ]
3 [testdb ]
4 [traindb ]
5 [llogdbs ]

Archive Information

Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
Initialization Time 10/25/2003 00:28:45
System Page Size 2048
Version 6
Archive CheckPoint Time 06/27/2007 12:31:26
paces
number flags fchunk nchunks flags owner name
1 1 1 1 N informix rootdbs
2 1 2 16 N informix mydb
5 1 5 1 N informix llogdbs
6 2001 6 1 N T informix tempdb
7 2001 7 1 N T informix tempdb2
8 2001 26 1 N T informix tempdb3

Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 400000 333479 PO- /dblnk/live/my_root
2 2 0 1000000 13 PO- /dblnk/live/my_db1
3 3 0 1000000 13 PO- /dblnk/test/mytest_db1
4 4 0 1000000 65217 PO- /dblnk/train/mytrain_db1
5 5 0 700100 47 PO- /dblnk/llog/my_llogs
6 6 0 500000 499497 PO- /dblnk/live/my_temp1
7 7 0 500000 499497 PO- /dblnk/live/my_temp2
8 2 0 1000000 395348 PO- /dblnk/live/my_db2
9 2 0 1000000 15 PO- /dblnk/live/my_db3
10 2 0 1000000 3 PO- /dblnk/live/my_db4
11 2 0 1000000 59 PO- /dblnk/live/my_db5
12 2 0 1000000 8 PO- /dblnk/live/my_db6
13 4 0 1000000 869947 PO- /dblnk/train/mytrain_db2
14 2 0 1000000 79371 PO- /dblnk/live/my_db7
15 2 0 1000000 3 PO- /dblnk/live/my_db8
16 2 0 1000000 6 PO- /dblnk/live/my_db9
17 2 0 1000000 2711 PO- /dblnk/live/my_db10
18 2 0 1000000 550379 PO- /dblnk/live/my_db11
19 2 0 1000000 24997 PO- /dblnk/live/my_db12
20 2 0 1000000 24997 PO- /dblnk/live/my_db13
21 4 0 500000 499997 PO- /dblnk/train/mytrain_db3
22 2 0 1000000 399997 PO- /dblnk/live/my_db14
23 2 0 1000000 999997 PO- /dblnk/live/my_db15
24 2 0 1000000 999997 PO- /dblnk/live/my_db16
25 3 0 1000000 11483 PO- /dblnk/test/mytest_db2
26 8 0 500000 499497 PO- /dblnk/live/my_temp3
27 3 0 1000000 834997 PO- /dblnk/test/mytest_db3

Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
Physical restore failed - restore reserved pages failed

Program over.

When I Googled the above error message, the advice that I read said to
make sure the TAPE blocksize was set correctly using either mt and/or the
onconfig file. mt on SunOS 5.7 doesn't support setting the blocksize
as far as I could determine from it's arcane manpage and the onconfig
file that ontape uses has the correct blocksize (1024K) and total tape
size (138,240,000K). Another post I read said to make sure that the
path to the symlinks that point to the chunks had not changed name.
I made doubly sure of this.

Any further insights as to what I can do to make this `go' would be
much appreciated.

TIA,

Marshall

Messages In This Thread

• IDS 7.31/SunOS 5.7 ontape restore problem
  MARSHALL HAHN-TAYLOR -- Wednesday, 6 January 2010, at 2:26 p.m.
  • Re: IDS 7.31/SunOS 5.7 ontape restore problem
    Art Kagel -- Wednesday, 6 January 2010, at 3:26 p.m.
    • Re: IDS 7.31/SunOS 5.7 ontape restore problem
      MARSHALL HAHN-TAYLOR -- Wednesday, 6 January 2010, at 4:25 p.m.
  • Re: IDS 7.31/SunOS 5.7 ontape restore problem
    JACQUES RENAUT -- Wednesday, 6 January 2010, at 3:56 p.m.
    • Re: IDS 7.31/SunOS 5.7 ontape restore problem
      MARSHALL HAHN-TAYLOR -- Wednesday, 6 January 2010, at 4:39 p.m.
      • Re: IDS 7.31/SunOS 5.7 ontape restore problem
        JACQUES RENAUT -- Wednesday, 6 January 2010, at 4:56 p.m.
      • Re: IDS 7.31/SunOS 5.7 ontape restore problem
        Art Kagel -- Wednesday, 6 January 2010, at 5:06 p.m.
        • Re: IDS 7.31/SunOS 5.7 ontape restore problem
          MARSHALL HAHN-TAYLOR -- Wednesday, 6 January 2010, at 5:40 p.m.
          • Re: IDS 7.31/SunOS 5.7 ontape restore problem
            JACQUES RENAUT -- Wednesday, 6 January 2010, at 6:46 p.m.
    • RE: IDS 7.31/SunOS 5.7 ontape restore problem
      LARRY SORENSEN -- Wednesday, 6 January 2010, at 4:43 p.m.
      • Re: RE: IDS 7.31/SunOS 5.7 ontape restore problem
        MARSHALL HAHN-TAYLOR -- Wednesday, 6 January 2010, at 5:07 p.m.
    • Re: IDS 7.31/SunOS 5.7 ontape restore problem
      adolfo flores -- Wednesday, 6 January 2010, at 4:51 p.m.
      • Re: IDS 7.31/SunOS 5.7 ontape restore problem
        MARSHALL HAHN-TAYLOR -- Wednesday, 6 January 2010, at 5:10 p.m.
  • Re: IDS 7.31/SunOS 5.7 ontape restore problem
    MARSHALL HAHN-TAYLOR -- Thursday, 7 January 2010, at 12:36 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.