Re: Rollback in recovery.

From: Wayne Balmer <wbalmer_at_wainwrights.com>
Date: 1997/04/11
Message-ID: <5ik7ea$c0u$1@picasso.op.net>#1/1

Guilherme Mesquita Chaves <chavesgm_at_br.homeshopping.com.br> wrote:

>I'd like to know if the rollback phase at recovery uses the rollback
>segments or the rollback stored at the log files, or even both. I'd like
>to know what happens at the rollback phase at recovery. I thank you in
>advance.

For those transactions that were committed but not yet permanantly in the database, the transactions are read from the log file and rolled forward.

For those transactions that were not committed, the data is rolled back from the rollback segments.

I hope this helps. Received on Fri Apr 11 1997 - 00:00:00 CDT