Re: Oracle Instance Recovery (I don't get it :)

From: Andrey Dmitriev <netcomradeNOSPAM_at_earthlink.net>
Date: Sun, 20 Jun 1999 23:41:56 GMT
Message-ID: <376d7bd7.26839953@news.earthlink.net>

Now I am really confused. I thought so too, but as I was reading Oracle 8 Tuning (Oracle series) I have noticed that the author(s) say that Redo Logs contain only committed information. Does anybody else have an opinion? Thanx. Meanwhile I think I am going to order Oracle 8 Architecture from bn or amazon :)

On Sun, 20 Jun 1999 23:26:53 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>Hi Andrey,
>
>Rollback segments are protected by the redo log files too, so rollback data
>is in the redo log. This makes sure you can rollback uncommitted
>transactions.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>Andrey Dmitriev wrote in message <376d2dfc.6908664_at_news.earthlink.net>...
>>Hi,
>>
>>I don't completely understand what is going on during Oracle Instance
>>Recovery. The redo logs are applied (roll forward?) and then
>>uncommited transactions are rolled back? But don't redo logs only have
>>only commited transactions?
>>
>>Thanx
>>
>
>
Received on Sun Jun 20 1999 - 18:41:56 CDT