Informix - Different onbar backup and restore dbs order

[Nick Wickens]

I perform a Whole system backup of our 120Gb Informix database on a nightly basis using onbar with Omniback 3.5.

I have noticed that as we moved to two tapes for each backup (shortly to go to three), that whole system restores involve a lot of tape swapping and searching and I have tied the reason for this down to the fact that the backup order is defined firstly by the dbspace type(ish) and then by Dbspace number as defined in sysutils when the dbspaces are created. However the restore order is defined by the order in the ixbar file which seems to be defined by dbspace type followed by alphabetical order.

The upshot of this is that restore of dbspaces takes place in a different order to the original backup which even for a single tape backup is going to involve a lot of tape searching let alone when the tape is being swapped out by an autochanger.

Other than the headache of renumbering the dbs numbers or renaming into alphabetical order has anyone a quick solution ?

[Pete Randall]

Hi Nick,

How about bigger tapes? DLT's or such?

Just a thought.


Pete

[Nick Wickens]

Hi Pete

Using DLT7000 tapes already (LTO is still several budgets in the future :@) )- Even if I could tie the backup down to one tape theres still going to be a lot of unnecessary tape searching going on so I am guessing that performance is being compromised even at that level.

[Pete Randall]

Nick,

I figured that was too obvious but had to ask? I'll run this by my DBA when he gets in in an hour or so. He's pretty sharp with this stuff. Maybe he'll have an idea.


Pete

[Rainer von Bongartz]

What about a backup where you define the order od the backed up db spaces ??

onbar supports the following
syntax

onbar -b -L -f

In file you define the dbspaces to backup. This also defines the order.

To restore use

onbar -r -p -f

for a physical restore and afterwards

onbar -l

for a logical restore.

This will ensure that the restore is done in the same order as the backup


Regards
Rainer

[Pete Randall]

Nick,

Here's my DBA's comments:

=======================
> I have noticed that as we moved to two tapes for each backup (shortly to
> go to three), that whole system restores involve a lot of tape swapping
> and searching and I have tied the reason for this down to the fact that
> the backup order is defined firstly by the dbspace type(ish) and then by
> Dbspace number as defined in sysutils when the dbspaces are created.
> However the restore order is defined by the order in the ixbar file
> which seems to be defined by dbspace type followed by alphabetical order.

I think the last sentence is wrong. In our ixbar, its the order that
the backups of each DBspace were COMPLETED. Not started. For
example last night. I suspect that this person is NOT doing a parallel
backup.

If you look at /opt/informix/online.log
you can see that onbar/omniback seems to follow its own logic:
23:00:32 Level 0 Archive started on rootdbs
23:00:52 Archive on rootdbs Completed.
23:00:52 Checkpoint Completed: duration was 0 seconds.
23:00:54 Checkpoint Completed: duration was 0 seconds.
23:00:54 Level 0 Archive started on dbs08
23:00:54 Level 0 Archive started on dbs10
23:00:57 Level 0 Archive started on bdbs06
23:00:58 Checkpoint Completed: duration was 0 seconds.
23:00:58 Level 0 Archive started on dbs03
23:00:58 Level 0 Archive started on dbs02
23:00:59 Checkpoint Completed: duration was 0 seconds.
23:00:59 Level 0 Archive started on logilog
23:00:59 Level 0 Archive started on physlog
23:01:00 Level 0 Archive started on dbs01
23:01:00 Checkpoint Completed: duration was 0 seconds.
23:01:00 Level 0 Archive started on dbs07
23:01:01 Level 0 Archive started on dbs09
23:01:01 Level 0 Archive started on dbs05
23:01:01 Level 0 Archive started on dbs04
=================


So, are you doing a parallel backup?


Pete

[Nick Wickens]

Hi Rainer

Thanks but already considered that - problem is that you then need to recover logical logs as well (Only a whole system backup will recover without log recovery) and we don't like the idead of recovering logs here, prefering a complete backup and restore from the least amount of tapes possible.

Also you need to set up a process to ensure that new dbaspaces are included in the backup spec when they are created otherwise several months down the line you find that you can't recover that system after all.

[Nick Wickens]

Hi Pete

No - Whole system onbar backups can only be done sequentially and not parallel. We could do parallel backups but only if I change to the suggestion above from Rainer.

[Zafar A. Mohammed_1]

1. What is the Informix Version?

2. Try to increase Bar Workers(XPS).


Thanks
Zafar

[Rainer von Bongartz]

Nick,

You could simply create a file
containing you db-spaces with an onstat -d command and some awk scripting before performing your backup.

QUESTION:

How do you do your backup not caring about logical logs ??

Even a whole system backup with onbar -b -w will backup logical logs. So you'll always need the logical log tapes for system recovery.

The only way to backup without logical logs is to block the database server (onmode -l ; onmode -c block) and perform a backup.
But during this time INFORMIX will be in read-only mode .

Regards
Rainer