online backup of 9.21 with onbar ?
zafyil planned an online onbar whole-system backup of Informix 9.21 on HP-UX with LTAPEDEV set to /dev/null and no logical log backup, worried the database would hang when logs filled. Jonathan Leffler said it could be done, would not hang, and advised upgrading. Brett said the logs must be backed up or the backup is inconsistent; Leffler questioned that. Not settled.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello Informix gurus,
Here is what I intend to do. Please check and tell me that if way is
correct or not.
We have Informix 9.21, hp-ux 11.00
I want to backup the database online with onbar utility, while users are
inserting, deleting and reporting the database tables. Our database is in
on-line mode. Currently LTAPEDEV=/dev/null
My Steps:
1) I will install Legato Networker Client and networker module for
Informix
2) will not backup logical logs
3) It means, I will make whole-system backup (onbar -b -w)
My question is while my database is online and in use by users, can I have
a whole-system backup without backing up the logical logs by setting the
LTAPEDEV=/dev/null
My concerns are: after every logs is filled, will my database hang? If
yes, will I be able to cancel my backup and what will I have to do after I
cancel.
Please help
Thanks in advance
ZY
zafyil wrote:
> Here is what I intend to do. Please check and tell me that if way is
> correct or not.
>
> We have Informix 9.21, hp-ux 11.00
You should be considering upgrading - definitely IDS and probably
HP-UX too.
> I want to backup the database online with onbar utility, while users are
> inserting, deleting and reporting the database tables. Our database is in
> on-line mode. Currently LTAPEDEV=/dev/null
>
> My Steps:
> 1) I will install Legato Networker Client and networker module for
> Informix
> 2) will not backup logical logs
> 3) It means, I will make whole-system backup (onbar -b -w)
>
> My question is while my database is online and in use by users, can I have
> a whole-system backup without backing up the logical logs by setting the
> LTAPEDEV=/dev/null
You can do the backup.
> My concerns are: after every logs is filled, will my database hang? If
> yes, will I be able to cancel my backup and what will I have to do after I
> cancel.
No, it won't hang, any more than it does during normal operation.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
You need to backup the logs !!!
If you dont you will have a crappy backup that is inconsistent.
"zafyil" <zafer_yildirim@lycos.com> wrote in message
news:1f7e2deed1a4af8984a4ad4ef2ff6326@localhost.talkaboutdatabases.com...
> Hello Informix gurus,
>
> Here is what I intend to do. Please check and tell me that if way is
> correct or not.
>
> We have Informix 9.21, hp-ux 11.00
>
> I want to backup the database online with onbar utility, while users are
> inserting, deleting and reporting the database tables. Our database is in
> on-line mode. Currently LTAPEDEV=/dev/null
>
> My Steps:
> 1) I will install Legato Networker Client and networker module for
> Informix
> 2) will not backup logical logs
> 3) It means, I will make whole-system backup (onbar -b -w)
>
> My question is while my database is online and in use by users, can I have
> a whole-system backup without backing up the logical logs by setting the
> LTAPEDEV=/dev/null
>
> My concerns are: after every logs is filled, will my database hang? If
> yes, will I be able to cancel my backup and what will I have to do after I
> cancel.
>
> Please help
> Thanks in advance
> ZY
>
>
>
>
>
>
>
>
>
>
brett wrote:
> You need to backup the logs !!!
>
> If you dont you will have a crappy backup that is inconsistent.
Are you sure of that?
> "zafyil" <zafer_yildirim@lycos.com> wrote:
>>Here is what I intend to do. Please check and tell me that if way is
>>correct or not.
>>
>>We have Informix 9.21, hp-ux 11.00
>>
>>I want to backup the database online with onbar utility, while users are
>>inserting, deleting and reporting the database tables. Our database is in
>>on-line mode. Currently LTAPEDEV=/dev/null
>>
>>My Steps:
>>1) I will install Legato Networker Client and networker module for
>>Informix
>>2) will not backup logical logs
>>3) It means, I will make whole-system backup (onbar -b -w)
>>
>>My question is while my database is online and in use by users, can I have
>>a whole-system backup without backing up the logical logs by setting the
>>LTAPEDEV=/dev/null
>>
>>My concerns are: after every logs is filled, will my database hang? If
>>yes, will I be able to cancel my backup and what will I have to do after I
>>cancel.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/