Re: ontape/onbar
Jogi,
You can restore a single instance with the following commands (please
confirm the syntax in the Informix manuals):
1. onmode -O -d <dbspace_name>
2. "onbar -r <dbspace_name>" OR "ontape -r -D <dbspace_name>"
So if you have your databases in their own instances, one can restore
a database by restoring the dbspace for that database.
Hope this information helps.
Brice Avila
Minneapolis, Minnesota
"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