Re: URGENT HELP - please Server down....

En Adam Bradley va escriure el dia 7 Nov 99, a les 15:46: > 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 > Hi, My recommendation is the following one: a) Put yous server down (on mode -ky, or other method) b) start a restore of the Online instance (ontape -r) c) When IDS ask for new backup levels (1) say NO. d) when IDS ask for logs backup restore say NO. e) Parallelly it is advisable to pray (if one is believing). ;-DDD Most of the times these operations work correctly Take care. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------