Help on onbar
After a disk crash, a user restored an IDS 9.40 instance with ON-Bar; everything came back except the dbspace holding the logical logs (left in ND/PD state), so the server wouldn't start, and 'onbar -r bddlogs' did nothing. bar_act.log showed XBSA "Backup object does not exist in Storage Manager", suggesting the log dbspace was never backed up or the restored ixbar.<servernum> file was the wrong version. Suggestions included calling IBM's Down Systems Group and extracting tables with archecker, but IBM declined support on the out-of-maintenance 9.40 release, so the user rebuilt from scratch using dbexport files, with some data loss.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Anyone online at this moment?
I'm traying to recover from onbar, as the root dbspace and a data
dbspace where lost when a disk crashed.
I did an onbar -r and all of the dbspaces were recovered but the
dbspace dedicated to logical logs.
online can't be started becaus of Logical Log File not found error.
If I try to onbar -r bddlogs it does not do anything..
the binaryes directory of informix where lost and I recoverit from
backup and copy on it all of the administrative files for ontape, which
were backed up with the onbar -b -L 0 backup.
Can I force to recover from bddlogs or do anything to fix the problem.
Thanks in advance.
--Néstor
nestor gomez munoz wrote:
> Anyone online at this moment?
> I'm traying to recover from onbar, as the root dbspace and a data
> dbspace where lost when a disk crashed.
>
> I did an onbar -r and all of the dbspaces were recovered but the
> dbspace dedicated to logical logs.
>
> online can't be started becaus of Logical Log File not found error.
>
> If I try to onbar -r bddlogs it does not do anything..
>
> the binaryes directory of informix where lost and I recoverit from
> backup and copy on it all of the administrative files for ontape, which
> were backed up with the onbar -b -L 0 backup.
>
> Can I force to recover from bddlogs or do anything to fix the problem.
>
> Thanks in advance.
>
> --Néstor
Difficult to say what's wrong w/o any diagnostics.
What are the dbspace flags after you restored the instance ? What does
bar_act.log tell you ? online.log ?
It might be the logical restore (rollforward of logs ) did not happen
for whatever reason ?
Check bar_act.log and maybe the storage managers log files.
HTH
Tilman
El mié, 13-05-2009 a las 03:10 -0400, tilleul17@web.de escribió:
> nestor gomez munoz wrote:
> > Anyone online at this moment?
> > I'm traying to recover from onbar, as the root dbspace and a data
> > dbspace where lost when a disk crashed.
> >
> > I did an onbar -r and all of the dbspaces were recovered but the
> > dbspace dedicated to logical logs.
> >
> > online can't be started becaus of Logical Log File not found error.
> >
> > If I try to onbar -r bddlogs it does not do anything..
> >
> > the binaryes directory of informix where lost and I recoverit from
> > backup and copy on it all of the administrative files for ontape, which
> > were backed up with the onbar -b -L 0 backup.
> >
> > Can I force to recover from bddlogs or do anything to fix the problem.
> >
> > Thanks in advance.
> >
> > --Nstor
>
> Difficult to say what's wrong w/o any diagnostics.
>
> What are the dbspace flags after you restored the instance ? What does
> bar_act.log tell you ? online.log ?
>
> It might be the logical restore (rollforward of logs ) did not happen
> for whatever reason ?
> Check bar_act.log and maybe the storage managers log files.
> HTH
> Tilman
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hello. Thanks for the answare.
The flags are like this:
3318f490 1 0x401 1 1 NP informix
bddroot
34110028 2 0x20005 2 1 ND informix
bddlogs
34110490 3 0x40401 3 1 NP B informix
bddsiad
etc.
only bddlogs is ND
chunks are
3318f8f8 1 1 0 512000 458111
PI-- /usr1/informix/dbspaces/bddroot
33421cd8 2 2 0 1024000 0
PD-- /usr1/informix/dbspaces/bddlogs
33421e70 3 3 0 10240000 1940579
PI-B /u ...etc
only bddlogs is PD
This is the most significative on bar_act.log
2009-05-13 00:17:55 7497 7496 XBSA Error: (BSAGetObject) Backup object
does not exist in Storage Manager.
2009-05-13 00:17:55 7502 7496 Process 7502 7496 successfully forked.
2009-05-13 00:17:55 7497 7496 Object information: bar_objdesc
obj_id 0 obj_name 'bddlogs' obj_type 'CD' act_id 0 act_type 2
act_status 0
act_start '2009-05-13 00:17:55' act_end '2009-04-17 11:18:50'
ins_time 0 rsam_time 0 level 0 copyid hi:lo 11109:0 req_act_id
38680
logstream 0 est_pages hi:lo 0:0 first_log 0 chpt_log 0 last_log 0
partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name ''
ins_verify 0 ins_verify_date '' restore order 0:0
objInfo ''
retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0
bkup_host ''
2009-05-13 00:17:55 7501 7496 Successfully connected to Storage
Manager.
And this is the most notable on online.log. Anything else is succesfull
00:17:56 Physical Restore of bddlogs ABORTED.
00:17:56 Aborted by client.
00:36:00 Checkpoint Completed: duration was 0 seconds.
00:36:00 Checkpoint loguniq 41631, logpos 0x2b2a018, timestamp:
0x7ff19839
--Néstor
Hi,
could there be a problem with the ixbar.<servernum> file
in the $INFORMIXDIR/bin directory? I.e. that this file has
not been restored to the correct version and for that the
needed backup of the logdbspace has not been found
for restore?
Of course there is a small chance that the log dbspace
was not backed up in a long time and this has gone
un-noticed? (As ON-Bar generally allows backup of
individual dbspaces, there normally is no check for
completeness - unless you do whole system backups.)
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
ids-bounces@iiug.org wrote on 13.05.2009 06:29:36:
> Anyone online at this moment?
> I'm traying to recover from onbar, as the root dbspace and a data
> dbspace where lost when a disk crashed.
>
> I did an onbar -r and all of the dbspaces were recovered but the
> dbspace dedicated to logical logs.
>
> online can't be started becaus of Logical Log File not found error.
>
> If I try to onbar -r bddlogs it does not do anything..
>
> the binaryes directory of informix where lost and I recoverit from
> backup and copy on it all of the administrative files for ontape, which
> were backed up with the onbar -b -L 0 backup.
>
> Can I force to recover from bddlogs or do anything to fix the problem.
>
> Thanks in advance.
>
> --Néstor
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
If the logical log dbspace is the one that couldn't be recovered, then there
is a good chance that IBM will be able to recover your instance for you. Do
not touch the instance or disk chunks and DO NOT overwrite or lose that
latest onbar archive!
Call tech support and get to the Informix Down Systems Group. There are
several options they may have to help you.
The only thing you can try yourself would be to use archecker to extract
from the onbar archive every table for each of your databases into flat
files or into a new database server in a clean instance.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, May 13, 2009 at 12:29 AM, nestor gomez munoz <
nestorgm@prodigy.net.mx> wrote:
> Anyone online at this moment?
> I'm traying to recover from onbar, as the root dbspace and a data
> dbspace where lost when a disk crashed.
>
> I did an onbar -r and all of the dbspaces were recovered but the
> dbspace dedicated to logical logs.
>
> online can't be started becaus of Logical Log File not found error.
>
> If I try to onbar -r bddlogs it does not do anything..
>
> the binaryes directory of informix where lost and I recoverit from
> backup and copy on it all of the administrative files for ontape, which
> were backed up with the onbar -b -L 0 backup.
>
> Can I force to recover from bddlogs or do anything to fix the problem.
>
> Thanks in advance.
>
> --Néstor
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5a5014f91f50469c929d9
Thanks a lot Art. The fact is IBM argue can't do anything because of
version 9.40 is out of maintenance.
Anyway we start recovery from scratch and dbexport files. Whith some
lost.
El mié, 13-05-2009 a las 07:03 -0400, Art Kagel escribió:
> If the logical log dbspace is the one that couldn't be recovered, then there
> is a good chance that IBM will be able to recover your instance for you. Do
> not touch the instance or disk chunks and DO NOT overwrite or lose that
> latest onbar archive!
>
> Call tech support and get to the Informix Down Systems Group. There are
> several options they may have to help you.
>
> The only thing you can try yourself would be to use archecker to extract
> from the onbar archive every table for each of your databases into flat
> files or into a new database server in a clean instance.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> On Wed, May 13, 2009 at 12:29 AM, nestor gomez munoz <
> nestorgm@prodigy.net.mx> wrote:
>
> > Anyone online at this moment?
> > I'm traying to recover from onbar, as the root dbspace and a data
> > dbspace where lost when a disk crashed.
> >
> > I did an onbar -r and all of the dbspaces were recovered but the
> > dbspace dedicated to logical logs.
> >
> > online can't be started becaus of Logical Log File not found error.
> >
> > If I try to onbar -r bddlogs it does not do anything..
> >
> > the binaryes directory of informix where lost and I recoverit from
> > backup and copy on it all of the administrative files for ontape, which
> > were backed up with the onbar -b -L 0 backup.
> >
> > Can I force to recover from bddlogs or do anything to fix the problem.
> >
> > Thanks in advance.
> >
> > --Nstor
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001636c5a5014f91f50469c929d9
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
The archecker should be able to extract the lost tables directly from the
onbar archive using its tabel level restore capability! I don't remember
for certain if that feature was included in the 9.40 version of archecker or
was first available in 10.00, but IB that the more recent archecker versions
will read an older version archive anyway. [Just double checked and table
level restore using archecker was first introduced officially in IDS 10.00 -
if it works in the 9.40 version it was undocumented then.)
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, May 13, 2009 at 9:30 AM, nestor gomez munoz <nestorgm@prodigy.net.mx
> wrote:
> Thanks a lot Art. The fact is IBM argue can't do anything because of
> version 9.40 is out of maintenance.
> Anyway we start recovery from scratch and dbexport files. Whith some
> lost.
>
> El mié, 13-05-2009 a las 07:03 -0400, Art Kagel escribió:
> > If the logical log dbspace is the one that couldn't be recovered, then
> there
> > is a good chance that IBM will be able to recover your instance for you.
> Do
> > not touch the instance or disk chunks and DO NOT overwrite or lose that
> > latest onbar archive!
> >
> > Call tech support and get to the Informix Down Systems Group. There are
> > several options they may have to help you.
> >
> > The only thing you can try yourself would be to use archecker to extract
> > from the onbar archive every table for each of your databases into flat
> > files or into a new database server in a clean instance.
> >
> > Art
> >
> > Art S. Kagel
> > Oninit (www.oninit.com)
> > IIUG Board of Directors (art@iiug.org)
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> > do not reflect on my employer, Oninit, the IIUG, nor any other
> organization
> > with which I am associated either explicitly or implicitly. Neither do
> > those opinions reflect those of other individuals affiliated with any
> entity
> > with which I am affiliated nor those of the entities themselves.
> >
> > On Wed, May 13, 2009 at 12:29 AM, nestor gomez munoz <
> > nestorgm@prodigy.net.mx> wrote:
> >
> > > Anyone online at this moment?
> > > I'm traying to recover from onbar, as the root dbspace and a data
> > > dbspace where lost when a disk crashed.
> > >
> > > I did an onbar -r and all of the dbspaces were recovered but the
> > > dbspace dedicated to logical logs.
> > >
> > > online can't be started becaus of Logical Log File not found error.
> > >
> > > If I try to onbar -r bddlogs it does not do anything..
> > >
> > > the binaryes directory of informix where lost and I recoverit from
> > > backup and copy on it all of the administrative files for ontape, which
> > > were backed up with the onbar -b -L 0 backup.
> > >
> > > Can I force to recover from bddlogs or do anything to fix the problem.
> > >
> > > Thanks in advance.
> > >
> > > --Nstor
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001636c5a5014f91f50469c929d9
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c597b8921d290469cb6d99