rootdbs crashed
A user lost their rootdbs with no backup, but still had the other dbspace files and saved onstat -d output, and asked how to rebuild rootdbs and relink the chunks/dbspaces. Replies explained that rootdbs holds the table of contents for all dbspaces, so creating a new one effectively wipes the old ones; the only options are painstaking raw-page recovery (dd the dbspaces and parse pages) or rebuilding from scratch. Others noted that consultants (Oninit) have in-house tools that have recovered most data in similar cases. No confirmed outcome for the poster is recorded, and the thread stresses mirroring rootdbs and taking backups.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
My Informix rootdbs was crashed.
I have no backup.
But I still have all the dbspaces(*.dbs) file and I captured all the onstat -d
info before it crashed.
How can I recreate back the rootdbs and link back all the dbspaces, its
indexes and chunks?
Pls help!!
Thanks.
You are pretty much hosed. Rootdbs contains the TOC for all dbspaces, so
bringing up a new one implies re-defining (clearing) your old ones. That's why
we mirror rootdbs and do backups.
There are some painful things you could do to try to recover the data - dd the
dbspaces and then parse the raw pages. That would actually be an interesting
exercise. Otherwise you are just going to have to bite the bullet and rebuild.
j.
>From: TEONG TEIK LEE <dericteong@gmail.com>
>Date: 2007/08/01 Wed AM 11:07:18 CDT
>To: ids@iiug.org
>Subject: rootdbs crashed [9672]
>Hi,
>
>My Informix rootdbs was crashed.
>I have no backup.
>But I still have all the dbspaces(*.dbs) file and I captured all the onstat -d
>info before it crashed.
>How can I recreate back the rootdbs and link back all the dbspaces, its
>indexes and chunks?
>Pls help!!
>Thanks.
>
>
>*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
We have tools that can rebuild this system. Just done something similar for
another company, trashed rootdbs etc
Paul Watson
Tel: +1 913-400-2620
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of vze2qjg5@verizon.net
> Sent: 01 August 2007 13:04
> To: ids@iiug.org
> Subject: Re: rootdbs crashed [9673]
>
> You are pretty much hosed. Rootdbs contains the TOC for all
> dbspaces, so bringing up a new one implies re-defining
> (clearing) your old ones. That's why we mirror rootdbs and do
> backups.
>
> There are some painful things you could do to try to recover
> the data - dd the dbspaces and then parse the raw pages. That
> would actually be an interesting exercise. Otherwise you are
> just going to have to bite the bullet and rebuild.
>
> j.
>
> >From: TEONG TEIK LEE <dericteong@gmail.com>
> >Date: 2007/08/01 Wed AM 11:07:18 CDT
> >To: ids@iiug.org
> >Subject: rootdbs crashed [9672]
>
> >Hi,
> >
> >My Informix rootdbs was crashed.
> >I have no backup.
> >But I still have all the dbspaces(*.dbs) file and I captured all the
> >onstat
> -d> >info before it crashed.
> >How can I recreate back the rootdbs and link back all the
> dbspaces, its
> >indexes and chunks?
> >Pls help!!
> >Thanks.
> >
> >
>
> >*************************************************************
> **********
> >******** Forum Note: Use "Reply" to post a response in the
> discussion
> >forum.
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
Who is we and where can we get these tools to rebuild rootdbs?
Thanks,
**************************************
Ernie Knox
Sears Holding Co.
IT Database Administrator Specialist
IT Service Management, Strategy & Architecture
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Fax: (847) 645-3874
Pager: (800) 759-8352 Pin#: 7271042
Email: eknox@sears.com
" It's always a great day to watch Football ! "
**************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul
Watson
Sent: Wednesday, August 01, 2007 2:44 PM
To: ids@iiug.org
Subject: RE: rootdbs crashed [9674]
We have tools that can rebuild this system. Just done something similar for
another company, trashed rootdbs etc
Paul Watson
Tel: +1 913-400-2620
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of vze2qjg5@verizon.net
> Sent: 01 August 2007 13:04
> To: ids@iiug.org
> Subject: Re: rootdbs crashed [9673]
>
> You are pretty much hosed. Rootdbs contains the TOC for all
> dbspaces, so bringing up a new one implies re-defining
> (clearing) your old ones. That's why we mirror rootdbs and do
> backups.
>
> There are some painful things you could do to try to recover
> the data - dd the dbspaces and then parse the raw pages. That
> would actually be an interesting exercise. Otherwise you are
> just going to have to bite the bullet and rebuild.
>
> j.
>
> >From: TEONG TEIK LEE <dericteong@gmail.com>
> >Date: 2007/08/01 Wed AM 11:07:18 CDT
> >To: ids@iiug.org
> >Subject: rootdbs crashed [9672]
>
> >Hi,
> >
> >My Informix rootdbs was crashed.
> >I have no backup.
> >But I still have all the dbspaces(*.dbs) file and I captured all the
> >onstat
> -d> >info before it crashed.
> >How can I recreate back the rootdbs and link back all the
> dbspaces, its
> >indexes and chunks?
> >Pls help!!
> >Thanks.
> >
> >
>
> >*************************************************************
> **********
> >******** Forum Note: Use "Reply" to post a response in the
> discussion
> >forum.
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
We are Oninit and they are in-house developed tools, built to get customers
out of situations like this.
Paul Watson
Tel: +1 913-400-2620
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of Knox, Ernest
> Sent: 01 August 2007 15:03
> To: ids@iiug.org
> Subject: RE: rootdbs crashed [9676]
>
> Who is we and where can we get these tools to rebuild rootdbs?
>
> Thanks,
>
> **************************************
> Ernie Knox
> Sears Holding Co.
> IT Database Administrator Specialist
> IT Service Management, Strategy & Architecture
> 3333 Beverly Rd., B4-266A
> Hoffman Estates, IL. 60179
> Office: (847) 286-5735
> Fax: (847) 645-3874
> Pager: (800) 759-8352 Pin#: 7271042
> Email: eknox@sears.com
>
> " It's always a great day to watch Football ! "
> **************************************
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of Paul Watson
> Sent: Wednesday, August 01, 2007 2:44 PM
> To: ids@iiug.org
> Subject: RE: rootdbs crashed [9674]
>
> We have tools that can rebuild this system. Just done
> something similar for another company, trashed rootdbs etc
>
> Paul Watson
> Tel: +1 913-400-2620
> Mob: +1 913-387-7529
> Web: www.oninit.com
>
> Failure is not as frightening as regret.
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of
> > vze2qjg5@verizon.net
> > Sent: 01 August 2007 13:04
> > To: ids@iiug.org
> > Subject: Re: rootdbs crashed [9673]
> >
> > You are pretty much hosed. Rootdbs contains the TOC for all
> dbspaces,
> > so bringing up a new one implies re-defining
> > (clearing) your old ones. That's why we mirror rootdbs and
> do backups.
> >
> > There are some painful things you could do to try to
> recover the data
> > - dd the dbspaces and then parse the raw pages. That would
> actually be
> > an interesting exercise. Otherwise you are just going to
> have to bite
> > the bullet and rebuild.
> >
> > j.
> >
> > >From: TEONG TEIK LEE <dericteong@gmail.com>
> > >Date: 2007/08/01 Wed AM 11:07:18 CDT
> > >To: ids@iiug.org
> > >Subject: rootdbs crashed [9672]
> >
> > >Hi,
> > >
> > >My Informix rootdbs was crashed.
> > >I have no backup.
> > >But I still have all the dbspaces(*.dbs) file and I
> captured all the
> > >onstat
> > -d> > >info before it crashed.
> > >How can I recreate back the rootdbs and link back all the
> > dbspaces, its
> > >indexes and chunks?
> > >Pls help!!
> > >Thanks.
> > >
> > >
> >
> > >*************************************************************
> > **********
> > >******** Forum Note: Use "Reply" to post a response in the
> > discussion
> > >forum.
> >
> >
> > **************************************************************
> > *****************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
The data MAY be rescuable, Oninit has done it recently recovering almost all of
a firms critical data from a system with a trashed rootdbs.
Art S. Kagel
----- Original Message -----
From: Vze2qjg5@Verizon.Net <ids@iiug.org>
At: 8/01 14:04:32
You are pretty much hosed. Rootdbs contains the TOC for all dbspaces, so
bringing up a new one implies re-defining (clearing) your old ones. That's why
we mirror rootdbs and do backups.
There are some painful things you could do to try to recover the data - dd the
dbspaces and then parse the raw pages. That would actually be an interesting
exercise. Otherwise you are just going to have to bite the bullet and rebuild.
j.
>From: TEONG TEIK LEE <dericteong@gmail.com>
>Date: 2007/08/01 Wed AM 11:07:18 CDT
>To: ids@iiug.org
>Subject: rootdbs crashed [9672]
>Hi,
>
>My Informix rootdbs was crashed.
>I have no backup.
>But I still have all the dbspaces(*.dbs) file and I captured all the onstat
-d
>info before it crashed.
>How can I recreate back the rootdbs and link back all the dbspaces, its
>indexes and chunks?
>Pls help!!
>Thanks.
>
>
>*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape