删除归档,保留最近的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;
                !
               `
请使用浏览器的分享功能分享到微信等