Yeah, Tim. You nailed it. Data was indeed purged from this tablespace.
Thanks once again
Raj
"Tim Gorman"
<Tim@SageLogi To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
x.com> cc:
Sent by: Subject: Re: RMAN and Disk Space
root@fatcity.
com
October 04,
2002 07:05 PM
Please
respond to
ORACLE-L
A "full backup" in RMAN backs up all database blocks that have ever been
used by the datafiles. A "backup incremental level = 0" backs up only the
database blocks currently in use in datafiles. A "copy" in RMAN copies all
blocks allocated to the datafile, thus creating a complete backup image
that
can be restored by utilities other than RMAN.
Is it possible that the current status shown in DBA_EXTENTS (i.e. 2.2Gb)
does not represent a "highwater mark" in terms of space consumption in that
tablespace? Is it possible that most of the 15Gb of space in that
tablespace (at least, more than 9Gb worth) was previously in use?
What kind of results do you get from doing an "incremental level = 0"
instead?
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 04, 2002 4:08 PM
> Since everyone's advocating RMAN here, I decided to start an RMAN backup
> for one of our development databases. And I had issues with disk space.
> Now, one of the tablespaces has been allocated 15 Gb of space, of which
> only 2.2 Gb has been used as per dba_extents. I started an RMAN backup
> directing this tablespace backup to be written to a file system with 9 Gb
> of free space. This backup filled up the file system and errored out.
>
> So, my question is, the first time you take a backup, does RMAN backup
the
> entire datafile?
>
> Thanks
> Raj
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
