Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN delete all input

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      



Sponsored Link

Try Netflix today! With plans starting at only $5.99 a month what are you waiting for?
--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 07 2006 - 16:52:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US