Re: DB backup of logical Logs to disk v tape...

Rajesh: I am currently using "ontape -c" to perform continuous backup. Here is the procedure I follow : You can have two scripts to perform the disk backup. First script does check whether ontape -c running for the given instance .. if it's not running, it start the LL backup immediately. Second script does check the Logical Log (LTAPEDEV) backup file size, if it's beyond 1 GB, I kill the continuous backup, move the logical log backup file to different directory, compress it. I also create the new LTAPEDEV file with proper permissions (660 and informix:informix) and start the logical log backup again. Note: Before killing ontape -c session, I check whether any backup going on .. wait until you finish the backup. 2 GB Limitation for file size for any files that handled by Informix 7.x/ (upto 9.3) Backup file size can go upto LTAPESIZE not beyond that. So move the files well before filling upto the max size. You can schedule these two scripts thro' informix cron job to run every 30 minutes alternatively. Again, I am not sure, how you can achieve this in onbar with Veritas (external backup manager). Because once you configure Onbar with Veritas, both backup and logical log backup goes to Veritas/Netbackup and LTAPEDEV will be dummy name unless you have different method to perform this task. (I am not aware of it). Thank You Ramesh Vasudevan "Rajasekaran, Rajesh" To: "'informix-list@iiug.org'" <informix-list@iiug.org> <RRajasekaran@fores cc: tpharm.com> Subject: DB backup of logical Logs to disk v tape... Sent by: owner-informix-list @iiug.org 08/22/03 11:49 AM Hello all, Could anyone provide the following details on backing up logs to disk v tape using ONBAR with VERITAS. ? We are currently doing log backups continously using "onbar -l -C" to a dedicated tape unit. I would like to free up the tape resources from constantly occupying by choosing alternative way to backup the logs. Hence i am designing strategy for disk logging. Questions 1) What is the best way to handle the logs first to disk and then to tape ? 2) Did anyone try to copy/move the logs from one directory to another and succesfully automate it ? 3) If so, how did you handle the scenario where some logs that are written to disk but not backed to tape yet ? 4) Could anyone forward any link where i can find some standard script templates for the same ? Your suggestions are greatly appreciated. Regards Rajesh Rajasekaran Informix Database Administrator Forest Pharmaceuticals Inc. (314) 493-7073 rrajasekaran@forestpharm.com sending to informix-list sending to informix-list