DID YOU RUN "DELETE OBSOLETE" UNDER RMAN ?
-----Original Message-----
From: Bill Zakrzewski
[mailto:oracledba-ezmlmshield-x93641859.[Email address protected]
Sent: Tuesday, January 08, 2008 4:30 PM
To: LazyDBA Discussion
Subject: RMAN - Oracle Suggested Backup
All -
Database: Oracle 10.2.0.3.0
Grid Control: 10.2.0.3.0
Host: Linux RHEL AS 4
I have usually used self-developed backup scripts to backup my
databases, but I recently started using RMAN. I selected the Oracle
Suggested Backup through grid control which starts out by taking a full
level 0 backup followed by daily incremental level 1 cumulative backups
(thus the copy of the original datafile is being updated with the
previous days incremental changes). My question is simple: I have the
backup retention policy set to 7 days and I see that there are 7 days
worth of archivelogs maintained in the flash_recovery_area and 2 copies
of each datafile (one from the original level 0 and one updated with the
latest incremental changes). Why do I have the incremental backupsets
dating back to December 11th? Shouldn't RMAN automatically delete the
old incremental backupsets?
Hopefully this listing helps......
113M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_25
118M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_18
88M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_20
107M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_12
146M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2008_01_03
135M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2008_01_07
87M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_30
140M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_28
167M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_21
112M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_19
94M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_23
127M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_31
92M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2008_01_06
111M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2008_01_01
147M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2008_01_05
78M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_16
115M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_17
187M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_24
376M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_11
124M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2008_01_02
142M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_29
120M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_15
136M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2008_01_04
3.0G
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_14
131M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_27
107M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_26
138M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_22
134M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset/2007_12_13
6.5G oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/backupset
294M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2008_01_0
3
324M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2008_01_0
7
8.0K
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2007_12_3
1
209M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2008_01_0
6
176M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2008_01_0
1
249M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2008_01_0
5
265M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2008_01_0
2
285M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2008_01_0
4
171M
oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog/2008_01_0
8
2.0G oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/archivelog
8.0K oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/autobackup
8.0K oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/onlinelog
29G oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY/datafile
37G oradata/webdb1/flash_recovery_area/arch/WEBDB1_STBY
Thanks in advance,
Bill
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page