backup UNDO Tablespace (dba_undo_extents)
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Dec 2009 10:20:58 -0600
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
Other related posts:
