Re: rollback after crash

"Joel Garry" <joel-garry_at_home.com> wrote:
> Pradeep wrote:
>
> > redo log1 gets full -> log switch -> redo log 2 gets full -> log switch
> > -> redo log 1 is over written here.
>
> This will not happen

Of course it will happen. Happens all the time.

> because you will get a "cannot write redo log"
> message in your alert log and everything will come to a grinding halt.

If that were the case, Oracle would be pretty useless.

Are you confusing incomplete checkpoints with uncommitted transactions?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB