Home » RDBMS Server » Backup & Recovery » Performance impact in backup mode
Performance impact in backup mode [message #349652] Mon, 22 September 2008 09:09 Go to next message
Messages: 50
Registered: July 2008
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?

Re: Performance impact in backup mode [message #349655 is a reply to message #349652] Mon, 22 September 2008 09:17 Go to previous message
Mahesh Rajendran
Messages: 10673
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

Previous Topic: Extract archivelog from backupset.
Next Topic: Understand password file usage
Goto Forum:

Current Time: Sat Jul 22 06:08:47 CDT 2017

Total time taken to generate the page: 0.04584 seconds