Re: ontape/onbar ~ Answered: amber (hollow confidence) — Andy Kent explains that ontape/onbar restore dbspaces at a physical level only and force a log roll-forward, so restoring a dbspace after an accidental DROP DATABASE will just replay the drop; recommends dbexport/onunload/HPL for logical-level protection. The actual original question for this thread_id (jogi's) is only quoted from an earlier, separately-dated exchange, suggesting a threading/quoting artifact rather than a clean single question.

Advisory only.

You are right, ontape and onbar are not intended to allow you to recover individual dbspaces / databases at a *logical* level. Sure you can restore an individual dbspace but IDS will force you to replay the logs so that all dbspaces are consistent in time before it will let you access the restored one. So, suppose you did an accidental DROP DATABASE and you thought, "never mind, I've got a backup". So you restore the relevant dbspace(s). You are then forced to replay the logs which then repeats the DROP DATABASE. onbar has a point-in-time restore but unless someone tells me I'm wrong I don't believe it works for individual objects. The backup tools are intended to protect you against hardware failure ONLY. If you need something else you should look at dbexport, onunload or HPL. Andy "jogi" <jogi03@freenet.de> wrote in message news:<bqnfq9$afi$1@news1.ewetel.de>... > Hi Art, > > thanks for your answer. My English in not the very best, so sorry ... > > We have one instance wtih 25 databases with own dbspaces. > > I think for every database an own instance costs too much > > memory and cpupower. Restoring a single dbspace is not really > > assists by informix. > > May be its better with ONBAR or another possibility is to do an export > > every nigth. > > Greetings > > Jogi > > > > > "Art S. Kagel" <kagel@bloomberg.net> schrieb im Newsbeitrag > news:pan.2003.12.04.08.54.40.242661.12806@bloomberg.net... > > On Thu, 04 Dec 2003 05:33:45 -0500, jogi wrote: > > > > > Hi, > > > > > > we are proud owners of two aix pseries. On each server we have one > online > > > system > > > with 25 databases. We use ontape (Level 0) to save the online system, > but we > > > have the problem that we can't restore one special database. Anybody > better > > > experiences, may be with onbar? > > > > I do not understand. Ontape does not restore individual databases. You > can > > only restore either an entire instance or specified dbspace(s). Are you > saying > > that your 25 databases live in 25 separate instances of IDS? Or that > there is > > one instance but each database has its own dbspace and you are restoring > the > > dbspaces individually? > > > > If the former, I do not know what the problem is with that one restore, > but I > > have a question. WHY? Why not compile several or all of the databases > into a > > single instance or at least a small number of instances? > > > > If the latter, perhaps that database was initially created in the root > dbspace > > and so you are not correctly restoring the entire database when you > restore the > > one dbspace? > > > > Art S. Kagel