[email protected]
ADSM.ORG Member
- Joined
- Jan 4, 2014
- Messages
- 32
- Reaction score
- 2
- Points
- 0
Hi All ,
'
So the Retention for VE backups in our environment is 15 days { and its set for 15 days and not versions } -
Of late we have been having issues with our storage pool getting full , so i was checking if there are any old snapshots which are left orphaned so i tried to pull info from "backups table" with the help of the below select command
"select FILESPACE_NAME,HL_NAME,LL_NAME,BACKUP_DATE from backups where node_name='VMWARE-NODE' and BACKUP_DATE <='2019-12-01' order by BACKUP_DATE "
-- Now to my surprise i got around 83 lakhs of lines in return for one VE node alone. And all of them are either .CTL files\control files or .DAT files\data files . I can understand why these files exists for past 15 days ( considering my retention is 15 days ) . But i can see Files from the past 2 years listed there.
Am i missing something ? is it supposed to be this way ?
How do i clean them up if its not supposed to be this way ?
'
So the Retention for VE backups in our environment is 15 days { and its set for 15 days and not versions } -
Of late we have been having issues with our storage pool getting full , so i was checking if there are any old snapshots which are left orphaned so i tried to pull info from "backups table" with the help of the below select command
"select FILESPACE_NAME,HL_NAME,LL_NAME,BACKUP_DATE from backups where node_name='VMWARE-NODE' and BACKUP_DATE <='2019-12-01' order by BACKUP_DATE "
-- Now to my surprise i got around 83 lakhs of lines in return for one VE node alone. And all of them are either .CTL files\control files or .DAT files\data files . I can understand why these files exists for past 15 days ( considering my retention is 15 days ) . But i can see Files from the past 2 years listed there.
Am i missing something ? is it supposed to be this way ?
How do i clean them up if its not supposed to be this way ?