Re: RMAN Performance Maladies

  • From: Job Miller <jobmiller@xxxxxxxxx>
  • To: oracledba.williams@xxxxxxxxx, MFontana@xxxxxxxxx
  • Date: Mon, 12 Feb 2007 18:16:07 -0800 (PST)

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@xxxxxxxxx> 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.  

Other related posts: