cat $ORACLE_HOME/sidlist
FAB1STB
APPSTB

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

#!/bin/sh
export ORACLE_HOME=/ora104/10.2
for SID in `cat $ORACLE_HOME/sidlist`
do
export ORACLE_SID=${SID}
$ORACLE_HOME/bin/rman <connect target /
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog until time 'sysdate-1';
exit;
EOF
done

[@more@]

透過RMAN不提示刪除archivelog Script（支援多個Instance)

相關文章