Here the the answer to my own question. This is the response from Oracle support about how datafiles are allocated to channels. The manual approach means explicitly specifying which datafiles go with which channels. I need to look at this further, because what happens when you add a datafile and forget to add it to the RMAN script. It should still get backed up, because it's a full backup.
Keith > You are right. Datafiles are assigned randomly to channels when backup database and you cannot predict > the way they are assigned. So, as you have stated, the only way is manual approach which you already know. > The same algorithm is used in most recent releases. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 16, 2002 1:49 PM > My condolences on 8.0.5, you should patch to 8.0.5.1 for better a much > better rman. > > I think that every channel is used for each datafile. When one datafile has > been completely backed up the channels are used for the next. This is > empiracal thought, what I have observed. I have 2 channels going to one > disk. > > Ruth > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, December 15, 2002 1:38 PM > > > > Does anyone know how RMAN decides which data files get backed up by which > > channels. I'm backing up to disk and have 4 channels, each to a separate > > disk drive. The data files seem to get assigned to channels at random. > Also, > > this is a version 8.0.5 database (Ugggg). > > > > Keith > > > > > > > -------------------------------------------------------------------------- -- > ---- > > > > The information transmitted is intended only for the person or entity to > > which it is addressed and may contain confidential and/or privileged > > material. If the reader of this message is not the intended recipient, > > you are hereby notified that your access is unauthorized, and any review, > > dissemination, distribution or copying of this message including any > > attachments is strictly prohibited. If you are not the intended > > recipient, please contact the sender and delete the material from any > > computer. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > > 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: [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). > >
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
