Re: Onbar question
Posted in 1998
If your restores are successful then I would say all is well but just
in case here is my $0.02 worth:
Take a look in your online.log and bar_act.log for any messages
regarding logical log backup after the level 0 or 1 backup completes.
After the onbar -b command completes onbar will have the engine
advance to the next logical log, then onbar will issue an onbar -l
command and the last bit of logical log is backed up. I know that
early ON-Bar versions (before 7.23.uc1 ?) didn't backup the last log.
Your best bet is to do a level 0 and then do an onstat -l and verify
that a partial log was indeed backed up. Also check the online.log
and bar_act.log.
Doug B.
> Everyone,
>
> We have just recently upgraded to 7.23UC3 from a 7.14 engine and want
> to take advantage of the onbar utility. Our database is approx. 12G
> and we are using Omniback as the storage manager backing up to a silo.
> We have successfully done level 0,1 backups and restores in test, but
> what I am not sure about is the way onbar handles backing up the logs.
> We are currently using a script that handles alarms and backs up logs
> to a file when they become full.
> My question is this - Do I need to have a separate barlist for the
> logs as opposed to a barlist that will back up to tape? Or will the
> LTAPEDEV be used when the onbar -l is issued?
> Also are there any success/horror stories using this utility or any
> tips that people have found helpful?
> I would like to implement this backup plan in production a.s.a.p.
> since I am tired of changing dat tapes to back up this DB.
>
> Manuallessly yours,
> craig lanford
> craig.lanford@alltel.com
>