| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN and Disk Space
Yeah, Tim. You nailed it. Data was indeed purged from this tablespace.
Thanks once again
Raj
"Tim Gorman"
<Tim_at_SageLogi To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
x.com> cc:
Sent by: Subject: Re: RMAN and Disk Space
root_at_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?
> 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: Rajesh.Rao_at_jpmchase.com
>
> 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: ListGuru_at_fatcity.com (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: Tim_at_SageLogix.com 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: ListGuru_at_fatcity.com (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: Rajesh.Rao_at_jpmchase.com 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: ListGuru_at_fatcity.com (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).Received on Fri Oct 04 2002 - 20:48:34 CDT
 |
 |