Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN Performance Maladies

Re: RMAN Performance Maladies

From: Job Miller <jobmiller_at_yahoo.com>
Date: Mon, 12 Feb 2007 18:16:07 -0800 (PST)
Message-ID: <840766.95055.qm@web53915.mail.yahoo.com>


an SLA that says you need a full backup? That's not an SLA/requirement it is a technical implementation specification.?     

  SLA should read, full recovery of all committed data within x minutes right?    

  Whoever wrote the SLA should rethink it. 10.2 also has incremental merges so you still have a "full backup on disk", despite not having taken a full backup everyday.    

  but the SLA author may be against that. Did the SLA mandate the RMAN script as well? :)    

  seriously though. you can limit the read/write rate for RMAN, that wouldn't help your cause. RMAN also tracks the disk read/write rates in some of its views. It has been awhlie now that I looked at that stuff, but it was there.. reports on how much throughput you got for each piece it backed up.    

  RAID 5 a "compromise" between efficiency and performance? That sounds like the "compromise" the native americans made with the settlers.    

  Job

Dennis Williams <oracledba.williams_at_gmail.com> wrote:

    Michael,

Backing up to RAID 5? Well expect that to be a little sluggish. Also, RMAN doesn't just blast the files to disk, it is doing more complicated stuff. Meaning more writes, which again RAID-5 does slowly.    

  Dennis Williams   



Looking for earth-friendly autos?
 Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 12 2007 - 20:16:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US