Informix

 View Only
Expand all | Collapse all

restoring informix using the onbar command. problem

  • 1.  restoring informix using the onbar command. problem

    Posted Fri May 27, 2022 12:07 PM
    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


  • 2.  RE: restoring informix using the onbar command. problem

    IBM Champion
    Posted Fri May 27, 2022 12:33 PM
    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
    ------------------------------



  • 3.  RE: restoring informix using the onbar command. problem

    Posted Fri May 27, 2022 12:43 PM
    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
    ------------------------------



  • 4.  RE: restoring informix using the onbar command. problem

    IBM Champion
    Posted Fri May 27, 2022 12:45 PM
    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
    ------------------------------



  • 5.  RE: restoring informix using the onbar command. problem

    Posted Fri May 27, 2022 12:49 PM
    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
    ------------------------------



  • 6.  RE: restoring informix using the onbar command. problem

    IBM Champion
    Posted Fri May 27, 2022 02:06 PM
    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
    ------------------------------



  • 7.  RE: restoring informix using the onbar command. problem

    Posted Fri May 27, 2022 02:44 PM
    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
    ------------------------------



  • 8.  RE: restoring informix using the onbar command. problem

    Posted Fri May 27, 2022 02:47 PM
    software versions : informix 12.10, TSM 7.1.5

    ------------------------------
    ivan loginov
    ------------------------------



  • 9.  RE: restoring informix using the onbar command. problem

    IBM Champion
    Posted Sat May 28, 2022 03:44 PM


    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
    ------------------------------



  • 10.  RE: restoring informix using the onbar command. problem

    Posted Tue May 31, 2022 01:57 AM
    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
    ------------------------------



  • 11.  RE: restoring informix using the onbar command. problem

    IBM Champion
    Posted Mon May 30, 2022 06:21 AM

    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
    ------------------------------



  • 12.  RE: restoring informix using the onbar command. problem

    Posted Tue May 31, 2022 01:47 AM
    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
    ------------------------------