Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> recovery and resetlogs

recovery and resetlogs

From: Charles J. Fisher <cfisher_at_rhadmin.org>
Date: Thu, 23 May 2002 14:55:40 GMT
Message-ID: <Pine.LNX.4.44.0205230944170.14395-100000@galt.rhadmin.org>


I have a question regarding instance and database recovery and their interaction with a resetlogs operation.

I understand that instance recovery is a two-phase process, where SMON first rolls-forward all redo, opens the database, and then goes into a low-priority background state and rolls-back all uncommitted redo.

However, when the database is recovered from backup datafiles without online redo logs (by rolling through archived logs), and the database is opened with a resetlogs operation, how does SMON know about the uncommitted transactions?

I imagine that rolling-forward through the redo built all required versioning blocks in the rollback segments, but when all redo records are erased, how does SMON still retain knowledge of uncommitted transactions?


   / Charles J. Fisher                   |"How many who came into this world /
  /  cfisher_at_rhadmin.org                 | with me have already left it!"   /
 /   http://rhadmin.org                  |       -Marcus Aurelius          /
---------------------------------------------------------------------------
Received on Thu May 23 2002 - 09:55:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US