troubleshooting Question

Oracle Recovery File Size

Avatar of CCtech
CCtechFlag for United States of America asked on
Oracle Database
5 Comments2 Solutions103 ViewsLast Modified:
We have a program that works off of an oracle database. The program locks up and will stop functioning, due to the oracle file - db_recovery_file_dest c:\oracle\product\10.2.0\flash growing to its max size.

Our workaround has been to use the command: SQL> alter system set db_recovery_file_dest_size=8G scope=both;
We have expanded the size from 2GB, to 4, to 6, and now to 8. Once we expand the log file max size, the program works again. The problem is obvious, that this is only a temporary workaround and we need a permanent fix to purge the file so we do not need to increase the size every time the program crashes.

Unfortunately we have product support, but they will not support the oracle side, so I am looking for a way to resolve this issue such as a script that will purge files that I can run as a weekly task, so it will keep the file from reaching it's max. Thanks in advance.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros