Clarification on Informix DB logs..DISK to tape...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rajasekaran, Rajesh - 29 Mar 2004 16:45 GMT

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C415A4.E6558280
Content-Type: text/plain;
charset="iso-8859-1"

Hi,

I am trying to implement disk logging for DB logs. We are using the
ONBAR-VERITAS Netbackup Datacenter interface for our backups & restores.
Right now, we backup the logs to tape directly. But I would like to backup
the logs to disk first and then to tape. I am in the process of writing an
automated cron script for handling logs on disk before it fills the
file-system

Is there any standard scripts available related to this area ? If so, could
someone please forward me the link ?

Please pass on your suggestions/comments.

Regards
Rajesh Rajasekaran
Informix Database Administrator
Forest Pharmaceuticals Inc.
(314) 493-7073

____________________________________________________________________
This e-mail and its attachments may contain Forest Laboratories, Inc.
proprietary information that is privileged, confidential or subject to
copyright belonging to Forest Laboratories, Inc. This e-mail is intended
solely for the use of the individual or entity to which it is addressed. If
you are not the intended recipient of this e-mail, or the employee or agent
responsible for delivering this e-mail to the intended recipient, you are
hereby notified that any dissemination, distribution, copying or action
taken in relation to the contents of and attachments to this e-mail is
strictly prohibited and may be unlawful. If you have received this e-mail in
error, please notify the sender immediately and permanently delete the
original and any copy of this e-mail and any printout.

------_=_NextPart_001_01C415A4.E6558280
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2657.73">
<TITLE>Clarification on Informix DB logs..DISK to tape...</TITLE>
</HEAD>
<BODY>

Hi,


  I am trying to implement disk logging for DB =
logs. We are using the ONBAR-VERITAS Netbackup Datacenter interface for =
our backups & restores. Right now, we backup the logs to tape =
directly. But I would like to backup the logs to disk first and  =
then to tape.  I am in the process of writing an automated cron =
script for handling logs on disk before it fills the file-system =


 Is there any standard scripts available related =
to this area ? If so, could someone please forward me the link ?


Please pass on your suggestions/comments. 


Regards
 Rajesh Rajasekaran
 Informix Database Administrator
 Forest Pharmaceuticals Inc.
 (314) 493-7073

 
 
 
 

____________________________________________________________________&=
nbsp;=20
 This e-mail and its attachments may contain Forest Laboratories, =
Inc. proprietary information that is privileged, confidential or =
subject to copyright belonging to Forest Laboratories, Inc. This e-mail =
is intended solely for the use of the individual or entity to which it =
is addressed. If you are not the intended recipient of this e-mail, or =
the employee or agent responsible for delivering this e-mail to the =
intended recipient, you are hereby notified that any dissemination, =
distribution, copying or action taken in relation to the contents of =
and attachments to this e-mail is strictly prohibited and may be =
unlawful. If you have received this e-mail in error, please notify the =
sender immediately and permanently delete the original and any copy of =
this e-mail and any printout.

</BODY>
</HTML>
------_=_NextPart_001_01C415A4.E6558280--
sending to informix-list

Reply to this Message

Brice Avila - 31 Mar 2004 18:20 GMT

How about using the disk staging feature of NBU 5.0? This will do:

1. Backup your logical logs to a disk storage unit
2. Duplicate this disk storage unit image to tape
3. Expire the disk storage unit image (which will delete them also)

The disk staging feature has an option that will keep the disk storage
unit images on disk until the filesystem reaches a high water mark, so
if you need to restore the latest logs will be available on disk. In
any case, this is a lot easier option that writing your own scrips.

In lower versions of NBU you can write your own NBU scripts to do the
above. You must duplicate the image instead of backing up the disk
image, because disk image imports are not allowed. I've head of others
backing-up the disk images, manually deleting them and never expiring
them, but this causes your NBU catalog database to become huge.

Hope this information helps.

Brice Avila
Minneapolis, Minnesota

> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
[quoted text clipped - 100 lines]
> ------_=_NextPart_001_01C415A4.E6558280--
> sending to informix-list

Reply to this Message

Brice Avila - 31 Mar 2004 20:51 GMT

Raj,

I got your message. "You cannot import data from disk-images" is
documented on page 192 of the Veritas NetBackup 4.5 Systems
Administrator's Guide for UNIX. HTH.

Brice Avila
Minneapolis, Minnesota

Reply to this Message