Wednesday 17 July 2013

Old Files deletion

find /u02/lax_backup_newexis/*.dmp -mtime +10 -exec rm {} \;

------------------------------------------------------------------------------------------------------------

#!/bin/bash

clear
######################################################################
#################### old File Deletion ###############################
#################### dba.amr@gmail.com ###############################

export PATH
# Oracle ENV
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/opt/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

find /home/oracle/logicalbak/ -name '*.dmp*' -mtime +60 -exec rm {} \;
find /home/oracle/logicalbak/ -name '*.log*' -mtime +60 -exec rm {} \;

No comments:

Post a Comment