Re: backup UNDO Tablespace (dba_undo_extents)

> I think RMAN will back up all blocks that have ever been part of 
> any segment.

Jeremiah,

That's the case up to 10gR1. Beginning with 10gR2, unused blocks in 
LMT are ignored, unused in the sense that the segment is dropped or 
truncated. See "Unused Block Compression" at
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=360443.1

> Oracle 10g
> 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.

Roger,

Tell us the exact version of Oracle. Could it be 10gR1? Your total 
undo tablespace is 20 GB. Is total free space (sum(bytes) from 
dba_free_space) for undo more than 19 GB? And I suppose you're not 
doing datafile image copy.

Yong Huang


      
--
http://www.freelists.org/webpage/oracle-l

Other related posts: