OraFAQ Forum: Backup & Recovery » RMAN takes time to complete the backup but previously it was fine

Home » RDBMS Server » Backup & Recovery » RMAN takes time to complete the backup but previously it was fine (10gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN takes time to complete the backup but previously it was fine [message #593348]

Thu, 15 August 2013 13:29

dba707
Messages: 6
Registered: December 2012

Junior Member

My Database is 10gR2.

RMAN takes time to complete the backup but previously it was fine and I believed that because of the good amount of data added in last few weeks.

How can I decrease the time to completion the rman backup?
I am doing a complete backup once a week and everyday I do a incremental backup.
I want to tune rman backup.

What I can consider about above tuning problem.

Note: When rman backup started there are same jobs running same as last few weeks.

Thanks in advance.
Ibrahim

Report message to a moderator

Re: RMAN takes time to complete the backup but previously it was fine [message #593354 is a reply to message #593348]

Thu, 15 August 2013 14:32

John Watson
Messages: 8803
Registered: January 2010
Location: Global Village

Senior Member

One obvious approach is to parallelize the backup. If you have Enterprise Edition licences, launch multiple channels. If you are working with Standard Edition, launch multiple RMAN jobs and distribute the files between them.
Compressing the backup may also improve performance, but it too may have licensing implications.

Report message to a moderator

Re: RMAN takes time to complete the backup but previously it was fine [message #593432 is a reply to message #593354]

Fri, 16 August 2013 10:21

dba707
Messages: 6
Registered: December 2012

Junior Member

Hi John,
Thanks for your quick reply. I have Enterprise Edition licenses and I will try all options, witch you have mentioned in your reply. I will post the result for you soon.

Thanks.
Ibrahim

Report message to a moderator

Re: RMAN takes time to complete the backup but previously it was fine [message #593452 is a reply to message #593432]

Fri, 16 August 2013 12:41

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Adding to Mr Watson's fine suggestions, you could also enable "block change tracking".

[Updated on: Fri, 16 August 2013 12:43] by Moderator

Report message to a moderator

Previous Topic:	Restore with archive log only
Next Topic:	unrecognised punctuation symbol

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 02:05:11 CDT 2023