Re: RMAN delete all input
- From: fairlie rego <fairlie_r@xxxxxxxxx>
- To: Ranko Mosic <ranko.mosic@xxxxxxxxx>
- Date: Tue, 7 Nov 2006 15:38:26 -0800 (PST)
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@xxxxxxxxx> 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@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
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)
Other related posts:
