Oracle 11gR2 RMAN Batch Script

>>>>>>>>> Rman_archivelog.bat <<<<<<<<

CD/D D:\app\product\11.2.0\dbhome_1\BIN
Rman Target sys/[email protected] Catalog rman/[email protected] @ ' 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 has the separate when done.

#!/bin/sh

. /u01/app/oracle/.profile1

${oracle_home}/bin/rman <<EOF

Connect Target Sys/[email Protected]_prim

Connect Auxiliary sys/[email Protected]_logstdby

Show All;

Eof

*********************************************************

http://www.oracle-base.com/articles/misc/oracle-shell-scripting.php

Oracle 11gR2 RMAN Batch script