Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Archive log destion space full

Nirav_JoshiFeb 25 2016 — edited Mar 1 2016

Hi All,

I'm Using Oracle 11.2.0.3 64 bit SE1 on Windows 2008 R2 64 bit.

Last night i received alert from Oracle Enterprise Manager "81% of archive area D:\OracleDB_Mounts\Archive_Primary\MAINPROD\Archivefiles is used." and delete archive log sysdate -2 (approx 150 gigs) from both destination but that space not reflect on OEM and today morning got second error "91% of archive area D:\OracleDB_Mounts\Archive_Primary\MAINPROD\Archivefiles is used.".

Now i check the underlying space on disk and shocked because we used NETAPPS and mapped the LUNs with server having 1.9 TB space, Now this case becoming interesting because when i checked the space occupied by archive file i saw 161 gigs occupied.

guy's need your help in this.

If D:\OracleDB_Mounts\Archive_Primary\MAINPROD\Archivefiles having 1.9 TB space and from that oracle used only 161 gigs than why oracle EM show me 91% full. is it false error from oracle EM ?

Thanks

Nirav

This post has been answered by Nirav_Joshi on Mar 1 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2016

Added on Feb 25 2016

#general-database-discussions

26 comments

28,892 views