Monday, September 30, 2013

Crontab delete Archivelog

#!/bin/bash

for i in DB1 DB2 ;
do
. oraenv << EOI
$i
EOI
rman target /   << EOI
sql "alter system switch logfile";
delete noprompt archivelog until time 'SYSDATE-7';
EOI
done;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ALCATEL 6900

write memory copy running certified reload from working no rollback-timeout