Informix

nested-group-icon.png

DB2

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 25 days ago
    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 25 days ago

    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 25 days ago

    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 24 days ago
    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 24 days ago
    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 24 days ago

    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 24 days ago
    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 24 days ago

    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 25 days ago

    No

     






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

    Posted 24 days ago
    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 24 days ago
    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 24 days ago
    Using archecker is a great idea. I'll try it on the test server.

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