Re: RMAN delete all input

  • From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
  • To: "fairlie rego" <fairlie_r@xxxxxxxxx>
  • Date: Tue, 7 Nov 2006 18:05:03 -0500

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@xxxxxxxxx> 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@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/ContractSeniorOracleDBARankoMosicMain.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?




--
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/ContractSeniorOracleDBARankoMosicMain.html
--
//www.freelists.org/webpage/oracle-l


Other related posts: