Home » RDBMS Server » Backup & Recovery » RMAN is working slow (Oracle Database 11g Release 11.2.0.3.0 - 64bit Production)
RMAN is working slow [message #599772] Mon, 28 October 2013 15:52 Go to next message
Saurabhchaudhary
Messages: 3
Registered: October 2013
Location: India
Junior Member
Hi,

I have Oracle Database 11g Release 11.2.0.3.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management. OS is Windows server 2008. Database size is approx 273 GB. I am running RMAN full back from a node with archive log all. With only 1 channel. Total backup size is almost 230 GB.

It is taking about 2 hours to complete the backup in the evening, but when i take same backup at midnight its takes about 1:15 hrs.

Please help in decreasing the time taken. Thanks

Saurabh
Re: RMAN is working slow [message #599774 is a reply to message #599772] Mon, 28 October 2013 16:31 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
So as you say that at different times, backup takes different times, so what exactly runs/executes/happens at that time?
Re: RMAN is working slow [message #599775 is a reply to message #599774] Mon, 28 October 2013 16:35 Go to previous messageGo to next message
Saurabhchaudhary
Messages: 3
Registered: October 2013
Location: India
Junior Member
Both the times we expect minimum number of users connected. And so is. There is nothing special running at any time. DB is ideal at both the times.
Re: RMAN is working slow [message #599795 is a reply to message #599772] Tue, 29 October 2013 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do it at midnight then.
And do it in parallel.

Re: RMAN is working slow [message #599798 is a reply to message #599775] Tue, 29 October 2013 01:49 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
If you really think it could be tuned, then have a look Tuning RMAN Backup Performance
Previous Topic: db_recover_file_dest and archive logs
Next Topic: Backup using VSS writer 11.2.0.2.0 fails
Goto Forum:
  


Current Time: Thu Mar 28 04:23:01 CDT 2024