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: Impact on running rman

RE: Impact on running rman

From: Randy Johnson <randyjo_at_sbcglobal.net>
Date: Wed, 27 Jun 2007 20:31:42 -0500
Message-ID: <00a301c7b924$15e970d0$6701a8c0@scraunch>

 

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Wednesday, June 27, 2007 2:10 PM
To: Robert Freeman
Cc: oracle-l_at_freelists.org
Subject: Re: Impact on running rman

On 6/27/07, Robert Freeman <HYPERLINK "mailto:robertgfreeman_at_yahoo.com" \nrobertgfreeman_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



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
 


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 27 2007 - 20:31:42 CDT

Original text of this message

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