We recently upgraded Oracle Applications from 10.7 to 11.5.9. The database version is 8.1.7.4. 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 8.1.7.4 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.

    Requires Free Membership to View

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.