Environment: Windows 2003, Oracle 10gR2 standard, ASM, RMAN

Question: How can we execute asmcmd commands (like rm) in batch. I am trying to write a script that I can schedule on windows to clear old archive logs from asm database.

Any help is appreciated.

-----------------

I am not sure, what value should I set for RMAN's RETENTION POLICY. The plan is to do daily full backup of many 5-10 gb dbs to tape.

This is what I am planning to use for my PROD environment:

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '\tape0\_SID__%F';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2000 M;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\oracle\product\10g\admin\TST01\DBA\RMAN\Temp\SNAPCTL.ORA';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

CONFIGURE DEFAULT DEVICE TYPE TO sbt;


--rman backup script

Crosscheck backup;
Crosscheck archivelog all;
Backup database plus archivelog;
list backup summary;
Report unrecoverable;
Report obsolete orphan;
spool log off