Using onsmsync to expire backup images
Posted in 2010
IDS V10.FC5 OS Solaris 10 11/06
I recently noticed that the root dbspace and associated chunks on our
production
database were filling up with our onbar activities (in the sysutils database).
Rather than continue to add addition chunks (raw files) I have read that you
can use the onsmsync command to removes all backups that are not in the
storage manager catalog from the sysutils database and emergency boot file.
We run a policy through netbackup that executes a level 0 archive every night
and another policy that moves the data from disk to tape. We only have a two
week retension period.
Adding another chunk is not an issue, the current root dbspace is only 290MB.
Chunks
address chunk/dbs offset size free bpages flags pathname
1901b0028 1 1 0 45000 7 PO-B /chunks/root
19148eb88 22 1 0 45000 25 PO-B /chunks/root2
19148f028 24 1 0 45000 1701 PO-B /chunks/root3
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
1901afe78 1 0x40001 1 3 2048 N B informix dbs_root
oncheck -pe
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
24 /chunks/root3 2 45000 43299 1701
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
sysutils:'informix'.bar_obj_idx 3 5376
sysutils:'informix'.bar_object 5379 1024
sysutils:'informix'.bar_obj_idx 6403 1792
sysutils:'informix'.bar_instance 8195 512
sysutils:'informix'.bar_act_idx 8707 32
sysutils:'informix'.bar_obj_idx 8739 1792
sysutils:'informix'.bar_object 10531 1024
sysutils:'informix'. 102_9 11555 64
sysutils:'informix'.bar_instance 11619 512
sysutils:'informix'. 102_10 12131 32
sysutils:'informix'. 101_4 12163 32
sysutils:'informix'. 103_14 12195 64
sysutils:'informix'.bar_act_idx 12259 32
sysutils:'informix'.bar_obj_idx 12291 1792
sysutils:'informix'.bar_instance 14083 512
sysutils:'informix'. 102_9 14595 64
sysutils:'informix'.bar_action 14659 128
sysutils:'informix'.bar_object 14787 1024
sysutils:'informix'. 102_10 15811 64
sysutils:'informix'. 101_4 15875 32
sysutils:'informix'.bar_act_idx 15907 64
sysutils:'informix'.bar_obj_idx 15971 1792
sysutils:'informix'. 103_14 17763 64
sysutils:'informix'.bar_instance 17827 1024
sysutils:'informix'. 101_4 18851 64
sysutils:'informix'. 102_9 18915 64
sysutils:'informix'.bar_action 18979 128
sysutils:'informix'.bar_obj_idx 19107 1792
sysutils:'informix'.bar_object 20899 1024
sysutils:'informix'. 103_14 21923 64
sysutils:'informix'. 102_10 21987 64
sysutils:'informix'.bar_instance 22051 1024
sysutils:'informix'.bar_act_idx 23075 64
sysutils:'informix'.bar_obj_idx 23139 1792
sysutils:'informix'. 102_9 24931 64
sysutils:'informix'.bar_action 24995 128
sysutils:'informix'.bar_object 25123 1024
sysutils:'informix'. 101_4 26147 64
sysutils:'informix'. 103_14 26211 64
sysutils:'informix'.bar_obj_idx 26275 1792
sysutils:'informix'. 102_9 28067 64
sysutils:'informix'. 102_10 28131 64
sysutils:'informix'.bar_action 28195 128
sysutils:'informix'.bar_instance 28323 1024
sysutils:'informix'.bar_act_idx 29347 64
sysutils:'informix'.bar_object 29411 1024
sysutils:'informix'.bar_obj_idx 30435 1792
sysutils:'informix'. 103_14 32227 64
sysutils:'informix'. 101_4 32291 64
sysutils:'informix'. 102_9 32355 64
sysutils:'informix'.bar_obj_idx 32419 3584
sysutils:'informix'.bar_action 36003 128
sysutils:'informix'.bar_instance 36131 1024
sysutils:'informix'.bar_object 37155 1024
sysutils:'informix'. 102_10 38179 64
sysutils:'informix'. 103_14 38243 64
sysutils:'informix'.bar_act_idx 38307 64
sysutils:'informix'. 102_9 38371 64
sysutils:'informix'.bar_action 38435 128
sysutils:'informix'. 101_4 38563 64
sysutils:'informix'. 103_14 38627 64
sysutils:'informix'.bar_object 38691 1024
sysutils:'informix'.bar_obj_idx 39715 3584
FREE 43299 1701
Total Used: 43299
Total Free: 1701
Can someone advise if it is safe to use onsmsync to clean up or should I
continue to add more space.
Will this cause any problems wrt restoring data since we run a full backup
every night?