ontape on windows when no tape drive attached
Prajakta Chikhale wanted ontape logical log backups on Windows XP with IDS 11.50 and no tape drive. Art Kagel said LTAPEDEV can be a file or folder, or use ontape -a -t with a path. Ontape -a and -c failed with 'Log backup to device nul not allowed'. Art explained LTAPEDEV was set to NUL, which discards logs; change it to a file or folder and restart the engine.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
How to take ontape backups of logical logs in Windows XP Professional system
which has no tape drive attached and direct it instead to CD or hard disk.
I am using IDS 11.50.
I am newbie to Informix DBA and all help that I get is using tape drives.
You can set LTAPEDEV to any file or folder it does not have to be set to a
tape drive or you can use ontape -a -t <filepath>
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. 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 Tue, May 29, 2012 at 5:48 AM, PRAJAKTA CHIKHALE <prajakta_s_c@yahoo.co.in
> wrote:
> How to take ontape backups of logical logs in Windows XP Professional
> system
> which has no tape drive attached and direct it instead to CD or hard disk.
>
> I am using IDS 11.50.
>
> I am newbie to Informix DBA and all help that I get is using tape drives.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f2351b574c2bf04c12ac74a
Sir,
ontape -s works , but ontape -a & ontape -c both give error as
ontape -a :
Performing automatic backup of logical logs
Logbackup failed - Log backup to device 'nul' not allowed
Program over
ontape -c :
Performing continuous backup of logical logs
Logbackup failed - Log backup to device 'nul' not allowed
Program over
Please need your help.
You have LTAPEDEV set to the NUL device which tells Informix to discard
logical logs as soon as they complete so it is not valid to try to archive
them. Change LTAPEDEV to a file or folder and bounce the engine, then you
will be able to archive your logical logs with ontape -a or ontape -c.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. 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 Wed, May 30, 2012 at 3:32 AM, PRAJAKTA CHIKHALE <prajakta_s_c@yahoo.co.in
> wrote:
> Sir,
>
> ontape -s works , but ontape -a & ontape -c both give error as>
> ontape -a :>
> Performing automatic backup of logical logs
> Logbackup failed - Log backup to device 'nul' not allowed
>
> Program over
>
> ontape -c :>
> Performing continuous backup of logical logs
> Logbackup failed - Log backup to device 'nul' not allowed
>
> Program over
>
> Please need your help.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f83a1295ce51b04c13e5fec