backup UNDO Tablespace (dba_undo_extents)

From: Roger Xu <wellmetus_at_gmail.com>
Date: Tue, 15 Dec 2009 10:20:58 -0600
Message-ID: <eb64345d0912150820y5c5d7478v3e76fafb9ff25c57_at_mail.gmail.com>



Good morning,

Background: Windows 2003 / Oracle 10g with auto undo (8K block size)

We have only one datafile (20 GB) in the undo tablespace. When I ran RMAN backup of this datafile, it created a 20GB backupset file.

I query dba_undo_extents and it shows less than 80 MB used.

SQL> select sum(blocks) from dba_undo_extents; SUM(BLOCKS)



9824

Any explanation? How do I keep the backup of undo small?

Thanks,
Roger Xu

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 15 2009 - 10:20:58 CST

Original text of this message