restoring informix using the onbar command. problem
Posted in 2022
Ivan Loginov restored TSM after a disk failure but onbar -r -w failed with XBSA error BsagetObject: backup object does not exist (Informix 12.10, TSM 7.1.5). Art Kagel suspected incomplete TSM data. Mike Walker suggested IFX_TSM_OBJINFO_OFF=1, which failed. David Williams suggested BAR_DEBUG=5 and an IBM note; Andreas Legner asked about ixbar. Older backups still fail while new ones restore. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Topics: Backup & Restore
hello, i had both informix and tsm spaces on the same physical disk. this disk is broken. Using the files devices.cfg, volhistory, dsm.opt. I was able to restore TSM using the DB restore command. Next, I need to restore the informix spaces that were backed up once a week with onbar -b -L 0 -w. When trying to restore onbar -r -w. command ends with error: XBSA error:(BsagetObject) Backup object does not exist in Storage Manager
------------------------------
ivan loginov
------------------------------
#Informix
It looks like either the TSM data was not properly, or completely, restored or the TSM catalog was corrupted. Hopefully, you were having your TSM backups copied offline to another location from which you can recover them. Otherwise you are done. I know it's too late, but I have to say for the benefit of others that it was a bad idea to store your data and its backups on the same storage structure! ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
The TSM database was restored completely and without errors, moreover, with the command: query content {volume name } I can see the copy points of the informix database. the ixbar.0 file also contains information about these operations, and copies were made over several years. As I understand it, the recovery should go through at least one of the copies found, I think that it cannot be such that it is impossible to restore at least one of the hundreds of previously made copies to tape. ------------------------------ ivan loginov ------------------------------
If you are confident that the data has been safely restored, then I would try to initiate the restore from TSM and see what happens. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
I tried, but the files on the tape have the BACKUP flag, which command can be used to extract them in this case, ordinary files are extracted, for example, dsmserv retrieve or restore. Which command to extract files with the BACKUP attribute ------------------------------ ivan loginov ------------------------------
I am guessing here, but try setting
IFX_TSM_OBJINFO_OFF to 1 in the environment and trying the onbar restore again.
Also, I assume that you have verified that DSMI_DIR, DSMI_LOG and DSMI_CONFIG are all set and correct?
------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com
------------------------------
yes i have tried setting IFX_TSM_OBJINFO_OFF to 1. The TSM and informix communication settings files are also set correctly. Moreover, I have a two-year-old ontape copy, I can recover from it and try to test run onbar -b -L 0 -w and then restore from this copy onbar -r -w, then recovery works for the newly created copy, and from previous ones cannot be restored
------------------------------
ivan loginov
------------------------------
software versions : informix 12.10, TSM 7.1.5 ------------------------------ ivan loginov ------------------------------
https://www.ibm.com/support/pages/ism-imported-restore-returns-xbsa-error-bsagetobject-backup-object-does-not-exist-storage-manager
Otherwise
In the onconfig file set BAR_DEBUG=5 and BAR_DEBUG_LOG to a filename.
Then you should be able to see which object onbar is looking for to check if the object exists. The copyid and object name should be fairly unique.
The TSM logs should also be checked. Perhaps there is a permissions issue.
Regards,
David.
------------------------------
David Williams
------------------------------
Which ixbar file ($INFORMIXDIR/etc/ixbar.<server_num>) are you operating on? Was this possibly also affected and had to be restored? Does it contain the backup you're hoping to restore? ------------------------------ Andreas Legner ------------------------------
the file is called ixbar.0, which is what the system requests when starting onbar. Yes, and the file contains information about different backup copies (weekly
------------------------------
ivan loginov
------------------------------
Hello, I did as you say, as you cite the link, I have the same error, but the options for solving the problem did not help me or I don't know how to apply these solutions correctly. 1. the ixbar file is absolutely normal, moreover, there are earlier saved versions of it. 2. The onconfig file has not changed and there are also backup copies of it. 3. But this point is absolutely not clear to me, where this variable should be set, I tried to set it through export ISM_CLIENT, but I'm not sure if this is correct and I don't know exactly what value to set it to, can you tell me with this? ------------------------------ ivan loginov ------------------------------