Re: backup UNDO Tablespace (dba_undo_extents)

From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 16 Dec 2009 12:46:47 -0800 (PST)
Message-ID: <28021.4959.qm_at_web80604.mail.mud.yahoo.com>

On my Windows XP running 10.2.0.1, I was able to reproduce this problem (a backup piece is about the same size as the undo tablespace datafile even though there's a lot of free space in it). I tried this on a 10.2.0.4 database (on Linux). The backup piece is about the same as (in fact, smaller than) the datafile size minus free space. So I think the problem is fixed between 10.2.0.1 and 10.2.0.4.

Yong Huang

• On Wed, 12/16/09, Roger Xu <wellmetus_at_gmail.com> wrote:

>

10R2 and I am using backupset (backup
datafile #;)

SQL> select * from v$version;
BANNER

---

Oracle Database 10g Release 10.2.0.1.0 - Production PL/SQL Release 10.2.0.1.0 - Production
>

CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production
SQL> show parameter undo

NAME                               
TYPE        VALUE
------------------------------------ -----------
-----------------------------
undo_management                     
string      AUTO


>

undo_retention                     
integer     900
undo_tablespace                     
string      UNDOTBS1

SQL> select bytes/1024/1024 from dba_data_files   2 where TABLESPACE_NAME =
'UNDOTBS1';
>

BYTES/1024/1024

---

          24545
SQL> select sum(bytes)/1024/1024 from
dba_free_space
  2 where TABLESPACE_NAME =
'UNDOTBS1';
SUM(BYTES)/1024/1024

---

               24474
SQL> select 24474-24545 from dual;
24474-24545

---

        -71
SQL>
>

(Sorry, it's 24GB not 20GB.)

Thanks,

Roger       

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

Received on Wed Dec 16 2009 - 14:46:47 CST