IDS Forum

RE: Why is this happening ?

Posted By: NormaJean.Sebastian@tellabs.com
Date:

Scott's right.
Sending logs to /dev/null results in an "SOL" situation for you.
/dev/null is special. Informix won't bother to check other settings, if
it sees dev/null, it simply flips a bit to mark the log backed up
without really doing anything with it.
However, if you set this to /dev/null only for the restore, but normally
run with a setting to something other than /dev/null, you probably do
have logs backed up as you indicated. Maybe you were just trying to
avoid the log salvage that Informix does on restore? If so, check on
the storage manager side for messages. Obviously Informix knows what
log it wants, but the storage manager can't help.
In our case, our storage manager (Veritas Netbackup) initially backs up
our logs to disk. We hold X days on disk, then we have a secondary
Netbackup process that takes those logs, backs them to tape, and empties
the disk directory. We use the second Netbackup process because it has
a different catalog than the first one. If the first netbackup process
backed these to tape, it would change the records in it's catalog and
would not be able to give informix the log when requested.
We have tested situations where we knew the log was backed up to disk
and properly recorded by both Informix and Netbackup. Then we renamed
the log on disk, then we tried to restore. Informix knew what it
wanted, Netbackup understood, but returned an error that the log could
not be found. When we renamed the log to the proper filename, Netbackup
happily passed it back to Informix and all was well with the world.
I don't know about all the storage managers, but Informix and Netbackup
produce verbose messages that are quite understandable.

If indeed you did back up the logs, try the restore again without the
/dev/null setting and see what happens.
good luck,
Norma Jean


-----Original Message-----
From: scottm@dinecollege.edu [mailto:scottm@dinecollege.edu]
Sent: Thursday, December 11, 2003 5:00 PM
To: ids@iiug.org; forum.subscriber@iiug.org
Subject: Re: Why is this happening ? [2343]

Probably the below:
"Logical Logs will not be backed up / salvaged because LTAPEDEV value is
/dev/null"
Hard to do a restore from the bit bucket, I believe. If you could
do that, I would be very impressed! (Ditto the "storage manager" would
be.)

Mike Smith wrote:
> Hi all,
> I am trying onbar -r -n 4200 and it is crashing at the logical
log number 4198. The logs show that it was backed up successfully.
Ixbar.0 has the record of logical log 4198.
> I have attached the bar_act.log erro below. Can someone shed light to
this to troubleshoot what could be wrong ?
> Thanks.
>
> bash-2.03$ cat bar_act*
> 2003-12-11 05:19:51 26449 26447
/opt/informix/IDS_9.30.FC8X4/bin/onbar_d -r -n 4200
> 2003-12-11 05:19:51 26449 26447 Logical Logs will not be backed up /
salvaged because LTAPEDEV value is /dev/null
> 2003-12-11 05:19:51 26449 26447 Successfully connected to Storage
Manager.
> 2003-12-11 05:20:30 26449 26447 Begin cold level 0 restore rootdbs
(Storage Manager copy ID: 1071159307 1071159308).
> 2003-12-11 05:20:52 26449 26447 Completed cold level 0 restore
rootdbs.
> 2003-12-11 05:21:33 26449 26447 Begin cold level 0 restore dbspace1
(Storage Manager copy ID: 1071159359 1071159361).
> 2003-12-11 05:51:13 26449 26447 Completed cold level 0 restore
dbspace1.
> 2003-12-11 05:51:13 26449 26447 Successfully connected to Storage
Manager.
> 2003-12-11 05:51:15 26449 26447 XBSA Error: (BSAQueryObject) Backup
object does not exist in Storage Manager.
> 2003-12-11 05:51:15 26449 26447 ON-Bar could not get logical log
4198 from the storage manager.
> 2003-12-11 05:51:15 26449 26447 ON-Bar suspended the logical restore
on log 4198 (expected to restore to 4200).
> 2003-12-11 05:51:25 26449 26447
/opt/informix/IDS_9.30.FC8X4/bin/onbar_d complete, returning 100 (0x64)
> 2003-12-11 05:53:18 26540 26538
/opt/informix/IDS_9.30.FC8X4/bin/onbar_d ---
> 2003-12-11 05:53:19 26540 26538 onbar usage
>





-----------------------------------------
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the
reader of this message is not the intended recipient, or an
employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any
reproduction, dissemination or distribution of this
communication is strictly prohibited. If you have received
this communication in error, please notify us immediately by
replying to the message and deleting it from your computer.

Thank you.
Tellabs
============================================================

Messages In This Thread

• Why is this happening ?
  Mike Smith -- Thursday, 11 December 2003, at 5:39 p.m.
  • Re: Why is this happening ?
    Scott MacKenzie -- Thursday, 11 December 2003, at 6:00 p.m.
    • Re: Why is this happening ?
      Christine Normile -- Thursday, 11 December 2003, at 8:23 p.m.
    • RE: Why is this happening ?
      NormaJean.Sebastian@tellabs.com -- Friday, 12 December 2003, at 8:00 a.m.
      • RE: Why is this happening ?
        Mike Smith -- Friday, 12 December 2003, at 10:53 a.m.
  • RE: Why is this happening ?
    Mike Smith -- Tuesday, 16 December 2003, at 2:23 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.