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