Q

Increasing database backup time

We recently upgraded Oracle Applications from 10.7 to 11.5.9. 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. Please help us resolve this problem.

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.

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close