Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN delete all input
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 <fairlie_r_at_yahoo.com> 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 <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?
>
>
-- 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-lReceived on Tue Nov 07 2006 - 17:05:03 CST
![]() |
![]() |