RE: Impact on running rman

Thats the beauty of Duration, the backup is not discarded. Datafiles successfully backed up are considered backed up. During the next backup, those datafiles NOT backed up are prioritized first in that backup. Assuming you have the archived redo logs and all that, there is no risk to your database with the use of Duration, and you ensure that your backup window is met. You can use the partial parameter to avoid errors being reported if the backup window is exceeded and RMAN shutsdown the backup.

Duration can also be used like rate. If you know your backup takes 2 hours but you want to lessen the impact, you indicate a duration of, say 8 hours with the minimize load parameter. RMAN will then try to reduce the IO of the backup such that it will take 8 hours, thus reducing the IO overhead by 75%.

All in my Oracle Press Oracle Database 10g RMAN Backup and Recovery, or if you have Oracle Database 10g New Features it's in there too.

Pretty cool, eh? I believe (need to look this up to be sure) that rate is deprecated in 10g... still available, but not really supported anymore.

RF

Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! Sig V1.1

  -----Original Message-----
  From: Jared Still [mailto:jkstill_at_gmail.com]   Sent: Wednesday, June 27, 2007 11:59 AM   To: robertgfreeman_at_yahoo.com
  Cc: oracle-l_at_freelists.org
  Subject: Re: Impact on running rman

  On 6/26/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:     Oh RATE is SOOOO 9i!! :-)

    This is a 10g database so be looking at the duration parameter instead!! Talk all about this in chapter 16 of the 10g RMAN Book!!

  I suppose there are circumstances where you might choose DURATION.

  RATE however will ensure that your backups will finish, however slowly.

  DURATION will interrupt and discard a backup that does not complete within the specified window.
  Personally I can't think of a situation where I would want to do that.

  Why would you use it?

  --
  Jared Still
  Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l