If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > online backup with onbar version 9.21

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-09-04, 19:32
zafyil zafyil is offline
Registered User
 
Join Date: May 2004
Posts: 5
Question online backup with onbar version 9.21

Hello Informix gurus,

Here is what I intend to do. Please check and tell me that if my 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) I will not backup logical logs
3) It means, I will take a whole-system backup (onbar -b -w)

My question is that, while my database is online and in use by users, can I have a whole-system backup without really backing up the logical logs by setting the
LTAPEDEV=/dev/null

My concerns are: After all 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.

Thanks in advance
ZY
Reply With Quote
  #2 (permalink)  
Old 05-10-04, 05:04
supinformix supinformix is offline
Registered User
 
Join Date: Apr 2004
Location: Brussels
Posts: 57
We uses IDS7.31 and Legato Networker.
I thought this :
onbar -b -w will uses only TAPEDEV, this backup your whole database including logical logs.
onbar -l will uses LTAPEDEV.
If you select ALARMPROGRAM=/usr/informix/etc/no_log.sh, what means no logical log backup than will your db hangs when all you logs are consumed and you will have to make a full backup or launch "onbar -l". Else you still hangs.
If you select ALARMPROGRAM=/usr/informix/etc/log_full.sh, what means that the logical logs will be backup then onbar -l will be launched.
With LTAPEDEV /dev/null the logical logs will be send to /dev/null only with "onbar -l".
I made an IDS instance for such experiments.
LTAPEDEV you can change while IDS is running.
__________________
Yves & Willy
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On