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?

Thanks for all hints

Jogi

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

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
newsan.2003.12.04.08.54.40.242661.12806@bloomber g.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

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
> newsan.2003.12.04.08.54.40.242661.12806@bloomber g.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

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
> newsan.2003.12.04.08.54.40.242661.12806@bloomber g.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