Flashback is configured, Robert. Fairlie, yes, but note 135303.1 says: Using the 'delete all input' command, RMAN will backup a single copy of each archived log from an available destination and a log that passes RMAN's corruption check.It will then delete all archived logs backed up in the backupsets from all destinations. Thanks, Ranko. On 11/7/06, fairlie rego <fairlie_r@xxxxxxxxx> wrote:
Ranko, From ML note 144363.1 RMAN deletes only one copy of each input log, so even if you archive to five destinations, RMAN deletes logs from only one directory. RMAN is inconsistent from which directory (Dest1, Dest2, etc.) it will delete a particular log. Thanks Fairlie Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote: Hi List, 10g/Solaris 5.9 I am trying to delete archive log files from secondary archive log destination using: backup filesperset 100 format 'backup_%d_archive_%U_%t' archivelog all delete all input; This should remove backed up archive logs from both archive destinations once they are backed up. Files are removed from log_archive_dest_1 only though. Any ideas ? -- Regards, Ranko Mosic Contract Senior Oracle DBA B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785 email: mosicr@xxxxxxxxxx http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html -- //www.freelists.org/webpage/oracle-l Fairlie Rego Senior Oracle Consultant http://www.linkedin.com/in/fairlierego http://el-caro.blogspot.com/ M: +61 402 792 405 ________________________________ Sponsored Link Try Netflix today! With plans starting at only $5.99 a month what are you waiting for?
-- Regards, Ranko Mosic Contract Senior Oracle DBA B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785 email: mosicr@xxxxxxxxxx http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html -- //www.freelists.org/webpage/oracle-l