Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: redo logs
Dennis , so what you are trying to say is that the redo logs store undo data
also ?
> Not every statement is committed. Some are rolled back. So when the
database
> is recovered, these statements must again be rolled back.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Saturday, May 17, 2003 9:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello list
>
> the "backup and recovery concepts" manual says :"Each redo record contains
> both the old and the new values. Oracle also records the old value to an
> undo block located either in a rollback segment (if running in manual undo
> management mode) or in a dedicated undo tablespace (if running in
automatic
> undo management mode)."
>
> Does this mean that undo data is stored in both the undo tablespace and
the
> redo
> logs ?
>
> I thought that only statements were stored in the redo log file.
>
> If undo data is stored in the redo logs also, then , do we need the undo
> tablespace during recovery ? shouldn't the redo logs be enough ?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <bulbultyagi_at_now-india.net.in INET: bulbultyagi_at_now-india.net.in Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon May 19 2003 - 16:57:33 CDT