RE: Informix Ontape restorals fails from disk
Posted in 2004
Topics: Backup & Restore, Server Administration, Platform-Specific Issues
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