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 > dbspace is offline

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-09-07, 14:27
mortech mortech is offline
Registered User
 
Join Date: May 2007
Posts: 2
dbspace is offline

Hi there,

I am new to informix.
One of my dbspace is down. How can I get it back online?

rafcs0#:/Ifmxdata>oninit
Bad Primary Chunk '/Ifmxdata/dbspace1_3'.

Does anybody know how to resolve this?
Reply With Quote
  #2 (permalink)  
Old 05-09-07, 19:25
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
Question

ops....................... (i not found where i delete this thread...)
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________

Last edited by ceinma; 05-09-07 at 19:44.
Reply With Quote
  #3 (permalink)  
Old 05-09-07, 19:33
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
Question

first, what is the version ??
you can get with : onstat -

1) check the file '/Ifmxdata/dbspace1_3'.
if is a link, this link is valid???
if is linked to :
- a raw device, this raw is accessible??
to check a raw device you can use dd command to read all data...
- a coocked file (file of OS like any other ) , try copy to another location and remake the link.

2) to try put this chunk online use the onspaces :
onspaces -s <dbspacename> -p /Ifmxdata/dbspace1_3 -o <offset> -O

ps.: sorry my bad english...

Regards
César
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
  #4 (permalink)  
Old 05-11-07, 15:19
artemka artemka is offline
Registered User
 
Join Date: May 2004
Location: New York
Posts: 248
is this chunk mirrored?
Reply With Quote
  #5 (permalink)  
Old 05-14-07, 05:13
mortech mortech is offline
Registered User
 
Join Date: May 2007
Posts: 2
Hi atemka,

No, the link was not mirrored. However, I figured that since the offline chunk contained system catalogue info and I had a backup which was restored on my test server about a month or two back and there were no changes to the actual tables recently, I then ftp'ed the chunk from test into the production box, overwriting the existing chunk which was offline. Then I refreshed my link and was able to get it back online with onspaces.

Thanks artemka
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