If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > How can I repair the DBSpace when one of it's chunk file is damaged?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-07-02, 18:50
ShaLong ShaLong is offline
Registered User
 
Join Date: Oct 2002
Posts: 4
How can I repair the DBSpace when one of it's chunk file is damaged?

One chunk file of my DBSpace was deleted carelessly. Thus, the informix
server gave the following message when I initilized it:

oninit: Cannot open chunk '/mydbfiles/dev/dbfile11'. errno = 2

How can I recover from this error?

Thanks in advance!


ShaLong
Reply With Quote
  #2 (permalink)  
Old 11-08-02, 12:48
rnealejr rnealejr is offline
Registered User
 
Join Date: Feb 2002
Posts: 2,232
Are you saying that one of the db admins actually deleted a chunk ?
Reply With Quote
  #3 (permalink)  
Old 11-10-02, 18:52
ShaLong ShaLong is offline
Registered User
 
Join Date: Oct 2002
Posts: 4
Yes! Because all of the chunk files have little avaiable space. So I
decided to add a new chunk to increase the size of DBSpace. But after
I have added a new chunk file, and then created some tables, I found that I have used up all the available size of the volumn which all my chunk files are in. So I decided to drop the chunk and create a new chunk in another volumn, I can't drop the chunk for I have created some tables on it, whereupon I deleted the chunk file. After this, I can't
start the database.

Thanks for any help.

ShaLong

Last edited by ShaLong; 11-10-02 at 19:20.
Reply With Quote
  #4 (permalink)  
Old 11-11-02, 14:55
zathrus zathrus is offline
Registered User
 
Join Date: Oct 2002
Posts: 6
recreate the linked chunk and restore from tape backup
Reply With Quote
  #5 (permalink)  
Old 11-14-02, 03:58
tungaw2001 tungaw2001 is offline
Registered User
 
Join Date: Nov 2002
Posts: 25
Re: How can I repair the DBSpace when one of it's chunk file is damaged?

Quote:
Originally posted by ShaLong
One chunk file of my DBSpace was deleted carelessly. Thus, the informix
server gave the following message when I initilized it:

oninit: Cannot open chunk '/mydbfiles/dev/dbfile11'. errno = 2

How can I recover from this error?

Thanks in advance!


ShaLong
You can only restore it if you have a physical backup of the dbspace or just reinitialize the database from scratch, then load the data backup afterwards.
Reply With Quote
  #6 (permalink)  
Old 11-15-02, 01:24
dananio dananio is offline
Registered User
 
Join Date: Mar 2002
Posts: 112
re

if you have already created new link(or new added space) but you can't start database , you have to restore from backup
if your database can renew all data and you remember your database structure disk , use oninit -i and back to 0 then follow up you old step
Reply With Quote
  #7 (permalink)  
Old 11-15-02, 01:24
dananio dananio is offline
Registered User
 
Join Date: Mar 2002
Posts: 112
re

if you have already created new link(or new added space) but you can't start database , you have to restore from backup
if your database can renew all data and you remember your database structure disk , use oninit -i to go to 0 then follow up you old step
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On