Re: Rollback segments confusion ?

From: yong huang <yong321_at_yahoo.com>
Date: Sun, 19 Nov 2000 09:35:52 -0800 (PST)
Message-Id: <10685.122462@fatcity.com>

Hi, Mapdeep,

I have sympathy with you. When people say you need to read the Concepts manual, it really means "isn't this obvious even though I'm not sure whether the Concepts manual talks about it"? Your confusion simply comes from the fact that you thought rollback segments were different than any other type of segment.

As far as I know, the Concepts manual is missing or extremely vague on what gets stored in RBS when your transaction issues a delete or insert statement (this is part of your generic question on RBS maintenance). The manual always takes update as an example and says the before-image of the row is stored in the RBS. But that's for update only. Go look for the answer in the manual. If you can't find it, you'll find it in R. Velpuri et al.'s Oracle8 Backup & Recovery Handbook.

Yong Huang
yong321_at_yahoo.com

you wrote:

thanks for explaination. I did read the manuals but I thought like DBWR process is responsible for writing to data files similarly there would be a separate process like RBWR or sth to write dirty Rollback buffers in Rollbak files. Also nowhere in concepts manual did I find ( SGA diagram or elsewhere) that Rollback segments are in memory . only things they talk about is DATA buffers and redo log buffers and hence the confusion.
So thanks again .

        Regards,
        Mandeep

__________________________________________________

Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays! Received on Sun Nov 19 2000 - 11:35:52 CST