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: recover uncommited data

Re: recover uncommited data

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 30 Apr 2006 00:44:58 -0700
Message-ID: <1146383098.146415.146740@j73g2000cwa.googlegroups.com> 





You can't. Uncommitted data never really existed in the database,
so you can't recover it after a crash/shutdown abort. You need to
redo all transactions that were active when you aborted the instance
and commit them. And I mean redo and commit manually, because
Oracle rolled them back while doing crash recovery.



Hth,


    Vladimir M. Zakharychev


    N-Networks, makers of Dynamic PSP(tm)
    http://www.dynamicpsp.com
Received on Sun Apr 30 2006 - 02:44:58 CDT












Original text of this message













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