oracle删除连接数,shell脚本之查看oracle连接数 、删除备库已经应用的归档

. /home/oracle/.profile

if [ $# != 1 ]; then

echo ""Please input ORACLE SID !!!""

exit;

fi

export ORACLE_SID=$1

echo $ORACLE_SID

sqlplus -s '/ as sysdba' << ! > /home/oracle/work/old_arch_${ORACLE_SID}.dat

set feedback off

set heading off

set linesize 200

select name from v\$archived_log where FIRST_TIME < sysdate - 8/24

and APPLIED='YES';

!

>/home/oracle/work/old_arch_${ORACLE_SID}.sh

cat /home/oracle/work/old_arch_${ORACLE_SID}.dat|while read line

do

if [ ""$line"" ];then

if [ -f $line ];then

echo ""rm $line"" >> /home/oracle/work/old_arch_${ORACLE_SID}.sh

fi

fi

done

*************************

shell 拆分为如下

*************************

查询的name写入到一个文件当中

sqlplus -s '/ as sysdba' << ! > /tmp/datafile_${ORACLE_SID}.dat

set feedback off

set heading off

set linesize 200

set pagesize 300

select distinct object_type from dba_objects;

!

在生成的name上加上rm

cat /tmp/datafile_rac1.dat|while read line

do

echo ""rm $line"" >> /tmp/rm.sh

done