Increasing database backup time
We recently upgraded Oracle Applications from 10.7 to 11.5.9. The
database version is 22.214.171.124. We're backing up the database through HP
Data Protector 5.5, which interfaces the RMAN. The backup time
started with 1.5 hours to back up the 94 GB database. The time
keeps increasing and now the time has built up to six hours to back up the
95 GB size. The other 126.96.36.199 databases are backing up through RAMN and
Data Protector is backing up fine, but they're on a different cell server
We tested out whether the issue will be resolved if we bounce the database,
but again it accumulates the time and goes back to six to seven hours in 15
days. We did a lot of research and didn't find any solution to the
problem yet. Please help us resolve this problem.
An increase of 1% of your database size should not result in an increase of 400% of your backup window. So something else must be going on here.
Are you also backing up your archived redo logs? With application upgrades, it is not unusual to see an increase in your transactions, thus an increase in your archived redo log generation. You might want to back up your archived redo logs more frequently.
This was first published in September 2005