Re: recover uncommited data

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 30 Apr 2006 14:22:51 +0200
Message-ID: <1ua9521ndnpmnet6nl3rqlgdakjr6dojvd@4ax.com>

On 30 Apr 2006 05:05:53 -0700, "aman.oracle.dba" <aman.oracle.dba_at_gmail.com> wrote:

>I am sorry sir.
>there is a way,
>because when SMON doing Instance Recovery at that time it does 3 steps
>1. RollFoward all query using REDO LOG FILES.
>2. Then open for Users
>then 3. Rollback all transaction.
>Now I have to stop on 2nd steps because at than time database is open
>for users.

Your understanding of instance recovery is incorrect Oracle first rolls back uncommitted transactions, then it rolls forward committed transactions.
Also you can't interrupt instance recovery.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Apr 30 2006 - 07:22:51 CDT