URGENT HELP - please Server down....

I am running IDS 7.31 on a HP-UX Box(OS. HP-UX 10.20). I took a level 0 archive this morning of my Online server. I also did a DBEXPORT of one of the databases from this server just as an additional backup - the database is only small and all it's tables are in the one chunk. - no other tables are in this DBspace. I then attempted to restore this one chunk by doing: (in 'quiescent mode') ontape -r -D f1qtu1dbs (f1qtu1dbs being the chunkname containing the Database) Everything went OK but at the end of the restore I was prompted: Restore a level 1 or 2 archive (y/n) <No> Do you want to restore log tapes? (y/n) <No> ...I answered 'No' to the log tapes question because I had just taken a level 0 archive . The result was that I then got a message saying something along the lines of (Partial Incomplete.......) and when I do an 'onstat -d' the chunk showed as: c3b16898 4 4 8 1023992 322242 PI- /DBSCHUNKS/f1qtu1dbs ......and I could not access the database in this chunk. I then took a backup of the logical logs (ontape -a) and then procceeded to restore that chunk again via: ontape -r -D f1qtu1dbs ...it started going through the motions but now it has reached a point where it is continually asking for a Checkpoint but something is blocking it......... Informix Dynamic Server Version 7.31.UC2 -- Quiescent (CKPT REQ) -- Up 02:48:3 2 -- 33776 Kbytes Blocked:CKPT I think I have two options: 1) Abort the restore - drop the dbspace - recreate it - and then DBIMPORT my data that I had DBEXPORTED earlier today as backup. a) Will aborting the restore crash the whole online instance (even though I am only restoring the 1 non-critical DBSpace)? b) To drop the dbspace do I not have to drop the Database in that space first? If so, how can I can do that seeing as though I can't access that Database from within dbaccess(due to the "I" status of the chunk) 2) The other option would probably be a cold restore of the whole instance. a) Will this restore run into problems with the erroneous dbspace? b) Am I correct in saying that with a cold restore that it is as simple as putting the server in 'Offline' mode and then doing 'ontape -r'. .......I should not be asked for logs at the end of this should I? - I really only want to restore to the point in time this morning when I took the level 0 Archive. Thanks - Adam

Adam Bradley <Adam.Bradley@ahmg.com.au> wrote in message news:01bf28da$fd5a5340$150510ac@adamb.ahmg.com.au... > I am running IDS 7.31 on a HP-UX Box(OS. HP-UX 10.20). > > I took a level 0 archive this morning of my Online server. > > I also did a DBEXPORT of one of the databases from this server just > as an additional backup - the database is only small and all it's tables > are in the one chunk. - no other tables are in this DBspace. > > I then attempted to restore this one chunk by doing: (in 'quiescent mode') > > ontape -r -D f1qtu1dbs (f1qtu1dbs being the chunkname containing the > Database)> > Everything went OK but at the end of the restore I was prompted: > > Restore a level 1 or 2 archive (y/n) <No> > > Do you want to restore log tapes? (y/n) <No> > > ...I answered 'No' to the log tapes question because I had just taken a > level 0 archive . > > The result was that I then got a message saying something along the lines > of > (Partial Incomplete.......) and when I do an 'onstat -d' the chunk showed > as: > > c3b16898 4 4 8 1023992 322242 PI- > /DBSCHUNKS/f1qtu1dbs > > ......and I could not access the database in this chunk. I then took a > backup of the > logical logs (ontape -a) and then procceeded to restore that chunk again > via: > > ontape -r -D f1qtu1dbs> > ...it started going through the motions but now it has reached a point > where it is continually asking for a Checkpoint but something is blocking > it......... This is why you have restartable restore enabled. Disable this feature (in the $ONCONFIG) and restore your chunk again with logical logs. Server blocked on the checkpoint, because after restore you have pages in the buffer pool, related to the down chunk. Informix can't flush them, that's why checkpoint can't be completed. Remember, when you perform warm restore for one of the dbspaces you need all logs since level 0 archive. Logical records related to the database objects, located in this dbspaces will be replayed to ensure data consistency and to keep data in all dbspaces up to date. HTH. ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > Informix Dynamic Server Version 7.31.UC2 -- Quiescent (CKPT REQ) -- Up > 02:48:3 > 2 -- 33776 Kbytes > Blocked:CKPT > > I think I have two options: > > 1) Abort the restore - drop the dbspace - recreate it - and then DBIMPORT > my > data that I had DBEXPORTED earlier today as backup. > > a) Will aborting the restore crash the whole online instance (even > though I am > only restoring the 1 non-critical DBSpace)? > b) To drop the dbspace do I not have to drop the Database in that space > first? > If so, how can I can do that seeing as though I can't access that > Database > from within dbaccess(due to the "I" status of the chunk) > > 2) The other option would probably be a cold restore of the whole instance. > > a) Will this restore run into problems with the erroneous dbspace? > b) Am I correct in saying that with a cold restore that it is as simple > as > putting the server in 'Offline' mode and then doing 'ontape -r'. > > .......I should not be asked for logs at the end of this should I? - > I really > only want to restore to the point in time this morning when I took the > level > 0 Archive. > > Thanks - Adam >