Re: Ontape -r
Posted in 2000
Nigel Gall wrote:
>
> This brings me to another question. Why does the restore process require
> the lgoical logs to complete the restore process? Let me explain by giving
> an example.
>
> I did an ontape -r warm restore recently (after completing Y2K testing) and
> when I responded No to the logical log restore question, it ended the
> restore session stating that the restore was incomplete and left my chunks
> in an offline status. What I wanted to do was just restore to the point of
> the level-0 archive. Eventually I put in the tape for the logs and
> completed the restore.
>
> I suppose the detailed reasoning is in some chapter in the manual (so I'll
> be re-reading it). Just looking for a short answer off the topp of your
> experienced heads.
You require the logs for a warm restore but not for a cold restore. That
is because a warm restore is adding data to an existing, running set of
data. This newly restored dbspace cannot be left in a different timezone
to the other dbspaces. That is, you cannot have a bunch of dbspaces
current up to Thu and expect to restore a dbspace as it was on Tue. So
the logs are required to bring the dbspace up to Thu.
I hope that makes sense, but you did say 'short answer off the top of
your head'. Oh! You said 'experienced head', then ignore all I said. :-)
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |What year 2000 bug? year 2000 bug? |/// / ////|
| |year 2000 bug? year 2000 bug? year |// / /////|
| |2000 bug? year 2000 bug? year 1900 |/ ////////|
+----------------------+-----------------------------------+-----------+