That script will not help him. It depends on how you have rman configured and in this case he cannot see your config... Here is a summary that should help:
When making backups, RMAN divides the total number of files requiring backups by the number of allocated channels to calculate the number of files to place in each backup set. Use the MAXSETSIZE parameter to override this calculation and specify how many files should go in each backup set."
this isn't really true because the # of files in the set is dependent on the file size in some sense. If there were only 2 channels with 2 files, 100gb, 1M, the 100gb file would go to one channel and the 1M file would go to the other. That's not really balanced.....
Read info on MAXSETSIZE. I would not use it. I would simply set MAXPIECE which sets the max size for a single rman backup file...
docs.oracle.com and refer to the rman user guide...
Mike Porter
Finance Technical Services
PGA of America
561-624-7646
>>> "Lawrence Traub " <oracledba-ezmlmshield-x51526207.[Email address protected] 04/03/08 6:31 PM >>>
You should be able use RMAN to create a backup set that is in multiple
files. That is what we do where I work. Here is a sample piece of code
that we run on a daily basis:
backup full as compressed backupset
format '${target_dir_tmp}/${host}.database.${date_simple}.set%s.piece%p'
(database);
I hope this helps.
Lawrence Traub, DBA
-----Original Message-----
From: Jankiewicz Bill - wjanki
[mailto:oracledba-ezmlmshield-x18332915.[Email address protected]
Sent: Thursday, April 03, 2008 5:20 PM
To: LazyDBA Discussion
Subject: RMAN backup to disk in multiple files
Oracle 10.2.0.3
HPUX 11.23
Can I use RMAN to create a backup of a database to disk in multiple
files and control the size of the file(s) similar to datapump? Or do
RMAN backups to disk go to one file? Database is 20TB and we are
currently doing cold backups to tape via Backup Express.
************************************************************************
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
************************************************************************
*
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message is intended only for the use of the individual(s) or entity to which it is addressed and may contain information that is privileged, confidential, and/or proprietary to RealPage and its affiliated companies. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, forwarding or copying of this communication is prohibited without the express permission of the sender. If you have received this communication in error, please notify the sender immediately and delete the original message.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page