Purging Activities

Purging Activities for logs:

Total space to check:

/u01/orasoft/VISappl/ad/11.5.0>df -h


Over all check should be done for the following :

Directoried Before Purge After Purge
Visdb 63 G 7.6 G
Visora 6 G 6 G
Visappl 20 G 20 G
Viscomn 83 G 40 G


Checking To be done in Database level.


1. Check for the alert log files, bdump.udump
2. Navigate to $ORACLE_HOME/admin/$CONTEXT_NAME/
3. du –h * -> to see all the files size inside that.
4. To check Particular dir . Go inside that directory and check by du –h .
5. Now check udump trace files count and from when it was there , by
6. ls –lrt wc –l
7. ls –lrtmore
8. Output :

total 74927228

-rw-r--r-- 1 applmgr dba 73 Feb 1 2007 Errors0.log
-rw-r--r-- 1 applmgr dba 6489 Feb 1 2007 02010901.log
-rw-r--r-- 1 applmgr dba 1698 Feb 1 2007 l7825627.req
-rw-r--r-- 1 applmgr dba 2058 Feb 1 2007 l7816585.req
-rw-r--r-- 1 applmgr dba 1608 Feb 1 2007 l7830923.req
-rw-r--r-- 1 applmgr dba 1455 Feb 1 2007 l7830681.req
-rw-r--r-- 1 applmgr dba 1368 Feb 1 2007 l7830682.req


Note : Login as Oracle User.

Checking To be done in Apps Level :

1. Check the $APPLCSF/log
2. To Purge $APPLCSF/log
3. Login as Applmgr user
4. Manually use the command for purge the logs which are older than 30 days.

5. /u01/orasoft/Viscomn/admin/log>find . -mtime +30 -exec rm {} \;

Note : In Front end Puge concurrent Request is scheduled so it clears from FND table. But physically it will be there, so use the above steps to remove.This 30 means , It will keep for 30 days logs and older then that will be purged.


2. Check for $APPLCSF/out

$APPLCSF/out start from date:

/u01/ VIScomn/admin/out/VIS_VIS_sys38>ls -lrt more

total 8025832

-rw-r--r-- 1 applmgr dba 852 Jan 23 2008 o8632542.out
-rw-r--r-- 1 applmgr dba 2052 Jan 23 2008 o8632020.out
-rw-r--r-- 1 applmgr dba 0 Jan 23 2008 o8631500.out


3. Ad_logs starts from:

/u01/ VISappl/admin/VIS_sys38/log>ls -lrt more

total 736776

-rw-r--r-- 1 applmgr dba 5900192 Feb 15 2006 adaimgr_08102005_00.log
-rw-r--r-- 1 applmgr dba 21273464 Feb 15 2006 adwork002.log
-rw-r--r-- 1 applmgr dba 32952381 Feb 15 2006 adwork001.log
-rw-r--r-- 1 applmgr dba 19349015 Feb 15 2006 adwork003.log

Now Purge this as required.