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.
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.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.