Informix

Expand all | Collapse all

Is it possible to perform onbar backup/restore between heterogeneous platforms?

  • 1.  Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Wed July 15, 2020 11:14 AM
    I would like to know if it is possible to restore to Solaris or AIX with an onbar backup taken on Informix in an HP-UX environment.

    I answered my customer that it was impossible... Is it possible?

    The Informix version is 11.5 and the backup software is EMC Networker.

    In the document below, there is an explanation that Commvault can be used to perform Cross Platform/Cross Server Restore.
    https://www.ibm.com/support/pages/performing-cross-platformcross-server-restore-using-commvault

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------


  • 2.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Wed July 15, 2020 11:21 AM

    Simple answer : NO WAY !

     

    Must be same binary informix distribution and same Informix version including patch.

     

    If they upgrade the 11.50 to 11.70 or above, can be achieved thru ER

     

    Cheers

     

    ERic

     






  • 3.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Wed July 15, 2020 11:26 AM

    There is no need to upgrade the 11.5 to use ER

     






  • 4.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Wed July 15, 2020 06:14 PM
    Thanks Eric,
    My customer is considering transitioning to AIX or Solaris because HP-UX will end support in 2025. Sadly, there are no plans to invest in Informix.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 5.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Wed July 15, 2020 06:50 PM
    If they have the install for aix/solaris (or Linux) then ER the data over - subject to the ER limitations of 11.5

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 6.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Thu July 16, 2020 03:35 AM

    As Paul said, check archecker.
    11.50 probably allows to extract data from the archive.
    I remember this functionality was not in 10 not 11.10 and was introduced in 11.50 XXX ?

     

    Syntax is archecker -b -.......

     






  • 7.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Thu July 16, 2020 04:24 AM
    I am not sure this is strictly true although it may be all that is officially supported.

    Certainly the platform, major version, disk layout etc. must be the same, but I have in the past restored ontape/onbar to a different patch, at least once to get around a bug in 'ontape' (was some time ago). Not every patch results in changes to the underlying storage. I think 'onmode -b' gives an idea of what is possible. To be clear I am not recommending doing this; it would be preferable to restore to the exact same patch and then upgrade is that is what you want to do.

    Ben.

    ------------------------------
    Benjamin Thompson
    ------------------------------



  • 8.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Thu July 16, 2020 09:08 AM

    I think it has got tighter, but I have restored with minor version differences in the past.

     

     

     






  • 9.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Wed July 15, 2020 11:22 AM

    No

     






  • 10.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Wed July 15, 2020 06:01 PM
    Thanks Paul.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 11.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Wed July 15, 2020 06:56 PM
    Have you thought about using archecker to access the tables. Again not sure of limitations of archecker in 11.50

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC




  • 12.  RE: Is it possible to perform onbar backup/restore between heterogeneous platforms?

    Posted Thu July 16, 2020 09:09 AM
    Using archecker is a great idea. I'll try it on the test server.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------