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



          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?


SQL> show parameter log_archive_dest_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=C:\oracle\product\10.
                                                 2.0\oradata\USYD\arch
log_archive_dest_10                  string
log_archive_dest_2                   string      LOCATION=C:\temp
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable


--Generate some archivelogs
SQL> alter system archive log current;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /
C:\temp>dir *.DBF
 Volume in drive C has no label.
 Volume Serial Number is A44B-7DF6

 Directory of C:\temp

25/10/2006  02:34 PM           455,680 1_137_600609988.DBF
25/10/2006  02:34 PM             1,024 1_138_600609988.DBF
08/11/2006  10:22 AM        47,029,760 1_182_600609988.DBF
08/11/2006  10:22 AM             6,144 1_183_600609988.DBF
08/11/2006  10:22 AM             4,096 1_184_600609988.DBF
08/11/2006  10:22 AM             1,536 1_185_600609988.DBF
08/11/2006  10:22 AM             1,024 1_186_600609988.DBF
08/11/2006  10:23 AM           126,976 1_187_600609988.DBF
08/11/2006  10:25 AM            24,064 1_188_600609988.DBF
08/11/2006  10:26 AM            25,600 1_189_600609988.DBF
              10 File(s)     47,675,904 bytes
               0 Dir(s)  57,998,131,200 bytes free
               
RMAN> backup
2>     filesperset 100
3>     format 'C:\temp\backup_%d_archive_%U_%t'
4>        archivelog all delete all input;

Starting backup at 08/NOV/06
   
archive log filename=C:\TEMP\1_189_600609988.DBF recid=85 stamp=605960763
Finished backup at 08/NOV/06

RMAN> exit

Recovery Manager complete.
  
After the backup is complete check that the log files exist...

C:\temp>dir *.DBF
 Volume in drive C has no label.
 Volume Serial Number is A44B-7DF6

 Directory of C:\temp

25/10/2006  02:34 PM           455,680 1_137_600609988.DBF
25/10/2006  02:34 PM             1,024 1_138_600609988.DBF
               2 File(s)        456,704 bytes
               0 Dir(s)  60,129,140,736 bytes free
               
As you can see all files generated today have been deleted. (Just ignnore the Oct log files)

--
http://www.freelists.org/webpage/oracle-l