Re: Fw: FWD: use of ISM and ONBar vs ontape

Ok, Can you help with two sample commands using a level 0 ontape to restore a dbspace(s) or a database? Thanks, Denmark W. ----- Original Message ----- From: Art S. Kagel <kagel@bloomberg.net> Newsgroups: comp.databases.informix To: Denmark Weatherburn <dweatherb@btl.net> Sent: Wednesday, December 29, 1999 2:12 PM Subject: Re: Fw: FWD: use of ISM and ONBar vs ontape > Ontape only backs up hte entire server, however, you can restore at the > dbspace level so as long as the list of dbspaces used by each database is > disjoint no problems restoring one or the other. > > Art S. Kagel > > Denmark Weatherburn wrote: > > > > Ok Listers, > > > > I'll digress a little. You are aware of the famous quote: > > "If it ain't broke don't fix it." > > I have had no problem with using ontape for our backups, however, how can I > > use ontape (What command) to backup or restore one or more than one dbspace. > > Currently I do a level 0 backup everynight before we start our End of Day > > batch process. The application is divided into two distinct components. > > Hencehas data is stored in two seperate databases. One of those databases > > is pretty much static. > > Only a balances update procedure is run at the end of the day. > > The other database records dynamic transactions throughout the day. > > I would want to use a different backup and restore strategy for the dynamic > > database. > > Can I implement this using ontape? > > > > Regards, > > > > Denmark W. > > > > ----- Original Message ----- > > From: William Rice <ricew@operamail.com> > > To: Denmark Weatherburn <dweatherb@btl.net>; Informix Users Group > > <informix-list@iiug.org> > > Sent: Tuesday, December 21, 1999 8:54 AM > > Subject: RE: FWD: use of ISM and ONBar > > > > > >===== Original Message From "Denmark Weatherburn" <dweatherb@btl.net> > > ===== > > > >Hi Listers, > > > > > > > >Do these procedures apply in the Solaris 2.x environment? > > > >I use ontape right now, but I need the flexibility to backup and restore > > one > > > >database or one dbspace. > > > > > > > >Denmark W. > > > > > > > > > > I didn't think onbar provided anymore functionality than ontape as far as > > > single > > > dbspace restore without restoring all the logical logs to make it > > consistent > > > with the rest of the instance. Is their something I dont know about? > > > > > > Will > > > > > > ------------------------------------------------------------ > > > This e-mail has been sent to you courtesy of OperaMail, as a free > > service from > > > Opera Software, makers of the award-winning Web Browser, Opera. Visit > > us at > > > http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free > > e-mail > > > account is waiting at: http://www.operamail.com/ > > > ------------------------------------------------------------ > > > > > > >

Denmark Weatherburn wrote: > > Ok, > > Can you help with two sample commands using a level 0 ontape to restore a > dbspace(s) or a database? Again ontape cannot restore a single database but you can selectively restore only certain dbspaces and if the desired database is the only database that has objects in those dbspaces then effectively you have restored the database. So assuming that the database catalog resides in dbspace1 and its tables reside in dbspace1, dbspace2, dbspace7, and dbspace8 the restore would be: ontape -r -D dbspace1 dbspace2 dbspace7 dbspace8 Art S. Kagel > Thanks, > > Denmark W. > > ----- Original Message ----- > From: Art S. Kagel <kagel@bloomberg.net> > Newsgroups: comp.databases.informix > To: Denmark Weatherburn <dweatherb@btl.net> > Sent: Wednesday, December 29, 1999 2:12 PM > Subject: Re: Fw: FWD: use of ISM and ONBar vs ontape > > > Ontape only backs up hte entire server, however, you can restore at the > > dbspace level so as long as the list of dbspaces used by each database is > > disjoint no problems restoring one or the other. > > > > Art S. Kagel > > > > Denmark Weatherburn wrote: > > > > > > Ok Listers, > > > > > > I'll digress a little. You are aware of the famous quote: > > > "If it ain't broke don't fix it." > > > I have had no problem with using ontape for our backups, however, how > can I > > > use ontape (What command) to backup or restore one or more than one > dbspace. > > > Currently I do a level 0 backup everynight before we start our End of > Day > > > batch process. The application is divided into two distinct components. > > > Hencehas data is stored in two seperate databases. One of those > databases > > > is pretty much static. > > > Only a balances update procedure is run at the end of the day. > > > The other database records dynamic transactions throughout the day. > > > I would want to use a different backup and restore strategy for the > dynamic > > > database. > > > Can I implement this using ontape? > > > > > > Regards, > > > > > > Denmark W. > > > > > > ----- Original Message ----- > > > From: William Rice <ricew@operamail.com> > > > To: Denmark Weatherburn <dweatherb@btl.net>; Informix Users Group > > > <informix-list@iiug.org> > > > Sent: Tuesday, December 21, 1999 8:54 AM > > > Subject: RE: FWD: use of ISM and ONBar > > > > > > > >===== Original Message From "Denmark Weatherburn" <dweatherb@btl.net> > > > ===== > > > > >Hi Listers, > > > > > > > > > >Do these procedures apply in the Solaris 2.x environment? > > > > >I use ontape right now, but I need the flexibility to backup and > restore > > > one > > > > >database or one dbspace. > > > > > > > > > >Denmark W. > > > > > > > > > > > > > I didn't think onbar provided anymore functionality than ontape as far > as > > > > single > > > > dbspace restore without restoring all the logical logs to make it > > > consistent > > > > with the rest of the instance. Is their something I dont know about? > > > > > > > > Will > > > > > > > > ------------------------------------------------------------ > > > > This e-mail has been sent to you courtesy of OperaMail, as a free > > > service from > > > > Opera Software, makers of the award-winning Web Browser, Opera. > Visit > > > us at > > > > http://www.opera.com/ or our portal at: http://www.myopera.com/ Your > free > > > e-mail > > > > account is waiting at: http://www.operamail.com/ > > > > ------------------------------------------------------------ > > > > > > > > > >