RE: RMAN delete all input

  • From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 7 Nov 2006 17:58:57 -0700

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.


RF

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of fairlie rego
  Sent: Tuesday, November 07, 2006 3:52 PM
  To: ranko.mosic@xxxxxxxxx
  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@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/ContractSeniorOracleDBARankoMo
sicMain.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?

Other related posts: