Home » RDBMS Server » Backup & Recovery » rman backup taking 10 hours to complete
rman backup taking 10 hours to complete [message #195452] Thu, 28 September 2006 14:54 Go to next message
alanm
Messages: 282
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

Re: rman backup taking 10 hours to complete [message #195454 is a reply to message #195452] Thu, 28 September 2006 15:19 Go to previous messageGo to next message
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:

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


Re: rman backup taking 10 hours to complete [message #195531 is a reply to message #195454] Fri, 29 September 2006 04:56 Go to previous messageGo to next message
alanm
Messages: 282
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 Go to previous message
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
Previous Topic: RMAN Control file backup
Next Topic: RMAN Backup using batch file
Goto Forum:
  


Current Time: Wed Dec 07 07:12:58 CST 2016

Total time taken to generate the page: 0.09804 seconds