Re: Ontape -r

I had to restore a specific dbspace the other day, and I had the system in multi user mode because other users were accessing different data. When the restore was completed, the system was still in multi user mode. I ended up calling for Informix support, and they told me that when this happens that they have dial in after a restore like this and set the data space back to consistent. The man I spoke with indicated that this is something that they have to do, and not something that an average user can complete. >>> "Art S. Kagel" <kagel@bloomberg.net> 12/14/99 2:52:04 PM >>> Look below and I'll point out your error. It is not well documented but I've been bitten: Anne Shelp wrote: > > Hi all, > > I was testing the capabilities of ontape to read an archive. I restored our test database from the last tape. I took informix offline and ran ontape -r develop. Message returned that the physical restore of develop completed. The online.log follows. The problem is now when I try to run ontape -s -L 0 I get the error "... Archive failed - DBspace develop is being recovered." What do I need to do to fix this. I could not find the answer in the manuals. > > System info. > > IDS 7.20 Solaris 2.5.1Compaq proliant 4000 > > Online.log: > Sat Dec 11 12:17:36 1999 > > 12:17:36 INFORMIX-OnLine Stopped.> > Sat Dec 11 12:20:02 1999 > > 12:20:02 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' > 12:20:04 DR: DRAUTO is 0 (Off) > 12:20:05 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > 12:20:05 Physical Recovery Started. > 12:20:05 Physical Recovery Complete: 0 Pages Restored. > 12:20:05 Logical Recovery Started. > 12:20:08 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 12:20:08 Dataskip is now OFF for all dbspaces > 12:20:08 Quiescent Mode > 12:20:08 Checkpoint Completed: duration was 0 seconds. > > 12:42:06 WARNING! Chunk 3 is being taken OFFLINE for recovery. > 12:42:06 Physical Restore of develop started. > > 12:50:37 Checkpoint Completed: duration was 0 seconds. > 12:54:37 Physical Restore of develop Completed. > 12:54:38 Checkpoint Completed: duration was 0 seconds. > 12:59:51 INFORMIX-OnLine Stopped. Here is where you went wrong. You shutdown the engine after the restore without bringing it fully to online mode. The restore left the restored chunks in state "inconsistent" meaning they were in the process of being restored. Bringing the engine online would have triggered the end of the fast recovery logic which would have run through the on disk logfiles to see if there were transactions to apply and finally marked the chunks back to online status. At this point you have to restore that dbspace again and this time do 'onmode -m' and wait for the engine status to report 'online' to onstat before shutting down with 'onmode -ky'. This recovery may be instantaneous but it usually takes a while, sometimes a seemingly unusually long while. When the engine is online run an onstat -d and you will see the chunks are now online as is the dbspace. [SNIP] I wish I really knew what I was doing Hang around here, pay attention, and help others. You'll learn quickly enough, we all did. OK maybe the Clown is still at the learning stage, but the rest of us did. ;-) Art S. Kagel