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.