- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Informix - Different onbar backup and restore ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 02:51 AM
тАО05-21-2003 02:51 AM
Informix - Different onbar backup and restore dbs order
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 02:57 AM
тАО05-21-2003 02:57 AM
Re: Informix - Different onbar backup and restore dbs order
How about bigger tapes? DLT's or such?
Just a thought.
Pete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 03:06 AM
тАО05-21-2003 03:06 AM
Re: Informix - Different onbar backup and restore dbs order
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 03:10 AM
тАО05-21-2003 03:10 AM
Re: Informix - Different onbar backup and restore dbs order
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
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 04:19 AM
тАО05-21-2003 04:19 AM
Re: Informix - Different onbar backup and restore dbs order
onbar supports the following
syntax
onbar -b -L
In file
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 04:30 AM
тАО05-21-2003 04:30 AM
Re: Informix - Different onbar backup and restore dbs order
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
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 04:33 AM
тАО05-21-2003 04:33 AM
Re: Informix - Different onbar backup and restore dbs order
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 04:36 AM
тАО05-21-2003 04:36 AM
Re: Informix - Different onbar backup and restore dbs order
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 04:58 AM
тАО05-21-2003 04:58 AM
Re: Informix - Different onbar backup and restore dbs order
2. Try to increase Bar Workers(XPS).
Thanks
Zafar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 05:05 AM
тАО05-21-2003 05:05 AM
Re: Informix - Different onbar backup and restore dbs order
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