RE: Limiting RMAN backup size
I have used SET LIMIT CHANNEL to limit the size of the backup pieces. I haven't used SETSIZE, which limits the total byte size of a backup set. However, I don't see how this will help, since a backup command can create many backup sets. I face the same dilema. It looks like another example of Oracle giving you very a fine-grained level of control over everything except that which you want to control. [EMAIL PROTECTED] 02/06/02 09:08PM TIA, I suggest reading the section of the manual on Back Sets. I've included the link below for you. Cheers, Craig. http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server. 817/a76990/rmanconc.htm#443835 http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server .817/a76990/rmanconc.htm#443835 -Original Message- Sent: Thursday, 7 February 2002 11:43 AM To: Multiple recipients of list ORACLE-L Hi I am doing RMAN incremental level 0 backup .The database size is about 150GB out of which used would be about 100GB.I don't have a single volume with 100GB of space.So I need to distribute the backup across several disks. Also I need to limit the backup size in each of the volumes depending on how much space is available in those volumes. For e.g if i want to limit /disk1 to 40GB /disk2 to 10GB /disk3 to 10GB /disk4 to 10Gb How would i do this in RMAN? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Limiting RMAN backup size
HiI am doing RMAN incremental level 0 backup .The database size is about 150GB out of which used would be about 100GB.I don't have a single volume with 100GB of space.So I need to distribute the backup across several disks. Also I need to limit the backup size in each of the volumes depending on how much space is available in those volumes.For e.g if i want to limit/disk1 to 40GB/disk2 to 10GB/disk3 to 10GB/disk4 to 10GbHow would i do this in RMAN? TIA
RE: Limiting RMAN backup size
TIA, I suggest reading the section of the manual on Back Sets. I've included the link below for you. Cheers,Craig. http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76990/rmanconc.htm#443835 -Original Message-From: Sona [mailto:[EMAIL PROTECTED]]Sent: Thursday, 7 February 2002 11:43 AMTo: Multiple recipients of list ORACLE-LSubject: Limiting RMAN backup size HiI am doing RMAN incremental level 0 backup .The database size is about 150GB out of which used would be about 100GB.I don't have a single volume with 100GB of space.So I need to distribute the backup across several disks. Also I need to limit the backup size in each of the volumes depending on how much space is available in those volumes.For e.g if i want to limit/disk1 to 40GB/disk2 to 10GB/disk3 to 10GB/disk4 to 10GbHow would i do this in RMAN? TIA
RMAN Backup Size
DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: RMAN Backup Size
Rman backs up only used blocks, so the size difference Johnson --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: RMAN Backup Size
Hi, It's all O.K., blocks that never been used aren't backuped by rman. oli [EMAIL PROTECTED] wrote DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: RMAN Backup Size
I believe that RMAN only backs up blocks that have been allocated to an oracle object - index, segment, table, etc. If the block is in a datafile but not in use by an oracle object (that is, the block is free), then RMAN doesn't backup those blocks. Steve [EMAIL PROTECTED] 04/30/01 12:25PM DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Steve Baucum INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).