We are running IDS 9.30.UC1 on Solaris 8 --- We do a level zero archive
twice a week to disk, gzip the file and retain two versions. The archive
file is 1466957824 bytes (about 1.4 GB) long. I need to do a cold restore of
all dbspaces. I am getting a *",ä*,Physical restore failed - Bad tape."
error. I have tried restoring from both archive backups. The ontape is able
to read the header, but then it fails. I cannot understand why a disk
archive backup would go bad..... and not one, but two backups at the same
time? Any thoughts on what may be wrong? Can this be fixed? Somebody, please
help. Thanks in advance... Rajesh.


++++++++++++++
dylan:/opt/informix: ontape -r

Please mount tape 1 on /data/dba/archive/msp600.arc and press Return to
continue ...

Archive Tape Information

Tape type: Archive Backup Tape
Online version: Informix Dynamic Server Version 9.30.UC1
Archive date: Sat Oct 4 02:00:02 2003
User id: informix
Terminal id: ?
Archive level: 0
Tape device: /data/dba/archive/msp600.arc
Tape blocksize (in k): 512
Tape size (in k): 2097152
Tape number in series: 1

Spaces to restore:1
]
2
]
3
]
4
]
5
]
6
]
7 [datadbs11
]
8
]
9
]
10
]

Archive Information

Informix Dynamic Server Copyright(C) 1986-1999 Informix Software, Inc.
Initialization Time 11/06/2001 14:10:25
System Page Size 2048
Version 12
Archive CheckPoint Time 10/04/2003 02:00:04

Dbspaces
number flags fchunk nchunks flags owner
name
1 1 1 1 N informix
rootdbs
2 1 2 1 N informix
physlog
3 1 3 1 N informix
loglog
4 1 4 1 N informix
datadbs00
5 1 5 1 N informix
datadbs01
6 1 6 1 N informix
datadbs10

7 1 7 1 N informix
datadbs11
8 2001 8 1 N T informix
tempdbs04
10 1 10 1 N informix
er_dbspace
11 8001 11 1 N S informix
er_sbspace
12 8001 12 2 N S informix
db_sbspace


Chunks
chk/dbs offset size free bpages flags pathname
1 1 4 131072 121938 PO- /dev/db/dev00
2 2 131076 131072 131019 PO- /dev/db/dev00
3 3 4 262144 6091 PO- /dev/db/dev10
4 4 262148 786427 678581 PO- /dev/db/dev00
5 5 0 1048575 661232 PO- /dev/db/dev01
6 6 262148 786427 511953 PO- /dev/db/dev10
7 7 0 1048575 796137 PO- /dev/db/dev11
8 8 0 221744 221435 PO- /dev/db/dev04
10 10 0 10000 9947 PO- /dev/db/dev02
11 11 10000 10000 1796 POS /dev/db/dev02
12 12 20000 5000 230 POS /dev/db/dev02
13 12 25600 25000 1316 POS /dev/db/dev02

Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
*,ä*,Physical restore failed -
Bad tape.


Program over.
dylan:/opt/informix:

On Tue, 07 Oct 2003 14:41:35 -0400, Rajesh Kapur wrote:

See if the file's last block (TAPEBLK) is incomplete. That may be the problem.
If so write a tiny 'C' program to open the file in 'a'ppend mode, fseek to the
last byte of the last fill block, and write a NULL byte there. The file may be
created such that the last block is created but not written to so it does not
really exist. Gzip may truncate such a virtual block.

Art S. Kagel

> We are running IDS 9.30.UC1 on Solaris 8 --- We do a level zero archive twice
> a week to disk, gzip the file and retain two versions. The archive file is
> 1466957824 bytes (about 1.4 GB) long. I need to do a cold restore of all
> dbspaces. I am getting a *",ä*,Physical restore failed - Bad tape." error. I
> have tried restoring from both archive backups. The ontape is able to read the
> header, but then it fails. I cannot understand why a disk archive backup would
> go bad..... and not one, but two backups at the same time? Any thoughts on
> what may be wrong? Can this be fixed? Somebody, please help. Thanks in
> advance... Rajesh.
>
>
> ++++++++++++++
> dylan:/opt/informix: ontape -r
>
> Please mount tape 1 on /data/dba/archive/msp600.arc and press Return to
> continue ...
>
> Archive Tape Information
>
> Tape type: Archive Backup Tape
> Online version: Informix Dynamic Server Version 9.30.UC1 Archive date: Sat
> Oct 4 02:00:02 2003 User id: informix Terminal id: ?
> Archive level: 0
> Tape device: /data/dba/archive/msp600.arc Tape blocksize (in k): 512 Tape
> size (in k): 2097152
> Tape number in series: 1
>
> Spaces to restore:1
> ]
> 2
> ]
> 3
> ]
> 4
> ]
> 5
> ]
> 6
> ]
> 7 [datadbs11
> ]
> 8
> ]
> 9
> ]
> 10
> ]
>
> Archive Information
>
> Informix Dynamic Server Copyright(C) 1986-1999 Informix Software, Inc.
> Initialization Time 11/06/2001 14:10:25 System Page Size 2048
> Version 12
> Archive CheckPoint Time 10/04/2003 02:00:04
>
> Dbspaces
> number flags fchunk nchunks flags owner name 1 1 1
> 1 N informix rootdbs 2 1 2 1 N
> informix physlog 3 1 3 1 N informix
> loglog 4 1 4 1 N informix datadbs00 5
> 1 5 1 N informix datadbs01 6 1 6
> 1 N informix datadbs10
>
> 7 1 7 1 N informix datadbs11 8 2001
> 8 1 N T informix tempdbs04 10 1 10 1
> N informix er_dbspace 11 8001 11 1 N S
> informix er_sbspace 12 8001 12 2 N S informix
> db_sbspace
>
>
> Chunks
> chk/dbs offset size free bpages flags pathname 1 1 4 131072
> 121938 PO- /dev/db/dev00 2 2 131076 131072 131019
> PO- /dev/db/dev00 3 3 4 262144 6091
> PO- /dev/db/dev10 4 4 262148 786427 678581 PO-
> /dev/db/dev00 5 5 0 1048575 661232 PO- /dev/db/dev01
> 6 6 262148 786427 511953 PO- /dev/db/dev10 7 7 0
> 1048575 796137 PO- /dev/db/dev11 8 8 0 221744
> 221435 PO- /dev/db/dev04 10 10 0 10000 9947
> PO- /dev/db/dev02 11 11 10000 10000 1796 POS
> /dev/db/dev02 12 12 20000 5000 230 POS /dev/db/dev02
> 13 12 25600 25000 1316 POS /dev/db/dev02
>
> Continue restore? (y/n)y
> Do you want to back up the logs? (y/n)n
> *,ä*,Physical restore failed -
> Bad tape.
>
>
> Program over.
> dylan:/opt/informix: