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: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Tue, 7 Nov 2006 18:05:03 -0500
Message-ID: <367369f10611071505l79410a76gbfb0a48a52df1613@mail.gmail.com>


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-l
Received on Tue Nov 07 2006 - 17:05:03 CST

Original text of this message

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