RE: Impact on running rman
- From: "Randy Johnson" <randyjo@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Jun 2007 21:48:26 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, June 26, 2007 1:31 PM
To: peter.schauss@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx"peter.schauss@xxxxxxx> 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
"//www.freelists.org/webpage/oracle-l"//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
Other related posts:
