Want to backup all archivelogs in the archivelog destination but want to retain the last 24hrs out there and delete the rest to preserve space. Will this work? Can I have multiple statements about the archivelog for each channel? In the example below, first archivelog statement backs the last 24hrs, the second backs everything else and then deletes it (which should only delete archivelogs > 24hrs) for each node. If there are any suggestions, please help!
run {
allocate channel 'dev_0' type 'sbt_tape' connect internal/oracle@cprod1
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=cprod1,OB2BARLIST=al_cprod)';
allocate channel 'dev_1' type 'sbt_tape' connect internal/oracle@cprod2
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=cprod1,OB2BARLIST=al_cprod)';
sql 'alter system archive log current';
backup incremental level <incr_level> filesperset 4
format 'al_cprod<cprod1_%s:%t:%p>.dbf'
(archivelog from time 'SYSDATE-1' like '/u02/oracle/admin/cprod/arch/cprod1/cprod%' )
(archivelog until time 'SYSDATE-1' like '/u02/oracle/admin/cprod/arch/cprod1/cprod%' delete input channel 'dev_0')
(archivelog from time 'SYSDATE-1' like '/u02/oracle/admin/cprod/arch/cprod2/cprod%' )
(archivelog until time 'SYSDATE-1' like '/u02/oracle/admin/cprod/arch/cprod2/cprod%' delete input channel 'dev_1')
;
}
run {
allocate channel 'dev_0' type 'sbt_tape' connect internal/oracle@cprod1
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=cprod1,OB2BARLIST=al_cprod)';
allocate channel 'dev_1' type 'sbt_tape' connect internal/oracle@cprod2
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=cprod1,OB2BARLIST=al_cprod)';
sql 'alter system archive log current';
backup incremental level <incr_level> filesperset 4
format 'al_cprod<cprod1_%s:%t:%p>.dbf'
(archivelog from time 'SYSDATE-1' like '/u02/oracle/admin/cprod/arch/cprod1/cprod%' )
(archivelog until time 'SYSDATE-1' like '/u02/oracle/admin/cprod/arch/cprod1/cprod%' delete input channel 'dev_0')
(archivelog from time 'SYSDATE-1' like '/u02/oracle/admin/cprod/arch/cprod2/cprod%' )
(archivelog until time 'SYSDATE-1' like '/u02/oracle/admin/cprod/arch/cprod2/cprod%' delete input channel 'dev_1')
;
}