Ontape -r

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. Sat Dec 11 13:45:03 1999 13:45:03 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' 13:45:06 DR: DRAUTO is 0 (Off) 13:45:07 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 13:45:07 Physical Recovery Started. 13:45:07 Physical Recovery Complete: 0 Pages Restored. 13:45:07 Logical Recovery Started. 13:45:10 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 13:45:10 Dataskip is now OFF for all dbspaces 13:45:10 Quiescent Mode 13:45:10 Checkpoint Completed: duration was 0 seconds. 13:45:16 On-Line Mode 13:45:16 Affinitied VP 3 to phys proc 3 13:45:16 Affinitied VP 1 to phys proc 2 I wish I really knew what I was doing Anne Shelp

Oninit is still in recover mode as default from previous restore, Shut your server down then restart it the usual way and check there isnt any oninit -r with a unix ps command. Greg E Anne Shelp <shean@mcdss.co.gov> wrote in message news:835n13$777$1@news.xmission.com... > > 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 developcompleted. 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 isbeing 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.> > Sat Dec 11 13:45:03 1999 > > 13:45:03 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' > 13:45:06 DR: DRAUTO is 0 (Off) > 13:45:07 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > 13:45:07 Physical Recovery Started. > 13:45:07 Physical Recovery Complete: 0 Pages Restored. > 13:45:07 Logical Recovery Started. > 13:45:10 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 13:45:10 Dataskip is now OFF for all dbspaces > 13:45:10 Quiescent Mode > 13:45:10 Checkpoint Completed: duration was 0 seconds. > 13:45:16 On-Line Mode > 13:45:16 Affinitied VP 3 to phys proc 3 > > 13:45:16 Affinitied VP 1 to phys proc 2> > I wish I really knew what I was doing > > Anne Shelp >

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