Re: Redo log and rollback segment question

On Mon, 23 Feb 1998 22:30:30 +0200, "aa" <aau_at_interlog.com> wrote: Hi,

Rolback Segments are used by oracle to provide a read consistent view onto the tables that where currently affected by a transaction and for for rollback purpose. Oracle registers all changes made to rows, tables etc. in its Redo Logs. If your db is rrunning in Archive Log Mode all chanhges since creation date are logged (if you've enough disk space to keep all logs). In case of a crash that may leed to a loss of one or more datafiles the db is made of you can start with some (maybe older) backup and using the archived redo log advance your db as close to the point the crash happened as possible.

>Can someone please explain the difference between Redo log and Rollback
>segments?
>
>What is the difference between creating the rollback segments under the
>System tablespace and a user defined tablespace?
>
>For those experienced in SQL Server, how does the Redo log and rollback
>segments compare to SQL Server's log? We have to periodically truncate the
>SQL Server log. Do we have to do the same to Redo log and rollback segments?
>
>Thanks for clearing this up for me.
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de