>>>>>>>>> rman_archivelog.bat <<<<<<<<
cd /d D:\app\product\11.2.0\dbhome_1\BIN
rman target sys/oracle@BRSSTBY catalog rman/rman001@rmandb @‘F:/delete.rmn‘
>>>>>>>>> execution script: delete.rmn <<<<<<
run{
allocate channel t1 device type disk;
delete noprompt archivelog until time ‘sysdate-1‘;
DELETE FORCE NOPROMPT OBSOLETE;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
release channel t1;
}
They have to be separate when done .
#!/bin/sh
. /u01/app/oracle/.profile1
${ORACLE_HOME}/bin/rman <<EOF
connect target sys/syspassword@cricprod_prim
connect auxiliary sys/syspassword@cricprod_logstdby
show all;
EOF
*********************************************************
http://www.oracle-base.com/articles/misc/oracle-shell-scripting.php