Re: ONBAR, IXBAR, & Point in Time Recovery

Thom wrote: > The system crashed hard on Monday (SAN Failure). My last good full > database and file system backups (which includes the IXBAR file) are > from Friday morning. I have all the logs sent to tape since the last > db backup. My problem is can I recover to a point in time beyond the > IXBAR file? I have been doing some searching and I don't really see > anything and I am wondering if anyone has tried this? If the IXBAR > file needs to have all the log files info is there away to get that > information in the IXBAR file? > > Any help will be appreciated. > > Thanks in advance. > T.E.Mammoser > DBA > Nicor Gas To clarify some points regarding the "wonderful" onsmsymc utility. - onsmsync is only able to delete entries from sysutils/ixbar if they no longer exist in the storage manager it will not insert entries in sysutils/ixbar if the exist in the storage manager but not in sysutils/ixbar - onsmsync is able to build a new ixbar file based on the sysutils database - onsmsync will insert entries in sysutils which are only available in the ixbar file (for example log salvages which occur offline) so onsmsync will not be a real help. because you have no actual ixbar- file and your sysutils database might also be lost. however informix changed the behaviour during the logical restore. it will not only use the entries in the ixbar-file, it will also search for additional logs available in the storage manager thru the BSAQueryObject() call. so a restore to the most recent backed up logical log should be possible. however I'm not sure in what version this behaviour changed. I guess it was 7.31.UC6 or UC7. HTH. best regards eric -- IT-Consulting Herber Mobile: +49 177 2276895 *********************************************** Download the IFMX Database-Monitor for free at: http://www.herber-consulting.de/BusyBee ***********************************************