Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2002
    Posts
    4

    Unanswered: 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

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Are you saying that one of the db admins actually deleted a chunk ?

  3. #3
    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 20:20.

  4. #4
    Join Date
    Oct 2002
    Posts
    6
    recreate the linked chunk and restore from tape backup

  5. #5
    Join Date
    Nov 2002
    Posts
    25

    Re: How can I repair the DBSpace when one of it's chunk file is damaged?

    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.

  6. #6
    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

  7. #7
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •