Re: can't drop dbspace or chunk

Mike Edelstein wrote: > Hi, > I was trying as an experiment to restore a single non-critical > dbspace with online 7.22.uc3 and aix 4.2.1. This was a test > database using ontape with logical logs set to /dev/null. I did > an ontape -s -L 0 level 0 backup to tape. Then I tried a restore > of one dbspace with ontape -r -D the_dbspace (if I remember the > syntax correctly). After it restored the dbspace it asked if I > wanted to restore the logs and I said no. It finished and left > the chunk and dbspace in 'partial' status. When I restarted the > server the dbspace went to down status. Now it won't even let me > drop the dbspace or the database located in it. I get an error > 311 and it says the primary and mirror chunk are bad (there was > no mirroring). > I tried doing the restore again and answered yes to the logical > logs restore but it failed again. I guess there are two > questions... 1) is there any way to get rid of the bad > chunk/dbspace? 2) what is the correct procedure and configuration > to be able to restore a single dbspace using ontape? (the manual > seems to say you can do this.) > (By the way, I am not able to try using onbar because we don't > have a storage manager.) > > Thankyou for any suggestions, > Mike Edelstein, Zytek Inc. > mwedelstein@zyteksoftware.com Answer to question 1: If you have support you can call in and have tech support drop the dbspace and its chunks, if they really aren't important. Answer to question 2: If you want to perform a warm restore of a single dbspace (which is what you appear to want to do), you MUST backup your logical logs to something other then /dev/null. You must perform the logical log part of the restore for this to work, or as you've seen, the dbspace is restored, but only partially, and not it a usable state. Jacques -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************