Re: RMAN: Delete obsolete backups but not obsolete archivelogs
Date: Fri, 8 May 2009 15:42:06 -0700 (PDT)
On May 8, 12:31 pm, "hea..._at_googlemail.com" <hea..._at_googlemail.com> wrote:
> 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 ...
rm -f /tmp/spool_obsolete_archivelogs.txt sqlplus / as sysdba << EOF
cp spool_obsolete_archivelogs.txt /tmp/spool_obsolete_archivelogs.txt echo " List is ..."
$ more spool_????_obsolete_archivelogs.sql
set ECHO OFF
set TERMOUT OFF
set FEEDBACK OFF
set VERIFY OFF
set PAGESIZE 0
set HEADDING OFF
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