RE: Ontape -r
Posted in 1999
Did you roll forward all of the logical logs? If you do not do a complete
restore of the system I believe you are required to roll forward all of your
logical
logs to make them consistent with the rest of your instance.
Will
>===== Original Message From "Anne Shelp" <shean@mcdss.co.gov> =====
>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
------------------------------------------------------------
This e-mail has been sent to you courtesy of OperaMail, as a free service from
Opera Software, makers of the award-winning Web Browser, Opera. Visit us at
http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail
account is waiting at: http://www.operamail.com/
------------------------------------------------------------