Re: Strange results with onbar
Posted in 1999
Hi,
I have recently starting testing onbar and I did notice that a full backup
(non-whole system) backs up root_dbs, log_dbs and then the non-critical
dbs in alphabetical order. I do not know why, but it will not necessarily
promote the best performance.
I guess you could backup specific dbspaces. Just make sure you get them
all.
Steve Berg
On Wed, 27 Jan 1999, Doug Agnew wrote:
> Testing onbar with Informix 7.24, ADSM v3.
>
> onbar -b -w -L 0 backed up system in dbspace order (rootdbs, physdbs, logdbs
> ....)> BUT
> onbar -r -w restored rootdbs and then the remaining spaces in ALPHABETICAL> order of dbspace name.
>
> Everything restored okay (as best I can tell -- SAP still works), but I am
> concerned when I move to production and have 3+ tapes in a single backup.
> Apparently, the onbar caused ADSM to skip around on the tape backup and, if
> this is so, then a full production restore could have serious performance
> issues with tape mounts/dismounts.
>
> Anyone else noticed this phenomenon and found a workaround??
>
> TIA
>
> Doug Agnew
> DBA
> Charlotte Pipe & Foundry
> dagnew@charlottepipe.com
>
>
>