SEO

#1 (**permalink**) 04-19-2008, 09:00 PM

One of my customers has an 84Gbyte instance which contains a lare
number of databases. They run this 24 by 7. For administrative
reasons they require to access a copy of the database from about 2
months ago, but they can't revert the whole system.
They do have a parallel machine running the same OS, same version of
IDS, etc, but it doesn't have enough disk space to restore the whole
instance.

The instance was backed up with ontape, is running on AIX 5.2 running
Informix IDS 9.30.
Is there any way we can do a restore without having all of the chunks
available?

I suspect we only need a few of the tables. And the dbspace that we
need to restore is at most 5 chunks of 2 Gbytes.

Any ideas much appreciated.

Malcolm

#2 (**permalink**) 04-19-2008, 09:00 PM

Malcolm

you might get away a with a rootdbs and some data dbspaces being
restored, a lot depends on how the database is split

malcolm wrote:
>
> One of my customers has an 84Gbyte instance which contains a lare
> number of databases. They run this 24 by 7. For administrative
> reasons they require to access a copy of the database from about 2
> months ago, but they can't revert the whole system.
> They do have a parallel machine running the same OS, same version of
> IDS, etc, but it doesn't have enough disk space to restore the whole
> instance.
>
> The instance was backed up with ontape, is running on AIX 5.2 running
> Informix IDS 9.30.
> Is there any way we can do a restore without having all of the chunks
> available?
>
> I suspect we only need a few of the tables. And the dbspace that we
> need to restore is at most 5 chunks of 2 Gbytes.
>
> Any ideas much appreciated.
>
> Malcolm

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #

#3 (**permalink**) 04-19-2008, 09:01 PM

Hi,

Why not run ontape -r -D <dbpsace list>
You can restore only chunks of these dbspaces and the rootdbs,
physical and logical log ...
You can create a little dbspace temp .... after that.
You have to modify your ONCONFIG file, in line ONDBSPACEDOWN change to
0 (zero) - means 'CONTINUE', because the deamon oninit will not find
all dbspaces.

I hope it helps you.

Regards. R. Ferronato

Paul Watson <paul@oninit.com> wrote in message news:<4075F393.413F8CDD@oninit.com>...
> Malcolm
>
> you might get away a with a rootdbs and some data dbspaces being
> restored, a lot depends on how the database is split
>
> malcolm wrote:
> >
> > One of my customers has an 84Gbyte instance which contains a lare
> > number of databases. They run this 24 by 7. For administrative
> > reasons they require to access a copy of the database from about 2
> > months ago, but they can't revert the whole system.
> > They do have a parallel machine running the same OS, same version of
> > IDS, etc, but it doesn't have enough disk space to restore the whole
> > instance.
> >
> > The instance was backed up with ontape, is running on AIX 5.2 running
> > Informix IDS 9.30.
> > Is there any way we can do a restore without having all of the chunks
> > available?
> >
> > I suspect we only need a few of the tables. And the dbspace that we
> > need to restore is at most 5 chunks of 2 Gbytes.
> >
> > Any ideas much appreciated.
> >
> > Malcolm

#4 (**permalink**) 04-19-2008, 09:05 PM

ONDBSPACEDOWN won't get you past an incomplete restore - will it? (Prove me wrong!)

Besides, 0 is the default. I can't remember ever seeing anyone change it.

Andy

roeferr@ig.com.br (Ferronato) wrote in message news:<df1bdeb4.0404120554.1345821b@posting.google. com>...
> Hi,
>
> Why not run ontape -r -D <dbpsace list>
> You can restore only chunks of these dbspaces and the rootdbs,
> physical and logical log ...
> You can create a little dbspace temp .... after that.
> You have to modify your ONCONFIG file, in line ONDBSPACEDOWN change to
> 0 (zero) - means 'CONTINUE', because the deamon oninit will not find
> all dbspaces.
>
> I hope it helps you.
>
> Regards. R. Ferronato
>
> Paul Watson <paul@oninit.com> wrote in message news:<4075F393.413F8CDD@oninit.com>...
> > Malcolm
> >
> > you might get away a with a rootdbs and some data dbspaces being
> > restored, a lot depends on how the database is split
> >
> > malcolm wrote:
> > >
> > > One of my customers has an 84Gbyte instance which contains a lare
> > > number of databases. They run this 24 by 7. For administrative
> > > reasons they require to access a copy of the database from about 2
> > > months ago, but they can't revert the whole system.
> > > They do have a parallel machine running the same OS, same version of
> > > IDS, etc, but it doesn't have enough disk space to restore the whole
> > > instance.
> > >
> > > The instance was backed up with ontape, is running on AIX 5.2 running
> > > Informix IDS 9.30.
> > > Is there any way we can do a restore without having all of the chunks
> > > available?
> > >
> > > I suspect we only need a few of the tables. And the dbspace that we
> > > need to restore is at most 5 chunks of 2 Gbytes.
> > >
> > > Any ideas much appreciated.
> > >
> > > Malcolm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

table/database/dbspace recovery