OraFAQ Forum: Backup & Recovery » rman backup taking 10 hours to complete

Home » RDBMS Server » Backup & Recovery » rman backup taking 10 hours to complete

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

rman backup taking 10 hours to complete [message #195452]

Thu, 28 September 2006 14:54

alanm
Messages: 284
Registered: March 2005

Senior Member

Hi All,
an RMAN backup has started to take 10 hours to complete whereas it used to take 4 hours. there is no catalog. the backup pieces are approx 80G in size and I have noticed that there are a large number of EXPIRED backup pieces. The system is Linux based and the backup is to disk. There is a single channel defined. One idea would be to set up 2 channels. any help would be appreciated.

regards

Report message to a moderator

Re: rman backup taking 10 hours to complete [message #195454 is a reply to message #195452]

Thu, 28 September 2006 15:19

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Did someone manually remove a ton of backupsets from the filesystem? If so, you should remove all those entries with the following:

Code: [Select all] [Show/ hide]

RMAN> crosscheck backup;
RMAN> list expired backup;
RMAN> delete noprompt expired backup;

Report message to a moderator

Re: rman backup taking 10 hours to complete [message #195531 is a reply to message #195454]

Fri, 29 September 2006 04:56

alanm
Messages: 284
Registered: March 2005

Senior Member

hi,
Thanks for the response. I have removed the expired backup sets but I have also noticed that there are a large number of obsolete backups, I have deleted these too.

regards

[Updated on: Fri, 29 September 2006 04:56]

Report message to a moderator

Re: rman backup taking 10 hours to complete [message #195555 is a reply to message #195452]

Fri, 29 September 2006 07:55

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

What version of oracle? and what version of rman executable you are using?

Are they going to tape? if yes,Are there any network changes in your environment which you are aware of and which you may not aware of?

How was backup going before? over direct attached fiber/copper or network?..How is it going now?

You can try with 2 channels.

However, if it used to run in 4hrs then there is something changed in complete backup process whichcis causing delay

Sandeep

Report message to a moderator

Previous Topic:	RMAN Control file backup
Next Topic:	RMAN Backup using batch file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 12:30:35 CDT 2025