Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    24

    Talking Unanswered: Do we archive Undo tablespace also?

    Hi guys my question is that do we archive undo tablespace entries also? when database is in archiveing mode.
    i mean do redo log files contain undo segment data also?



    Thanks
    Last edited by ankurk; 04-25-08 at 11:33.

  2. #2
    Join Date
    May 2006
    Posts
    132
    Yes, redo logs do contain undo segments.

  3. #3
    Join Date
    Apr 2008
    Posts
    28
    Absolutly yes... undo tablespace is the only TS you cannot change to NOLOGGING, why? that's a good question ... maybe a mechanism for db recovery.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •