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@]

ITPub博客

通过RMAN不提示删除archivelog Script（支持多个Instance)

最新文章