Home » RDBMS Server » Backup & Recovery » Delete obsolete backups using rman (oracle 9i on AIX5.3)
Delete obsolete backups using rman [message #514416] Mon, 04 July 2011 12:04 Go to next message
hhhaithamhany
Messages: 5
Registered: July 2011
Junior Member
Hi all,

I have a problem in running delete obsolete or report obsolete using rman. Although the retention policy is set to "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;", when running delete obsolete or report obsolete it deletes or returns all the backupsets till sysdate. What should I do to solve this issue?

Thanks a lot

Haitham Hany
Re: Delete obsolete backups using rman [message #514418 is a reply to message #514416] Mon, 04 July 2011 12:07 Go to previous messageGo to next message
BlackSwan
Messages: 22688
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Delete obsolete backups using rman [message #514422 is a reply to message #514418] Mon, 04 July 2011 12:36 Go to previous messageGo to next message
hhhaithamhany
Messages: 5
Registered: July 2011
Junior Member
Thank you for your reply

I'll try to follow the posting preferences.
Re: Delete obsolete backups using rman [message #514437 is a reply to message #514422] Mon, 04 July 2011 13:42 Go to previous messageGo to next message
hhhaithamhany
Messages: 5
Registered: July 2011
Junior Member
We have oracle 9i 9.2.0.8.0 installed on AIX system version 5.3. Our system is configured to take backups on Tape library using TSM server.
We take backups using RMAN utility. The configuration of RMAN is:
--------------------------------------------------------------------------------
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/arch/backup/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo64.opt)';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/arch/backup/ora_df%t_s%s_s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/9.2.0.1.0/dbs/snapcf_ltsc.f'; # default

-----------------------------------------------------------------------------------------------------------------------------

When typing report obsolete command on rman the output lists all the backups that we have on the tape.
When executing delete obsolete all the backup sets are deleted.

We want to keep 60 days as our retention policy.
Is there any missing configuration in rman?

Thanks a lot

Haitham Hany

[Updated on: Wed, 06 July 2011 21:34] by Moderator

Report message to a moderator

Re: Delete obsolete backups using rman [message #514716 is a reply to message #514437] Wed, 06 July 2011 01:12 Go to previous messageGo to next message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
Show us the Backup Script and output from a run of the Backup script.
Does the script run daily ?
Is there a separate Weekly / Monthly backup ? Is that a separate script ?


Hemant K Chitale
Re: Delete obsolete backups using rman [message #514837 is a reply to message #514716] Wed, 06 July 2011 14:37 Go to previous messageGo to next message
hhhaithamhany
Messages: 5
Registered: July 2011
Junior Member
We run incremental backup everyday except on Fridays we run full backup and on Tuesdays we run cumulative backup. However we run "delete obsolete" every month manually.

Incremental backup script:
------------------------------------------ 
delete backup completed before 'sysdate-2' device type disk;
backup incremental level 1  device type disk database filesperset 6;
backup backupset all;
backup archivelog all delete all input;
------------------------------------------

Cumulative backup script:
------------------------------------------
delete backup completed before 'sysdate-2' device type disk;
backup incremental level 1 cumulative device type disk database filesperset 6;
backup backupset all;
backup archivelog all delete all input;
------------------------------------------

Full backup script:
------------------------------------------
BACKUP INCREMENTAL LEVEL 0 DATABASE FILESPERSET 6;
backup archivelog all delete all input;
-------------------------------------------


This is the output of last full backup taken:
---------------------------------------------

Recovery Manager: Release 9.2.0.8.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: LTSC (DBID=1864519587)
using target database controlfile instead of recovery catalog

RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE FILESPERSET 6;
2> backup archivelog all delete all input;
3> #BACKUP ARCHIVELOG from time 'sysdate-3' until time 'sysdate';
4> #delete ARCHIVELOG UNTIL TIME 'SYSDATE-3';
5> 
Starting backup at 01-JUL-11
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=989 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Tivoli Data Protection for Oracle: version 5.2.0.0
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00064 name=/ltscprd2/oradata2/UNDO1.dbf
input datafile fno=00024 name=/ltscprd1/oradata1/system02.dbf
input datafile fno=00001 name=/ltscprd1/oradata1/system01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 01-JUL-11
channel ORA_SBT_TAPE_1: finished piece 1 at 01-JUL-11
piece handle=jbmgaqf0_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:05:25
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00014 name=/ltscprd2/oradata2/so2_indx_8k_04.dbf
input datafile fno=00009 name=/ltscprd1/oradata1/so2_data_8k_02.dbf
input datafile fno=00012 name=/ltscprd1/oradata1/so2_data_8k_05.dbf
input datafile fno=00005 name=/ltscprd2/oradata2/so2_indx_sm_01.dbf
input datafile fno=00023 name=/ltscprd2/oradata2/rsb_indx01.dbf
input datafile fno=00025 name=/ltscprd2/oradata2/rsb_indx02.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 01-JUL-11
channel ORA_SBT_TAPE_1: finished piece 1 at 01-JUL-11
piece handle=jcmgaqp6_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:08:25
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00015 name=/ltscprd2/oradata2/so2_indx_8k_05.dbf
input datafile fno=00017 name=/ltscprd2/oradata2/so2_indx_8k_07.dbf
input datafile fno=00011 name=/ltscprd1/oradata1/so2_data_8k_04.dbf
input datafile fno=00008 name=/ltscprd1/oradata1/perfstat02.dbf
input datafile fno=00055 name=/ltscprd1/oradata1/ltscdata01.dbf
input datafile fno=00019 name=/ltscprd1/oradata1/bobject1.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 01-JUL-11
channel ORA_SBT_TAPE_1: finished piece 1 at 01-JUL-11
piece handle=jdmgar8v_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:08:45
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00016 name=/ltscprd2/oradata2/so2_indx_8k_06.dbf
input datafile fno=00018 name=/ltscprd1/oradata1/so2_data_8k_06.dbf
input datafile fno=00021 name=/ltscprd1/oradata1/rsb_data01.dbf
input datafile fno=00022 name=/ltscprd1/oradata1/rsb_data02.dbf
input datafile fno=00006 name=/ltscprd2/oradata2/so2_indx_sm_02.dbf
input datafile fno=00020 name=/ltscprd2/oradata2/tools01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 01-JUL-11
channel ORA_SBT_TAPE_1: finished piece 1 at 01-JUL-11
piece handle=jemgarpc_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:10:05
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00053 name=/ltscprd2/oradata2/so2_indx_8k_01.dbf
input datafile fno=00010 name=/ltscprd1/oradata1/so2_data_8k_03.dbf
input datafile fno=00026 name=/ltscprd1/oradata1/so2_data_8k_07.dbf
input datafile fno=00003 name=/ltscprd1/oradata1/so2_data_sm_01.dbf
input datafile fno=00007 name=/ltscprd1/oradata1/perfstat01.dbf
input datafile fno=00056 name=/ltscprd1/oradata1/ltscdata02.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 01-JUL-11
channel ORA_SBT_TAPE_1: finished piece 1 at 01-JUL-11
piece handle=jfmgasc9_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:08:15
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00054 name=/ltscprd2/oradata2/so2_indx_8k_02.dbf
input datafile fno=00013 name=/ltscprd2/oradata2/so2_indx_8k_03.dbf
input datafile fno=00002 name=/ltscprd1/oradata1/so2_data_8k_01.dbf
input datafile fno=00004 name=/ltscprd1/oradata1/so2_data_sm_02.dbf
input datafile fno=00057 name=/ltscprd2/oradata2/ltscindx01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 01-JUL-11
channel ORA_SBT_TAPE_1: finished piece 1 at 01-JUL-11
piece handle=jgmgasro_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:08:25
Finished backup at 01-JUL-11

Starting Control File Autobackup at 01-JUL-11
piece handle=c-1864519587-20110701-00 comment=API Version 2.0,MMS Version 5.2.0.0
Finished Control File Autobackup at 01-JUL-11

Starting backup at 01-JUL-11
current log archived
using channel ORA_SBT_TAPE_1
skipping archive log file /arch/archltsc/arch22992.arc; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting archive log backupset
channel ORA_SBT_TAPE_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=22993 recid=46617 stamp=755154020
input archive log thread=1 sequence=22994 recid=46619 stamp=755158224
input archive log thread=1 sequence=22995 recid=46621 stamp=755162161
input archive log thread=1 sequence=22996 recid=46623 stamp=755164932
input archive log thread=1 sequence=22997 recid=46625 stamp=755170603
input archive log thread=1 sequence=22998 recid=46627 stamp=755173010
input archive log thread=1 sequence=22999 recid=46629 stamp=755179064
input archive log thread=1 sequence=23000 recid=46631 stamp=755182212
input archive log thread=1 sequence=23001 recid=46633 stamp=755183614
input archive log thread=1 sequence=23002 recid=46635 stamp=755188447
input archive log thread=1 sequence=23003 recid=46637 stamp=755191738
input archive log thread=1 sequence=23004 recid=46639 stamp=755195752
input archive log thread=1 sequence=23005 recid=46641 stamp=755197174
input archive log thread=1 sequence=23006 recid=46643 stamp=755201681
input archive log thread=1 sequence=23007 recid=46645 stamp=755204394
input archive log thread=1 sequence=23008 recid=46647 stamp=755208628
input archive log thread=1 sequence=23009 recid=46649 stamp=755213430
input archive log thread=1 sequence=23010 recid=46651 stamp=755218646
input archive log thread=1 sequence=23011 recid=46653 stamp=755219000
input archive log thread=1 sequence=23012 recid=46655 stamp=755219107
input archive log thread=1 sequence=23013 recid=46657 stamp=755219211
input archive log thread=1 sequence=23014 recid=46659 stamp=755219217
input archive log thread=1 sequence=23015 recid=46661 stamp=755219266
input archive log thread=1 sequence=23016 recid=46663 stamp=755219342
input archive log thread=1 sequence=23017 recid=46665 stamp=755219399
input archive log thread=1 sequence=23018 recid=46667 stamp=755219434
input archive log thread=1 sequence=23019 recid=46669 stamp=755219485
input archive log thread=1 sequence=23020 recid=46671 stamp=755219557
input archive log thread=1 sequence=23021 recid=46673 stamp=755219603
input archive log thread=1 sequence=23022 recid=46675 stamp=755219647
input archive log thread=1 sequence=23023 recid=46677 stamp=755219711
input archive log thread=1 sequence=23024 recid=46679 stamp=755219782
input archive log thread=1 sequence=23025 recid=46681 stamp=755219964
input archive log thread=1 sequence=23026 recid=46683 stamp=755220038
input archive log thread=1 sequence=23027 recid=46685 stamp=755220092
input archive log thread=1 sequence=23028 recid=46687 stamp=755220169
input archive log thread=1 sequence=23029 recid=46689 stamp=755220249
input archive log thread=1 sequence=23030 recid=46691 stamp=755220276
input archive log thread=1 sequence=23031 recid=46693 stamp=755220354
input archive log thread=1 sequence=23032 recid=46695 stamp=755220401
input archive log thread=1 sequence=23033 recid=46697 stamp=755220521
input archive log thread=1 sequence=23034 recid=46699 stamp=755220604
input archive log thread=1 sequence=23035 recid=46701 stamp=755220721
input archive log thread=1 sequence=23036 recid=46703 stamp=755220936
input archive log thread=1 sequence=23037 recid=46705 stamp=755221028
input archive log thread=1 sequence=23038 recid=46707 stamp=755221136
input archive log thread=1 sequence=23039 recid=46709 stamp=755221387
input archive log thread=1 sequence=23040 recid=46711 stamp=755221473
input archive log thread=1 sequence=23041 recid=46713 stamp=755221509
input archive log thread=1 sequence=23042 recid=46715 stamp=755221661
input archive log thread=1 sequence=23043 recid=46717 stamp=755221891
input archive log thread=1 sequence=23044 recid=46719 stamp=755221979
input archive log thread=1 sequence=23045 recid=46721 stamp=755222117
input archive log thread=1 sequence=23046 recid=46723 stamp=755222217
input archive log thread=1 sequence=23047 recid=46725 stamp=755308808
input archive log thread=1 sequence=23048 recid=46727 stamp=755309010
input archive log thread=1 sequence=23049 recid=46729 stamp=755309133
input archive log thread=1 sequence=23050 recid=46731 stamp=755309258
input archive log thread=1 sequence=23051 recid=46733 stamp=755309489
input archive log thread=1 sequence=23052 recid=46735 stamp=755309578
input archive log thread=1 sequence=23053 recid=46737 stamp=755309726
input archive log thread=1 sequence=23054 recid=46739 stamp=755309809
input archive log thread=1 sequence=23055 recid=46741 stamp=755310028
input archive log thread=1 sequence=23056 recid=46743 stamp=755310106
channel ORA_SBT_TAPE_1: starting piece 1 at 01-JUL-11
channel ORA_SBT_TAPE_1: finished piece 1 at 01-JUL-11
piece handle=jimgatcp_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:13:36
channel ORA_SBT_TAPE_1: deleting archive log(s)
archive log filename=/arch/archltsc/arch22993.arc recid=46617 stamp=755154020
archive log filename=/arch/archltsc/arch22994.arc recid=46619 stamp=755158224
archive log filename=/arch/archltsc/arch22995.arc recid=46621 stamp=755162161
archive log filename=/arch/archltsc/arch22996.arc recid=46623 stamp=755164932
archive log filename=/arch/archltsc/arch22997.arc recid=46625 stamp=755170603
archive log filename=/arch/archltsc/arch22998.arc recid=46627 stamp=755173010
archive log filename=/arch/archltsc/arch22999.arc recid=46629 stamp=755179064
archive log filename=/arch/archltsc/arch23000.arc recid=46631 stamp=755182212
archive log filename=/arch/archltsc/arch23001.arc recid=46633 stamp=755183614
archive log filename=/arch/archltsc/arch23002.arc recid=46635 stamp=755188447
archive log filename=/arch/archltsc/arch23003.arc recid=46637 stamp=755191738
archive log filename=/arch/archltsc/arch23004.arc recid=46639 stamp=755195752
archive log filename=/arch/archltsc/arch23005.arc recid=46641 stamp=755197174
archive log filename=/arch/archltsc/arch23006.arc recid=46643 stamp=755201681
archive log filename=/arch/archltsc/arch23007.arc recid=46645 stamp=755204394
archive log filename=/arch/archltsc/arch23008.arc recid=46647 stamp=755208628
archive log filename=/arch/archltsc/arch23009.arc recid=46649 stamp=755213430
archive log filename=/arch/archltsc/arch23010.arc recid=46651 stamp=755218646
archive log filename=/arch/archltsc/arch23011.arc recid=46653 stamp=755219000
archive log filename=/arch/archltsc/arch23012.arc recid=46655 stamp=755219107
archive log filename=/arch/archltsc/arch23013.arc recid=46657 stamp=755219211
archive log filename=/arch/archltsc/arch23014.arc recid=46659 stamp=755219217
archive log filename=/arch/archltsc/arch23015.arc recid=46661 stamp=755219266
archive log filename=/arch/archltsc/arch23016.arc recid=46663 stamp=755219342
archive log filename=/arch/archltsc/arch23017.arc recid=46665 stamp=755219399
archive log filename=/arch/archltsc/arch23018.arc recid=46667 stamp=755219434
archive log filename=/arch/archltsc/arch23019.arc recid=46669 stamp=755219485
archive log filename=/arch/archltsc/arch23020.arc recid=46671 stamp=755219557
archive log filename=/arch/archltsc/arch23021.arc recid=46673 stamp=755219603
archive log filename=/arch/archltsc/arch23022.arc recid=46675 stamp=755219647
archive log filename=/arch/archltsc/arch23023.arc recid=46677 stamp=755219711
archive log filename=/arch/archltsc/arch23024.arc recid=46679 stamp=755219782
archive log filename=/arch/archltsc/arch23025.arc recid=46681 stamp=755219964
archive log filename=/arch/archltsc/arch23026.arc recid=46683 stamp=755220038
archive log filename=/arch/archltsc/arch23027.arc recid=46685 stamp=755220092
archive log filename=/arch/archltsc/arch23028.arc recid=46687 stamp=755220169
archive log filename=/arch/archltsc/arch23029.arc recid=46689 stamp=755220249
archive log filename=/arch/archltsc/arch23030.arc recid=46691 stamp=755220276
archive log filename=/arch/archltsc/arch23031.arc recid=46693 stamp=755220354
archive log filename=/arch/archltsc/arch23032.arc recid=46695 stamp=755220401
archive log filename=/arch/archltsc/arch23033.arc recid=46697 stamp=755220521
archive log filename=/arch/archltsc/arch23034.arc recid=46699 stamp=755220604
archive log filename=/arch/archltsc/arch23035.arc recid=46701 stamp=755220721
archive log filename=/arch/archltsc/arch23036.arc recid=46703 stamp=755220936
archive log filename=/arch/archltsc/arch23037.arc recid=46705 stamp=755221028
archive log filename=/arch/archltsc/arch23038.arc recid=46707 stamp=755221136
archive log filename=/arch/archltsc/arch23039.arc recid=46709 stamp=755221387
archive log filename=/arch/archltsc/arch23040.arc recid=46711 stamp=755221473
archive log filename=/arch/archltsc/arch23041.arc recid=46713 stamp=755221509
archive log filename=/arch/archltsc/arch23042.arc recid=46715 stamp=755221661
archive log filename=/arch/archltsc/arch23043.arc recid=46717 stamp=755221891
archive log filename=/arch/archltsc/arch23044.arc recid=46719 stamp=755221979
archive log filename=/arch/archltsc/arch23045.arc recid=46721 stamp=755222117
archive log filename=/arch/archltsc/arch23046.arc recid=46723 stamp=755222217
archive log filename=/arch/archltsc/arch23047.arc recid=46725 stamp=755308808
archive log filename=/arch/archltsc/arch23048.arc recid=46727 stamp=755309010
archive log filename=/arch/archltsc/arch23049.arc recid=46729 stamp=755309133
archive log filename=/arch/archltsc/arch23050.arc recid=46731 stamp=755309258
archive log filename=/arch/archltsc/arch23051.arc recid=46733 stamp=755309489
archive log filename=/arch/archltsc/arch23052.arc recid=46735 stamp=755309578
archive log filename=/arch/archltsc/arch23053.arc recid=46737 stamp=755309726
archive log filename=/arch/archltsc/arch23054.arc recid=46739 stamp=755309809
archive log filename=/arch/archltsc/arch23055.arc recid=46741 stamp=755310028
archive log filename=/arch/archltsc/arch23056.arc recid=46743 stamp=755310106
channel ORA_SBT_TAPE_1: starting archive log backupset
channel ORA_SBT_TAPE_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=23057 recid=46745 stamp=755310315
input archive log thread=1 sequence=23058 recid=46747 stamp=755310545
input archive log thread=1 sequence=23059 recid=46749 stamp=755310626
input archive log thread=1 sequence=23060 recid=46751 stamp=755310791
input archive log thread=1 sequence=23061 recid=46753 stamp=755310880
input archive log thread=1 sequence=23062 recid=46755 stamp=755311039
input archive log thread=1 sequence=23063 recid=46757 stamp=755311123
input archive log thread=1 sequence=23064 recid=46759 stamp=755311203
input archive log thread=1 sequence=23065 recid=46761 stamp=755311458
input archive log thread=1 sequence=23066 recid=46763 stamp=755311549
input archive log thread=1 sequence=23067 recid=46765 stamp=755311637
input archive log thread=1 sequence=23068 recid=46767 stamp=755311831
input archive log thread=1 sequence=23069 recid=46769 stamp=755311912
input archive log thread=1 sequence=23070 recid=46771 stamp=755312123
input archive log thread=1 sequence=23071 recid=46773 stamp=755312303
input archive log thread=1 sequence=23072 recid=46775 stamp=755312510
input archive log thread=1 sequence=23073 recid=46777 stamp=755312625
input archive log thread=1 sequence=23074 recid=46779 stamp=755312766
input archive log thread=1 sequence=23075 recid=46781 stamp=755312881
input archive log thread=1 sequence=23076 recid=46783 stamp=755313018
input archive log thread=1 sequence=23077 recid=46785 stamp=755313168
input archive log thread=1 sequence=23078 recid=46787 stamp=755313245
input archive log thread=1 sequence=23079 recid=46789 stamp=755313382
input archive log thread=1 sequence=23080 recid=46791 stamp=755313548
input archive log thread=1 sequence=23081 recid=46793 stamp=755313658
input archive log thread=1 sequence=23082 recid=46795 stamp=755313817
input archive log thread=1 sequence=23083 recid=46797 stamp=755313948
input archive log thread=1 sequence=23084 recid=46799 stamp=755314072
input archive log thread=1 sequence=23085 recid=46801 stamp=755314224
input archive log thread=1 sequence=23086 recid=46803 stamp=755314304
input archive log thread=1 sequence=23087 recid=46805 stamp=755314391
input archive log thread=1 sequence=23088 recid=46807 stamp=755314505
input archive log thread=1 sequence=23089 recid=46809 stamp=755314670
input archive log thread=1 sequence=23090 recid=46811 stamp=755314747
input archive log thread=1 sequence=23091 recid=46813 stamp=755314943
input archive log thread=1 sequence=23092 recid=46815 stamp=755315025
input archive log thread=1 sequence=23093 recid=46817 stamp=755315188
input archive log thread=1 sequence=23094 recid=46819 stamp=755315269
input archive log thread=1 sequence=23095 recid=46821 stamp=755315509
input archive log thread=1 sequence=23096 recid=46823 stamp=755315593
input archive log thread=1 sequence=23097 recid=46825 stamp=755315788
input archive log thread=1 sequence=23098 recid=46827 stamp=755315869
input archive log thread=1 sequence=23099 recid=46829 stamp=755315908
input archive log thread=1 sequence=23100 recid=46831 stamp=755316124
input archive log thread=1 sequence=23101 recid=46833 stamp=755316208
input archive log thread=1 sequence=23102 recid=46835 stamp=755316378
input archive log thread=1 sequence=23103 recid=46837 stamp=755316461
input archive log thread=1 sequence=23104 recid=46839 stamp=755316616
input archive log thread=1 sequence=23105 recid=46841 stamp=755316847
input archive log thread=1 sequence=23106 recid=46843 stamp=755316926
input archive log thread=1 sequence=23107 recid=46845 stamp=755317081
input archive log thread=1 sequence=23108 recid=46847 stamp=755317182
input archive log thread=1 sequence=23109 recid=46849 stamp=755317292
input archive log thread=1 sequence=23110 recid=46851 stamp=755317409
input archive log thread=1 sequence=23111 recid=46853 stamp=755317604
input archive log thread=1 sequence=23112 recid=46855 stamp=755317694
input archive log thread=1 sequence=23113 recid=46857 stamp=755317816
input archive log thread=1 sequence=23114 recid=46859 stamp=755317908
input archive log thread=1 sequence=23115 recid=46861 stamp=755318057
input archive log thread=1 sequence=23116 recid=46863 stamp=755318169
input archive log thread=1 sequence=23117 recid=46865 stamp=755321172
input archive log thread=1 sequence=23118 recid=46867 stamp=755329616
input archive log thread=1 sequence=23119 recid=46869 stamp=755332504
channel ORA_SBT_TAPE_1: starting piece 1 at 01-JUL-11
channel ORA_SBT_TAPE_1: finished piece 1 at 01-JUL-11
piece handle=jjmgau6e_1_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:13:06
channel ORA_SBT_TAPE_1: deleting archive log(s)
archive log filename=/arch/archltsc/arch23057.arc recid=46745 stamp=755310315
archive log filename=/arch/archltsc/arch23058.arc recid=46747 stamp=755310545
archive log filename=/arch/archltsc/arch23059.arc recid=46749 stamp=755310626
archive log filename=/arch/archltsc/arch23060.arc recid=46751 stamp=755310791
archive log filename=/arch/archltsc/arch23061.arc recid=46753 stamp=755310880
archive log filename=/arch/archltsc/arch23062.arc recid=46755 stamp=755311039
archive log filename=/arch/archltsc/arch23063.arc recid=46757 stamp=755311123
archive log filename=/arch/archltsc/arch23064.arc recid=46759 stamp=755311203
archive log filename=/arch/archltsc/arch23065.arc recid=46761 stamp=755311458
archive log filename=/arch/archltsc/arch23066.arc recid=46763 stamp=755311549
archive log filename=/arch/archltsc/arch23067.arc recid=46765 stamp=755311637
archive log filename=/arch/archltsc/arch23068.arc recid=46767 stamp=755311831
archive log filename=/arch/archltsc/arch23069.arc recid=46769 stamp=755311912
archive log filename=/arch/archltsc/arch23070.arc recid=46771 stamp=755312123
archive log filename=/arch/archltsc/arch23071.arc recid=46773 stamp=755312303
archive log filename=/arch/archltsc/arch23072.arc recid=46775 stamp=755312510
archive log filename=/arch/archltsc/arch23073.arc recid=46777 stamp=755312625
archive log filename=/arch/archltsc/arch23074.arc recid=46779 stamp=755312766
archive log filename=/arch/archltsc/arch23075.arc recid=46781 stamp=755312881
archive log filename=/arch/archltsc/arch23076.arc recid=46783 stamp=755313018
archive log filename=/arch/archltsc/arch23077.arc recid=46785 stamp=755313168
archive log filename=/arch/archltsc/arch23078.arc recid=46787 stamp=755313245
archive log filename=/arch/archltsc/arch23079.arc recid=46789 stamp=755313382
archive log filename=/arch/archltsc/arch23080.arc recid=46791 stamp=755313548
archive log filename=/arch/archltsc/arch23081.arc recid=46793 stamp=755313658
archive log filename=/arch/archltsc/arch23082.arc recid=46795 stamp=755313817
archive log filename=/arch/archltsc/arch23083.arc recid=46797 stamp=755313948
archive log filename=/arch/archltsc/arch23084.arc recid=46799 stamp=755314072
archive log filename=/arch/archltsc/arch23085.arc recid=46801 stamp=755314224
archive log filename=/arch/archltsc/arch23086.arc recid=46803 stamp=755314304
archive log filename=/arch/archltsc/arch23087.arc recid=46805 stamp=755314391
archive log filename=/arch/archltsc/arch23088.arc recid=46807 stamp=755314505
archive log filename=/arch/archltsc/arch23089.arc recid=46809 stamp=755314670
archive log filename=/arch/archltsc/arch23090.arc recid=46811 stamp=755314747
archive log filename=/arch/archltsc/arch23091.arc recid=46813 stamp=755314943
archive log filename=/arch/archltsc/arch23092.arc recid=46815 stamp=755315025
archive log filename=/arch/archltsc/arch23093.arc recid=46817 stamp=755315188
archive log filename=/arch/archltsc/arch23094.arc recid=46819 stamp=755315269
archive log filename=/arch/archltsc/arch23095.arc recid=46821 stamp=755315509
archive log filename=/arch/archltsc/arch23096.arc recid=46823 stamp=755315593
archive log filename=/arch/archltsc/arch23097.arc recid=46825 stamp=755315788
archive log filename=/arch/archltsc/arch23098.arc recid=46827 stamp=755315869
archive log filename=/arch/archltsc/arch23099.arc recid=46829 stamp=755315908
archive log filename=/arch/archltsc/arch23100.arc recid=46831 stamp=755316124
archive log filename=/arch/archltsc/arch23101.arc recid=46833 stamp=755316208
archive log filename=/arch/archltsc/arch23102.arc recid=46835 stamp=755316378
archive log filename=/arch/archltsc/arch23103.arc recid=46837 stamp=755316461
archive log filename=/arch/archltsc/arch23104.arc recid=46839 stamp=755316616
archive log filename=/arch/archltsc/arch23105.arc recid=46841 stamp=755316847
archive log filename=/arch/archltsc/arch23106.arc recid=46843 stamp=755316926
archive log filename=/arch/archltsc/arch23107.arc recid=46845 stamp=755317081
archive log filename=/arch/archltsc/arch23108.arc recid=46847 stamp=755317182
archive log filename=/arch/archltsc/arch23109.arc recid=46849 stamp=755317292
archive log filename=/arch/archltsc/arch23110.arc recid=46851 stamp=755317409
archive log filename=/arch/archltsc/arch23111.arc recid=46853 stamp=755317604
archive log filename=/arch/archltsc/arch23112.arc recid=46855 stamp=755317694
archive log filename=/arch/archltsc/arch23113.arc recid=46857 stamp=755317816
archive log filename=/arch/archltsc/arch23114.arc recid=46859 stamp=755317908
archive log filename=/arch/archltsc/arch23115.arc recid=46861 stamp=755318057
archive log filename=/arch/archltsc/arch23116.arc recid=46863 stamp=755318169
archive log filename=/arch/archltsc/arch23117.arc recid=46865 stamp=755321172
archive log filename=/arch/archltsc/arch23118.arc recid=46867 stamp=755329616
WARNING: archive log not deleted, not yet applied by standby
archive log filename=/arch/archltsc/arch23119.arc thread=1 sequence=23119
channel ORA_SBT_TAPE_1: deleting archive log(s)
archive log filename=/arch/archltsc/arch22992.arc recid=46615 stamp=755144205
Finished backup at 01-JUL-11

Starting Control File Autobackup at 01-JUL-11
piece handle=c-1864519587-20110701-01 comment=API Version 2.0,MMS Version 5.2.0.0
Finished Control File Autobackup at 01-JUL-11

Recovery Manager complete.

[Updated on: Wed, 06 July 2011 21:33] by Moderator

Report message to a moderator

Re: Delete obsolete backups using rman [message #515121 is a reply to message #514837] Fri, 08 July 2011 02:52 Go to previous messageGo to next message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
>delete backup completed before 'sysdate-2' device type disk;

If you want a Retention Policy of 60 days, why are you deleting backups that are only 2 days old ?


Hemant K Chitale
Re: Delete obsolete backups using rman [message #515251 is a reply to message #515121] Sat, 09 July 2011 07:07 Go to previous messageGo to next message
hhhaithamhany
Messages: 5
Registered: July 2011
Junior Member
I delete the backups that are 2 days old from the disk to save space. However, the deletion from the tape library is done manually every month using "delete obsolete;"
The retention policy of 60 days should be applied to the backups on the tape not the disk.

Thanks a lot.

Haitham Hany
Re: Delete obsolete backups using rman [message #515362 is a reply to message #515251] Mon, 11 July 2011 02:37 Go to previous message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
When you specify a RETENTION POLICY it applies to Backups -- irrespective of where the backup was created. Oracle doesn't care if your backups were to disk or to tape or to disk and tape. The RETENTION POLICY applies to all backups that were created by RMAN.


Hemant K Chitale
Previous Topic: MISSING FILES - just need some guidance to be sure
Next Topic: Routine to corrupt a block
Goto Forum:
  


Current Time: Fri Aug 22 05:48:41 CDT 2014

Total time taken to generate the page: 0.09313 seconds