Sunday, May 15, 2011

RMAN Script: Deleting the old archives when no catalog exists


[ call_catdb_archflush.scp]
#!/bin/ksh
export ORACLE_HOME="/u01/app/oracle/product/10.2.0"
export ORACLE_SID="catdb"
PATH=$PATH:$ORACLE_HOME/bin
rman target sys/password@catdb cmdfile='/u04/catdb/scripts/catdb_archflush.scp'
exit                 
[ catdb_archflush.scp]
run
{
allocate channel c1 type disk;
delete archivelog until time 'SYSDATE-8';
        # OR delete archivelog until sequence=;
release channel c1;

No comments:

Post a Comment