| 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 usage info
I've seen this on my Windows system. It creates one huge file for each
channel to disk and the file size shrinks a bit after backup completion. I
never tried to determine what is controlling the initial file sizes (heck,
it's working and someone is screaming about something else) but your
description does make sense.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-----Original Message-----
Sent: Wednesday, January 08, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
I've seen behavior like this on AIX, but it shrinks the file back down after
the backup is complete.
I've not seen this on NT that I recall, I'll have to test it.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
Author of several books you can find on Amazon.com!
-----Original Message-----
Sent: Wednesday, January 08, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
List,
Oracle 8.1.7 rel 3
OS OpenVMS 7.3-1
I am using RMAN to backup my database and have run out of disk
space.
Talking to the sysadmin I learned an interesting fact about RMAN and
disk allocation.
When I use the "set limit channel d1 kbytes=3000000;" to limit the
size of the file created during the backup it creates a file on the
backup disk and allocates the space for the 3000000 kbytes. It actually
uses less than that as it backs up the datafiles.
My guess is that it will only place contigous datafiles in the space
allocated and not use the rest if it involves splitting a datafile
during backup. If I used a smaller kbyte limit there could be more
wasteing of space occuring.
Is this the same on other OS's? I do not have another system OS to
play with.
Thanks,
Ron mª¿ªm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: RROGERS_at_galottery.org
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).
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.net
--
Author: Koivu, Lisa
INET: Lisa.Koivu_at_efairfield.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 Wed Jan 08 2003 - 11:55:05 CST
 |
 |