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

Posted in 2004

Rajasekaran, Rajesh — Mon, 29 Mar 2004 09:45:45 -0600 — source: Usenet: comp.databases.informix

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

↪ replying to Rajasekaran, Rajesh

Brice Avila — 31 Mar 2004 09:20:04 -0800 — source: Usenet: comp.databases.informix

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 "Rajasekaran, Rajesh" <RRajasekaran@forestpharm.com> wrote in message news:<c49i2q$4ns$1@terabinaries.xmission.com>... > 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

↪ replying to Rajasekaran, Rajesh

Brice Avila — 31 Mar 2004 11:51:48 -0800 — source: Usenet: comp.databases.informix

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 "Rajasekaran, Rajesh" <RRajasekaran@forestpharm.com> wrote in message news:<c49i2q$4ns$1@terabinaries.xmission.com>... > 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

Related threads

Glossary

onbar