on 10-19-2012 3:11 AM
Hi All,
What could be the reason for oraarch directory to get full at high rate?
In one of our system, oraarch is of 60gb total space. It is getting full in a very short interval of time once after every brarchive backup of 30minutes.
Thanks for your help in advance.
Regards
Shanthosh
The database writes the transaction logs (offline redo logs) to the oraarch directory. This means you have a huge amount of data changed on your system. Selects don't create transaction logs only insert/update/deletes.
You have to find who or what is causing these changes and if they are really necessary. Here is an older thread with a similar problem: http://scn.sap.com/thread/1867981
Cheers Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SAP system? BW or ERP? any active event during the time? SP update, data load/migration?
In one of our system, oraarch is of 60gb total space. It is getting full in a very short interval of time once after every brarchive backup of 30minutes.
60GB within less than 30 minutes means heavy transactions in your database. Have you try to find out what transactions were running during that particular time? e.g. check your alert file for when directory full alert happened then go to sm37 to find which background jobs active during that time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.