Re: RMAN: Delete obsolete backups but not obsolete archivelogs

From: <johnbhurley_at_sbcglobal.net>
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

Original text of this message