Re: recover uncommited data

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

.

Relevant Pages

  • Re: RMAN and re-do logs
    ... We are completing a restore procedure that includes clearing out redo- ... logs from an ASM directory and doing the usual restore & recover ... Please could someone explain at what point rman recreates redo and why ... round problem by using ...recover using from backup controlfile syntax ...
    (comp.databases.oracle.server)
  • Re: RMAN and re-do logs
    ... We are completing a restore procedure that includes clearing out redo- ... logs from an ASM directory and doing the usual restore & recover ... Please could someone explain at what point rman recreates redo and why ... round problem by using ...recover using from backup controlfile syntax ...
    (comp.databases.oracle.server)
  • Re: nvi for serious hacking
    ... it spake thus: ... > From my experience you cannot recover from such a mistake. ... You need redo to do the same in vim. ...
    (freebsd-hackers)
  • Database Restore Error
    ... I am trying to recover a database with a RMAN backup. ... i lost all my dbf and redo. ... this error message: ...
    (comp.databases.oracle.server)
  • Re: Minimize failover time
    ... The time to recover will only affect the time in which you cannot do any transactions but only the ones OPEN at the time it fails will be lost. ... Why rendering faster the SQL recover would result in lost transactions? ... >>>> and then wait for all the resources to respond. ...
    (microsoft.public.sqlserver.clustering)