#!/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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/27042095/viewspace-748116/，如需轉載，請註明出處，否則將追究法律責任。

上一篇：物理standby database的日常維護

下一篇： 10g 新特性快改變跟蹤

請登入後發表評論登入

全部評論

perfychi

註冊時間：2012-06-06

博文量
484
訪問量

2902125

保留最近的2個歸檔

最新文章

相關文章