Re: RMAN delete all input

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Tue, 7 Nov 2006 14:52:06 -0800 (PST)
Message-ID: <20061107225206.44422.qmail@web31908.mail.mud.yahoo.com>

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_at_gmail.com> 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_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
--

http://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