Re: To recover dbspaces

Sorry by my English' are not good. The DBSPACES estan now in DOWN and I do not have MIRRORING. Thanks >From: "Art S. Kagel" <kagel@bloomberg.net> >To: informix-list@iiug.org >Subject: Re: To recover dbspaces >Date: Mon, 16 Oct 2006 10:14:55 -0400 > >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 > > > > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list