RE: Impact on running rman

I misread the docs all the time, or just don't notice little bits here and there. Drives me crazy. There is so much richness in this product.

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 1:10 PM   To: Robert Freeman
  Cc: oracle-l_at_freelists.org
  Subject: Re: Impact on running rman

  On 6/27/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:

    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.

  I misread the docs.

    BACKUP DURATION 4:00 TABLESPACE users;

    RMAN backs up the specified data at the maximum possible speed. If the backup is

    not complete in four hours, the backup is interrupted. Any completed backupsets are

    retained and can be used in restore operations, even if the entire backup is not

    complete. Any incomplete backupsets are discarded.

  What needs to be done here is to ensure that your backup is not in 1 backupset, or it is
  possible you'll never get a backup.

  Yes it is a neat feature. RMAN however gets more and more complex.

  I didn't see anything in the docs about RATE being deprecated. Possibly in another doc.

    The RATE parameter specifies the bytes/second that RMAN reads on this channel.

    Use this parameter to set an upper limit for bytes read so that RMAN does not

    consume excessive disk bandwidth and degrade online performance.     For example, set RATE=1500K. If each disk drive delivers 3 MB/second, then RMAN

    leaves some disk bandwidth available to the online system.

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

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