troubleshooting Question

Oracle log files which are not getting flush ( size is increasing continuously)

Avatar of srinivas_ganamur
srinivas_ganamur asked on
Oracle DatabaseEnterprise Software
25 Comments1 Solution801 ViewsLast Modified:
Hi,

Currently i am facing below issue, please give me solution ASAP.

We have SFMS application for message based fund transfer given by IDRBT.
There is automated procedure for archiving of history data in this application, which scheduled daily basis.

The application is on Win2000 advance server and uses Oracle 9i database.

The error is while archiving the data from live tables to archive tables in archiving file.
Due to this archiving the data (moving) from live tables and file to Archive tables and file is not happening and the data size in live tables is increasing.
 
I am attaching both Oracle trc file and application log file for your reference. It shows the file name and no. and the block no. which is corrupt. Also it is showing the Oracle error code.
ApplicationLogFile.txt
sfms-ora-9064.txt
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 25 Comments.
Join the Community
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 1 Answer and 25 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