Re: How to clear UNDOTBS
From: Roger Xu <wellmetus_at_gmail.com>
Date: Mon, 18 Jan 2010 11:02:42 -0600
Message-ID: <eb64345d1001180902s1c70a8b7mf09f45034eef9081_at_mail.gmail.com>
I have an issue where the undo tablespace datafile is 25 GB in size with less than 100 MB is actually used but we need to backup the 25 GB datafile on every level 0 RMAN. My solution is to use RMAN compress on this datafle and it works great. Instead of 25GB, I am seeing some MB only. Thanks.
Date: Mon, 18 Jan 2010 11:02:42 -0600
Message-ID: <eb64345d1001180902s1c70a8b7mf09f45034eef9081_at_mail.gmail.com>
I have an issue where the undo tablespace datafile is 25 GB in size with less than 100 MB is actually used but we need to backup the 25 GB datafile on every level 0 RMAN. My solution is to use RMAN compress on this datafle and it works great. Instead of 25GB, I am seeing some MB only. Thanks.
On Mon, Jan 18, 2010 at 7:26 AM, Eriovaldo Andrietta <ecandrietta_at_gmail.com>wrote:
> Hi,
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 18 2010 - 11:02:42 CST