incremental onbars
Posted in 2008
9.40.FC5, Solaris 9. It seems to be my station in life to inherit
things. When I inherited this db, we were running on some flavor of
7.31. Someone else designed the onbar backup and currently we run 1
level 0 a week. It is running muti-threaded and takes 6 to 8 hours to
run. I was told that the incremental onbar takes the same amount of
time and, therefore, is not beneficial. I would imagine that it still
needs to read all of the dbspaces but it should not write out nearly as
much. Does a level1 or level2 actually take as long as the level0 to
run?
Several years ago we tried unsuccessfully to back up and restore a
single dbspace. Usually, the backup seemed to run fine. The restore
had two outcomes: the logs were rolled forward repeating the event that
corrupted it or the dbspace would not come online and remained in an
inconsistent state. We contacted informix support and were told that a
dbspace backup was not supported.
What I wanted to do was put specific tables in their own dbspaces and
backup these dbspace groups at differing times. I would have a group of
dbspacese to backup daily, another group to backup weekly...etc. I
would then do a warm restore on a particular dbspace group as needed. I
thought the onbar manual said this was supported but could never get the
restore to work or get any help from support so we gave up. Anyone out
there doing anything similar? So far, all the onbar is used for here is
level 0 backup and restore.
It looks like, at long last, I may get to upgrade to 10. ( I would
prefer 11 but I'll take what I can get). I'm hoping to move to Solaris
10 with IDS10 this year. I would really like the table-level restore
capability. Anyone using it on Solaris 10? Does it work nicely?
thx in advance for the info