RE: backup UNDO Tablespace (dba_undo_extents)
Date: Tue, 15 Dec 2009 17:22:37 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415933A5DB00704_at_GVW1337EXC.americas.hpqcorp.net>
The undo tablespace is definitely required for full recovery of the database. First your restore then you roll forward then you rollback at the end to create a consistent image.
What kind of rman backup is being used? Backup pieces or copy, full or incremental, etc ... I expect at some point the full undo tablespace was used hence the full tablespace data files get backed up.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of MacGregor, Ian A. Sent: Tuesday, December 15, 2009 12:08 PM To: cicciuxdba_at_gmail.com
Cc: wellmetus_at_gmail.com; oracle-l_at_freelists.org Subject: Re: backup UNDO Tablespace (dba_undo_extents)
The undo tablespace is required for database recovery
Sent from my iPhone
On Dec 15, 2009, at 8:51 AM, "Guillermo Alan Bort" <cicciuxdba_at_gmail.com<mailto:cicciuxdba_at_gmail.com>> wrote:
Short answer... don't take a backup of the undo tablespace... it's not required for database recovery.
Alan.-
On Tue, Dec 15, 2009 at 1:20 PM, Roger Xu <<mailto:wellmetus_at_gmail.com>wellmetus_at_gmail.com<mailto:wellmetus_at_gmail.com>> wrote: 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 - 11:22:37 CST