IDS BACKUP

Hello every body I want to know if is there another utility to do a backup than ontape and onbar for IDS 7.x and later Thanks Ing. Susana Barea Poder Judicial Mendoza sbarea@jusmendoza.gov.ar

Susana Basically, no. Why do you ask? Keith -> -----Original Message----- -> From: Susana Barea [mailto:sbarea@jus.mendoza.gov.ar] -> Sent: Friday, July 02, 2004 2:12 PM -> To: ids@iiug.org -> Subject: IDS BACKUP [3182] -> -> -> Hello every body -> -> I want to know if is there another utility to do a -> backup than ontape and onbar for IDS 7.x and later -> -> Thanks -> -> -> Ing. Susana Barea -> Poder Judicial Mendoza -> sbarea@jusmendoza.gov.ar -> -> -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

Susana, There are other methods that you can use, but I don't recommend them. Prior to the 9.x releases, the OnArchive backup utility was available; I urge you not to use that, given that OnBar is far more simple and supportable. It was necessary prior to OnBar if you wanted multi-streamed backups, but it really wasn't much fun to maintain. Any other mechanism is going to be an "external" one. If you have your chunks in cooked files, you can shut down the database (completely), and then back up those chunks, with the restore path being the restoration of those files. If they are in raw space (and you're on Unix/Linux), you can use the "dd" utility to copy those raw devices either directly to tape, or to disk for backup to tape. Again, you'd have to have the database shut down completely. There are several disadvantages to the "external" methods. The most obvious one is that your database has to be down for the duration of the backup, whereas if you use ontape or onbar, you can be up and running with minimal performance impact. Less obvious is the fact that you lose the ability to do a point-in-time restore, or a restore of a single dbspace. If you do an "external" backup, you have to restore the whole set of chunks and you can't rollforward the log files. That means that if you last backed up at midnight, and you lost data at 22:00 the next day, you'd lose 22 hours worth of work. In most cases, that's unacceptable. You can't restore individual spaces because the rootdbs records have to be "in synch" with the rest of the chunks; I can't remember the exact mechanism, but I can tell you that if you restored only those chunks pertaining to a particular DBSpace, you'd be out of synch, and the chunks would be marked down. I guess the question that I have for you is why you're looking for another utility? Do the existing ones not meet your needs, and if so, what need are you trying to meet? Dan Michaelis Senior Software Developer eOriginal, Inc Suite 800 351 West Camden Street Baltimore, MD 21201 410-625-5187 -- Office -----Original Message----- From: Susana Barea [mailto:sbarea@jus.mendoza.gov.ar] Sent: Friday, July 02, 2004 9:12 AM To: ids@iiug.org Subject: IDS BACKUP [3182] Hello every body I want to know if is there another utility to do a backup than ontape and onbar for IDS 7.x and later Thanks Ing. Susana Barea Poder Judicial Mendoza sbarea@jusmendoza.gov.ar

Well, there is onarchive for 7.3, but it wouldn't fill the "7.x and later" statement. now, don't everybody jump on me for onarchive... we ran it for quite some time, and it really wasn't that difficult to comprehend. onarchive would be pretty much like onbar in concept of what it does, so if you're looking to get away from ontape/onbar capabilities for some reason, onarchive won't get you there. you could go to a hardware solution.... we have EMC with BCVs... we could split a BCV and do a raw copy to tape if desired. depending on the size/needs of your DB, you could also emulate oracle's cold backup by shutting informix down each night, and copying informix filesystems and raw space to tape. you could in addition dbexport or unload the entire database and schema to filesystem and backup that to tape, if you were concerned about the raw backup..... be creative ;) Norma Jean -----Original Message----- From: keith.simmons@office2office.biz [mailto:keith.simmons@office2office.biz] Sent: Friday, July 02, 2004 9:39 AM To: ids@iiug.org; forum.subscriber@iiug.org Subject: RE: IDS BACKUP [3183] Susana Basically, no. Why do you ask? Keith -> -----Original Message----- -> From: Susana Barea [mailto:sbarea@jus.mendoza.gov.ar] -> Sent: Friday, July 02, 2004 2:12 PM -> To: ids@iiug.org -> Subject: IDS BACKUP [3182] -> -> -> Hello every body -> -> I want to know if is there another utility to do a -> backup than ontape and onbar for IDS 7.x and later -> -> Thanks -> -> -> Ing. Susana Barea -> Poder Judicial Mendoza -> sbarea@jusmendoza.gov.ar -> -> -> ************************************************************************ ********** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ************************************************************************ ********** ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

Depending upon whether you have SAN storage or not, you can copy your disks to BCV storage disks as part of a mirrored approach. You can use the onmode -block and -unblock commands as part as that setup, only with doing onbar external restores. If you are using flat files, you do use the same -block feature to checkpoint and freeze your instance, copy the flat files to a different location, then -unblock your instance to let it continue processing. Take care. Clifton "Simmons, Keith" <keith.simmons@office2office.biz> wrote: Susana Basically, no. Why do you ask? Keith -> -----Original Message----- -> From: Susana Barea [mailto:sbarea@jus.mendoza.gov.ar] -> Sent: Friday, July 02, 2004 2:12 PM -> To: ids@iiug.org -> Subject: IDS BACKUP [3182] -> -> -> Hello every body -> -> I want to know if is there another utility to do a -> backup than ontape and onbar for IDS 7.x and later -> -> Thanks -> -> -> Ing. Susana Barea -> Poder Judicial Mendoza -> sbarea@jusmendoza.gov.ar -> -> -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

There is also onarchive but that is not supported anymore. André >From: "Simmons, Keith" <keith.simmons@office2office.biz> >To: ids@iiug.org >Subject: RE: IDS BACKUP [3183] Date: Fri, 2 Jul 2004 10:38:58 -0400 (EDT) > >Susana > >Basically, no. Why do you ask? > >Keith > >-> -----Original Message----- >-> From: Susana Barea [mailto:sbarea@jus.mendoza.gov.ar] >-> Sent: Friday, July 02, 2004 2:12 PM >-> To: ids@iiug.org >-> Subject: IDS BACKUP [3182] >-> >-> >-> Hello every body >-> >-> I want to know if is there another utility to do a >-> backup than ontape and onbar for IDS 7.x and later >-> >-> Thanks >-> >-> >-> Ing. Susana Barea >-> Poder Judicial Mendoza >-> sbarea@jusmendoza.gov.ar >-> >-> >-> > > >******************************************************************************* *** >This message is sent in strict confidence for the addressee only. It may >contain legally privileged information. The contents are not to be >disclosed >to anyone other than the addressee. Unauthorised recipients are requested >to preserve this confidentiality and to advise the sender immediately of >any >error in transmission. >This footnote also confirms that this email message has been swept for the >presence of computer viruses, however we cannot guarantee that this message >is free from such problems. >******************************************************************************* *** > > >