保留最近的2个归档

#!/bin/bash

. /home/oracle/.bash_profile

keep=2
seq=`sqlplus  -S / as sysdba <
set pagesize 0  feedback off linesize 200 echo off termout off trimspool on
select max(sequence#)-$keep from v\\$archived_log;
exit
EOF`

rman target / <
delete noprompt archivelog  until sequence $seq;
exit;
<
----------------------------------------------------------------------------------


#!/bin/bash

. /home/oracle/.bash_profile

keep=2
seq=`sqlplus  -S / as sysdba <
set pagesize 0  feedback off linesize 200 echo off termout off trimspool on
select max(sequence#)-$keep from v\\$archived_log;
exit
EOF`

rman target / <
delete noprompt archivelog  high sequence $seq;
exit;


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


#!/bin/bash

. /home/oracle/.bash_profile

keep=2
seq=`sqlplus  -S / as sysdba <
set pagesize 0  feedback off linesize 200 echo off termout off trimspool on
select max(sequence#)-$keep from v\\$archived_log;
exit
EOF`

rman target / <
delete noprompt archivelog  high logseq $seq;
exit;
<

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


#!/bin/bash

. /home/oracle/.bash_profile

keep=2
seq=`sqlplus  -S / as sysdba <
set pagesize 0  feedback off linesize 200 echo off termout off trimspool on
select max(sequence#)-$keep from v\\$archived_log;
exit
EOF`

rman target / <
delete noprompt archivelog  until logseq $seq;
exit;
<

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

 上面都是可以的,综上所述: ("<=>" 表示等价)
logseq  <=> sequence
low <=> from   (low与high成对出现,from与until成对出现)
high <=> until