I run hotbackup daily via RMAN/Data Protector on 9i and 10g environments. I want to ensure that the RMAN script is written optimally so that it backups PFILE/SPFILE and all the archive logs. I want backup all the archive logs in /arch via RMAN and keep 3 days of archive logs and not delete them but back it up. will the following command work?
[/CODE:]
run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
allocate channel 'dev_4' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=Argprd01,OB2BARLIST=RMAN_ARGPRD01_Online)';
backup incremental level filesperset 1
format 'RMAN_ARGPRD01_Online.dbf'
database
include current controlfile
include spfile
;
backup filesperset 1
format 'RMAN_ARGPRD01_Online.dbf'

archivelog all delete input from 'sysdate - 3'
--backup archivelog delete input from 'sysdate - 3'

or
archive log all delete archivelog until time='sysdate-3';
[code:]
thanks