| Performance impact in backup mode [message #349652] |
Mon, 22 September 2008 09:09  |
zaff
Messages: 50
Registered: July 2008
|
Member |
|
|
Hi guys,
I would like to know the percentage decrease in performance, compared to normal running, while a database is in backup mode.
Also, is there a difference if backup is done using SQL commands compared to using RMAN?
Regards,
Zaff
|
|
|
|
| Re: Performance impact in backup mode [message #349655 is a reply to message #349652] |
Mon, 22 September 2008 09:17  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
It is next to impossible to give even a rough estimated "percentage" without knowing your system,database,hardware and available resources.
If properly done, it would be minimal. In most of the shops, backup is done only in off hours.
If you are using 10g and above, RMAN could be configured to be
somewhat "load aware". You can ask RMAN to "appropriately use allocated resources" during "backup window" and hence reducing the load on database
[Updated on: Mon, 22 September 2008 09:41] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
