Re: RMAN: Delete obsolete backups but not obsolete archivelogs
Date: Fri, 8 May 2009 15:42:06 -0700 (PDT)
Message-ID: <b565772e-71e0-415d-ba56-df99ae0b4b62_at_z19g2000vbz.googlegroups.com>
On May 8, 12:31 pm, "hea..._at_googlemail.com" <hea..._at_googlemail.com> wrote:
snip
> Thanks John, ill better put myself a shell script together then.
> I'll get this posted on metalink as a product enhancement request
> after I've read what later rman versions do.
My script does the pretty basic invoking of sqlplus and spooling a file ... then another step to move the archivelogs elsewhere ... aka ... stuff like this ...
export ORACLE_SID=???
rm -f /tmp/spool_obsolete_archivelogs.txt
sqlplus / as sysdba << EOF
_at_spool_???_obsolete_archivelogs.sql
exit;
EOF
cp spool_obsolete_archivelogs.txt /tmp/spool_obsolete_archivelogs.txt
echo " List is ..."
cat /tmp/spool_obsolete_archivelogs.txt
$ more spool_????_obsolete_archivelogs.sql
set ECHO OFF
set TERMOUT OFF
set FEEDBACK OFF
set VERIFY OFF
set PAGESIZE 0
set HEADDING OFF
spool spool_obsolete_archivelogs.txt
select fname from v$backup_files where file_type='ARCHIVED LOG' and
status='AVAI
LABLE' and obsolete='YES';
spool off
Received on Fri May 08 2009 - 17:42:06 CDT