To recover dbspaces
User on HP-UX 11.11 with Informix 7.31 tried to bring a down chunk/dbspace back online using 'onspaces -s dbspace -p /dev/informix/chunk01 -o 0 -O' and got "Cannot change chunk status" plus an ISAM illegal-argument error. Respondents (Superboer, Art Kagel) explained that onspaces can only restore a chunk this way when mirroring is in place and one side of the mirror is offline. Without a mirror, the options are restoring the instance from an archive taken before the damage, asking IBM Tech Support to log in and mark/delete the chunks, or reinitialising the instance; objects should be removed via DROP TABLE/DATABASE rather than by touching disk structures. No direct fix for the original command is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello' they can help me with sintaxys of the command ONSPACES to recover
dbspaces.
I execute it this way:
$onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O
Warning: Bringing chunk back online.
Do you really want to continue? (y/n)y
Verifying physical disk space, please wait ...
Cannot change chunk status.
ISAM error: illegal argument to ISAM function.
Plataform: HP-UX 11.11
Informix 7.31 FD8
Thanks
This only works if you have mirroring and either the mirror or the
primary chunk is down.
Otherwise it's restore time....
Superboer.
Juan Pablo schreef:
> Hello... they can help me with sintaxys of the command ONSPACES to recover
> dbspaces.
> I execute it this way:
> $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O
> Warning: Bringing chunk back online.
> Do you really want to continue? (y/n)y
> Verifying physical disk space, please wait ...
> Cannot change chunk status.
> ISAM error: illegal argument to ISAM function.>
> Plataform: HP-UX 11.11
> Informix 7.31 FD8
>
> Thanks
only works if you have mirroring ?
If I do not have mirroring I cannot put in way chunk ONLINE?
I eliminate dbspaces and to create the objects in one new one ?
As I can assure that all the objects of dbspaces damaged you would seran
satisfactorily recovered ?
Thanks
Juan Pablo
>From: "Superboer" <superboer7@t-online.de>
>To: informix-list@iiug.org
>Subject: Re: To recover dbspaces
>Date: 16 Oct 2006 06:19:38 -0700
>
>This only works if you have mirroring and either the mirror or the
>primary chunk is down.
>Otherwise it's restore time....
>
>Superboer.
>
>Juan Pablo schreef:
>
> > Hello... they can help me with sintaxys of the command ONSPACES to
>recover
> > dbspaces.
> > I execute it this way:
> > $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O
> > Warning: Bringing chunk back online.
> > Do you really want to continue? (y/n)y
> > Verifying physical disk space, please wait ...
> > Cannot change chunk status.
> > ISAM error: illegal argument to ISAM function.> >
> > Plataform: HP-UX 11.11
> > Informix 7.31 FD8
> >
> > Thanks
>
>_______________________________________________
>Informix-list mailing list
>Informix-list@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list
Juan Pablo wrote:
> Hello' they can help me with sintaxys of the command ONSPACES to recover
> dbspaces.
> I execute it this way:
> $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O
> Warning: Bringing chunk back online.
> Do you really want to continue? (y/n)y
> Verifying physical disk space, please wait ...
> Cannot change chunk status.
> ISAM error: illegal argument to ISAM function.>
> Plataform: HP-UX 11.11
> Informix 7.31 FD8
>
> Thanks
>
>
In general onspaces can only bring a chunk/dbspace online if the chunks are
mirrored and one side of the mirror is offline. You'll have to contact IBM
Tech support to have them log into your server and mark the chunks back online.
Art S. Kagel
Juan Pablo wrote:
> Hello… they can help me with sintaxys of the command ONSPACES to recover
> dbspaces.
> I execute it this way:
> $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O
> Warning: Bringing chunk back online.
> Do you really want to continue? (y/n)y
> Verifying physical disk space, please wait ...
> Cannot change chunk status.
> ISAM error: illegal argument to ISAM function.>
> Plataform: HP-UX 11.11
> Informix 7.31 FD8
>
> Thanks
>
>
In general onspaces can only bring a chunk/dbspace online if the chunks are
mirrored and one side of the mirror is offline. You'll have to contact IBM
Tech support to have them log into your server and mark the chunks back online.
Art S. Kagel
Juan Pablo wrote: > only works if you have mirroring ? > If I do not have mirroring I cannot put in way chunk ONLINE? > I eliminate dbspaces and to create the objects in one new one ? > As I can assure that all the objects of dbspaces damaged you would seran > satisfactorily recovered ? Wait, I know your English is not clear, but it seems to me that you are saying that you deliberately trashed a dbspace's chunk(s) in order to clear out the data contained inside? Is that right? If you did that then the chunks and the dbspace, probably including any unrelated data you had stored there are gone and unusable. There's no way to mark the dbspace to a usable state. You have three choices: 1 - Restore the instance from an archive taken before you damaged the on disk data structures. 2 - Contact IBM Tech support and ask them to delete the damaged dbspace(s) and chunks. -or- 3 - Initialize the entire instance and start all over from scratch. If you want to drop a database and it's objects you MUST do that at the SQL level using DROP TABLE... or even DROP DATABASE... Never muck with the disk structures unless you REALLY know what you are doing, have taken several different kinds of backups, and have no other choice. Art S. Kagel > Juan Pablo > >