Re: Point in time recovery

In article <341EE091.31EA@cornell.edu>, Vic Goldberg <vg19@cornell.edu> writes > >Folks -- > > We're running 7.22 on AIX 4.1.5. We use onbar for backups, >talking to IBM's ADSM storage manager. > > We've got a development system where several different groups >of users each have their own databases. We recently had an instance >where one of the groups completely scrogged their database via >entering a really, really bad series of SQL commands. As far as >we've been told by support, we're out of luck in terms of using >our backups to recover just the single database (which has its own >dbspaces), as onbar point in time recovery only works on a >entire instance, not on particular dbspaces. > > Any suggestions? Is there anyone who has got a good work-around? >We're considering nightly dbexports, but with a lot of databases, >that's pretty time intensive. > Can't you just do a level -0 archive overnight and just restore the required dbspace(s)? Worst case you would lost a day's work. Possibly consider a level 0 archive at lunchtime if you can get everyone to log off for an hour and it will take less then an hour. A pain but if you keep do it regularly the development staff would get used to taking their lunch at the same time each day. I did this with SE after someone scrogged our database. I would ask everyone to log off and do a backup at 1pm each day. Amazingly the development staff all adapted and the group "bonded" together as they all went for lunch at the same time each day. > TIA. > >Vic -- David Williams