View Single Post

   
  #3 (permalink)  
Old 04-19-2008, 09:01 PM
Ferronato
 
Posts: n/a
Default Re: table/database/dbspace recovery

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

Reply With Quote