This discussion is archived
4 Replies Latest reply: May 12, 2013 6:59 PM by Hemant K Chitale RSS

RMAN channels

JCGO Newbie
Currently Being Moderated
Hi All,

I am running an RMAN backup copy of a 23 TB database.
I have configured my script to run:

ALLOCATE CHANNEL DISKXX DEVICE TYPE DISK FORMAT 'PATH' MAXPIECESIZE 300 G;

I have configured ABOVE for 100 channels,
and now it hangs after 100 datafile copy..which is strange...

Is above parameter correct?

any ideas are appreciated
  • 1. Re: RMAN channels
    Aman.... Oracle ACE
    Currently Being Moderated
    Is it a full backup that you are taking? For 23TB, it would be a lot for RMAN to do so probably, what is appearing as hanging is just the time taken by RMAN to start the backup job.

    Aman....
  • 2. Re: RMAN channels
    TSharma-Oracle Guru
    Currently Being Moderated
    You can collect the diagnostic to check what's going on behind the scenes using following metalink note.
    *Troubleshooting RMAN Performance or Hang Issues [ID 815857.1]*

    Also, How many total number of CPU cores you have on you machine? Oracle will not spawn channels more than our total number of cores at one single point of time. So in your case it might be possible that your all cores are active backing up datafiles and just waiting for them to finish before going any further.
  • 3. Re: RMAN channels
    JCGO Newbie
    Currently Being Moderated
    thanks...
    I will keep an eye on it further.
    I guess also the goal is to keep backup time completions to under 3 days, or even 2 days or even less, so I am tuning this as I go along.

    Keep in mind, I WAS using MAXPIECESIZE and now I removed this,...I am not sure if this has anything to do with it.

    Also, when it reached the CHANNEL 99, it just stayed there for hours..which was unusual...
  • 4. Re: RMAN channels
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    100 channels seems like overkill. Do you really want 100 separate processes concurrently doing I/O ? Where are the backups being written to ? (e.g. if tape, then you really need very many tape drives, if disk how are you spreading the write I/O of those 100 channels ?)

    Hemant K Chitale

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points