RE: Informix Ontape restorals fails from disk
Randy,
"BLOCKSIZE 512K" looks starnge.
Should be "TAPEBLK 512", "LTAPEBLK 64"
Though, I'm not sure that this is the problem
Also, don't forget to set correct '660' 'informix:informix'
ontape file permissions.
------------------------------------------
Alexey Sonkin
Senior Database Administrator
> -----Original Message-----
> From: randy_m_romero@hotmail.com [mailto:randy_m_romero@hotmail.com]
> Sent: Tuesday, February 10, 2004 1:06 PM
> To: informix-list@iiug.org
> Subject: Informix Ontape restorals fails from disk
>
> Gurus,
> Got a problem that I do not know how to address. I'm not an
> Informix dba, I'm just SysAdmin who's job is to make hotbackups work.
>
> Platform Solaris8
> Informix Version 9.21.UC3
>
> TAPEDEV /DBbackups/HotBackups/somefile <--backup to disk
> BLOCKSIZE 512K
> TAPESIZE 2048000
>
> LTAPEDEV /dev/null> BLOCKSIZE 64
> LTAPESIZE 1024000000>
> I've managed to "successfully" complete an archive using ontape -s -L0
> with supposed good results. The "somefile" is a symlink to
> file.1/file.2/file.3 during backups. This portion of the backups seem
> to work. It is when I run the ontape -r that things seem to fail.
> The restorals will take file.1 and file.2 with no issue, but when I
> move the symlink to file.3, Informix complains that I it thinks I am
> attempting to use file.1 and keeps prompting me for tape #3. File.1
> and File.2 are 2g in size and file.3 is about 1g in size. Are my
> parameters for TAPESIZE correct? What could I be missing that is
> causing my restorals to fail? Upgrading to Informix 9.4 is not a
> realistic solution. Thanks in advance for any ideas that may help.
>
>
>
> Randy Romero
sending to informix-list
sending to informix-list