删除归档，保留最近的5个归档日志

. /home/oracle/.bash_profile
export ORACLE_SID=compiere

 # echo $STATUS

    LOG_SEQUENCE=`sqlplus -s sys/H2oiswater as sysdba <                        set pagesize 0
                        set feedback off
                        set trimspool on
                        set linesize 1000
                        set heading off
                        set termout off
                        select max(sequence#)-5 from v\\$archived_log ;
                         exit;
                      !
                   `
echo $LOG_SEQUENCE

#删除 归档是在rman里用名利删除，不能要在操作系统上直接删除
     l_rman_st=`rman target sys/HHHr <                 delete force noprompt archivelog high sequence $LOG_SEQUENCE;
                 exit;
                !
               `

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27042095/viewspace-746288/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27042095/viewspace-746288/