RE: RMAN delete all input

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 7 Nov 2006 17:58:57 -0700
Message-ID: <KEEDIPJOJLCHPPAIDPDOAECHCMAA.robertgfreeman@yahoo.com>

This document is a bit aged, and appears to apply to 8i (8.1.6). I'm fairly certain that this is not the current behavior, but if I get some time I'll test it.

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of fairlie rego   Sent: Tuesday, November 07, 2006 3:52 PM   To: ranko.mosic_at_gmail.com
  Cc: oracle-l
  Subject: Re: RMAN delete all input

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/ContractSeniorOracleDBARankoMo sicMain.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 - 18:58:57 CST