We recently upgraded Oracle Applications from 10.7 to 11.5.9. The database version is 126.96.36.199. 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 188.8.131.52 databases are backing up through RAMN and Data Protector is backing up fine, but they're on a different cell server and machine.
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 Content Component encountered an error
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.