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 -> Re: rollback after crash

Re: rollback after crash

From: <sybrandb_at_yahoo.com>
Date: 14 Dec 2005 07:45:01 -0800
Message-ID: <1134575101.026283.29880@g47g2000cwa.googlegroups.com>


redo is NEVER EVER overwritten. It may be lost because of the crash, but NOT overwritten.

Any transaction without a commit marker is an incomplete transaction and will be rolled back.
The sequence during recovery is
rollback
rollforward

Bear in mind rollback segments are ordinary data segments and DBWR/LGWR mechanisms apply.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Dec 14 2005 - 09:45:01 CST

Original text of this message

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