RMAN and disk usage info

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 08 Jan 2003 07:49:37 -0800
Message-ID: <F001.0052A0C0.20030108074937@fatcity.com>

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). Received on Wed Jan 08 2003 - 09:49:37 CST