RE: RMAN delete all input

Ranko,

The issue might be with you using the FRA and how you have things configured. What are the settings of the FRA parameters and the LOG_ARCHIVE_DEST_n parameters? If you have multipule log_archive_dest parameter settings AND you are using the FRA, then ONE of those has to be set to a value that indicates that it should use the FRA as seen here:

alter system set log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST';

My guess is your system is not configured this way. If it is not, add this setting and see if that helps.

Robert Freeman
Oracle Press Author
Oracle Database 10g RMAN Backup and Recovery Oracle Database 10g New Features
Portable DBA: Oracle
Oracle9i New Features

 -----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 4:38 PM To: Ranko Mosic
Cc: oracle-l
Subject: Re: RMAN delete all input

  Apologies I misread your question.
  I have tried to reproduce this problem but as   seen in the attached output the problem does not reproduce at my end on 10.2.0.2
  i.e (archivelogs get deleted from both destinations)

  Is your database a RAC database on Standard Edition?

  Regards,
  Fairlie

  Ranko Mosic <ranko.mosic_at_gmail.com> wrote:     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 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 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/ContractSeniorOracleDBARankoMosicM ain.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?
>
>

    --
    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

  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