Database hangs due to full archive dest
AbhayKDec 18 2009 — edited Jun 16 2010Hi All;
Today Morning my database went in Hang status as my archive location of the production database was full.
there was 30g Space avaliable on the on archiveloation last night.
When we checked we found around 360 logs were generated between 6 to 6.30 & location went full, Only 20 logs get generated during this time daily.
We are checking if any change was made in the night jobs yestarday & also the report of that period.
Is there is any other way to find out why more archives generated then normal
Database =10g
OS =AIX 64 bit
Thanks,