Re: database could not be started

From: <zifnab_at_islandsofmyth.remove.org>
Date: Mon, 11 Aug 2003 08:35:52 -0500
Message-ID: <Xns93D45777E326Dzifnabislandsofmytho@206.127.4.21>

"Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in news:tVFZa.14238$vK4.11346_at_fe05.atl2.webusenet.com:

I think you might slightly be missing Quarkman's point here, maybe a timeline will help (assuming I understand it correctly as well).

time A ) Cold backup taken including redo logs
time B ) Backup complete
time C ) Database opens, users start doing transactions. Recorded in Redo
         not archived yet.
time D ) For whatever reasons the cold backup needs to be applied from   
         time A. 

time E ) Time A's cold backup is restored including redo logs. time F ) database reopens

At time F you have now lost any transactions from C that were not archived yet because you restored the full cold backup + redo logs.

I think that is the point that is trying to be made. Received on Mon Aug 11 2003 - 08:35:52 CDT