[ 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