| Full RMAN database backup timing variation [message #634365] |
Mon, 09 March 2015 02:34  |
hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA
|
Member |
|
|
Hi,
In one of the database the full RMAN backup takes sometime 4 hours to complete whereas sometimes takes 7 hours to complete.
Its daily scheduled job single instance and backup on SBT tape drive.
Can you please suggest what are all the possible factors which affects the timing of RMAN backup completion?
Unfortunately, I do not have access to RMAN backup logs and RMAN on this server.
Also, I generated AWR / ADDM reports during that time and did some analysis but not much difference on all these reports, please guide me if anything specific you want me to check in AWR / ADDM reports.
Thanks in advance.
Regards,
Hitesh
|
|
|
|
|
|
| Re: Full RMAN database backup timing variation [message #634369 is a reply to message #634365] |
Mon, 09 March 2015 02:41  |
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
In my experience, erratic performance is sometimes because of unrelated activity on the database, the database server, the network, or the tape device. It is also sometimes because of wait events to do with the tape device not mounting the devices for a long time. If you post the AWR reports covering a 4 hour run and a 7 hour run, and your backup script, perhaps someone can help.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
