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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: