RE: Impact on running rman

  • From: "Randy Johnson" <randyjo@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 27 Jun 2007 20:31:42 -0500

 
Thanks Jared. 
 
[at the maximum possible speed]
This is the crux of the matter. I may not want to run even one backup stream
wide open on a server with limited CPU & bandwidth.
 
PS
I haven't heard of RATE being depricated. In fact I think you could make a
case for using both RATE and DURATION in tandem. Continuous low impact
backups. Kind of an interesting concept.
 

   _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jared Still
Sent: Wednesday, June 27, 2007 2:10 PM
To: Robert Freeman
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Impact on running rman


On 6/27/07, Robert Freeman <HYPERLINK "mailto:robertgfreeman@xxxxxxxxx";
\nrobertgfreeman@xxxxxxxxx> 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



No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007
11:54 PM



No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007
11:54 PM
 

Other related posts: