RE: Impact on running rman

You should have no problem with it as long as your system has the resources. Watch your IO and CPU. You can throttle the IO Rman uses with the "rate" option in your restore process.  

For example you can throttle it to 1M (per second I think, docs unclear about this) by adding the "rate 56K" to your allocate channel command. M(eg) and G(ig) are also valid.  

Hope this helps.      

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, June 26, 2007 1:31 PM
To: peter.schauss_at_ngc.com
Cc: oracle-l_at_freelists.org
Subject: Re: Impact on running rman

First of all, backups shouldn't be schedule during peak or business hours. However, RMAN backup are far better than the user managed hot backups in terms of redo, availablity, performance and etc.

restore validate, I guess, didn't touch the live database, rather simply check the backup copies validity.

Jaffar

On 6/26/07, Schauss, Peter <HYPERLINK
"mailto:peter.schauss_at_ngc.com"peter.schauss_at_ngc.com> wrote:

What is the impact of running an rman hot backup followed by a "restore validate" on application performance? Is there any possibility of applications or transactions being blocked during the backup and validate process? My environment is 10.2.0.2.0 Enterprise Edition running on HP-UX B.11.23.

Thanks,
Peter Schauss

--
HYPERLINK


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

oracle-l 







-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

HYPERLINK "http://jaffardba.blogspot.com/"http://jaffardba.blogspot.com/ 
HYPERLINK


"http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain"htt

p://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------
------ 


"Winners don't do different things. They do things differently." 



No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.9/870 - Release Date: 6/26/2007
10:07 AM



No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.9/870 - Release Date: 6/26/2007
10:07 AM
 


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