Informix

 View Only

  • 1.  Trying to recover a corrupt IDS 7.31 backup with ontape

    Posted Wed October 02, 2019 05:30 AM
    Hi Friends,

    I have been submitted a case for data recover at a customer's, running 7.31 UC3 on AIX 4.4.3(....!) who realized a few days ago about disk/chunks corruptions while he was trying to restore his oldest 'usable' backup done with ontape.

    ontape -r does not work because the backup is also corrupt at some places.

    I am considering using archecker to recover table by table, but, looking in the What's new history, the tables recover option looks to be released in V10.00xC10.

    I don't have access to the system yet, so I can't test the option.

    Does the archecker -t -X exists in that version ?

    any other idea to recover part of the backup ? dd'ing pages ? other?
    Not sure yet if the instance can start or not

    Yes, checking backups is important .....
    Eric

    ------------------------------
    [eric] [Verceletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]
    ------------------------------

    #Informix


  • 2.  RE: Trying to recover a corrupt IDS 7.31 backup with ontape

    IBM Champion
    Posted Wed October 02, 2019 06:01 AM
    The restore option to archecker was definitely not available before v10.00.

    According to JM3 the current archeckers "should" be able to extract data from older archives as well as from dbspace chunks directly. Never actually tried either myself.

    ------------------------------
    Art Kagel
    ------------------------------

    Original Message


  • 3.  RE: Trying to recover a corrupt IDS 7.31 backup with ontape

    Posted Wed October 02, 2019 06:16 AM
    Hi Art,


    this is definately what I will check. I have no access to the system yet, thus my question. I am not sure at all they have a recent oncheck -pe output. They have just forgotten that this instance was existing, although it serves a medical lab in a huge public hospital...

    Not sure also if they have already over-written the chunks with the restore attempts.
    Thanks and more news later
    Eric


    ------------------------------
    [eric] [Verceletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]
    ------------------------------

    Original Message


  • 4.  RE: Trying to recover a corrupt IDS 7.31 backup with ontape

    IBM Champion
    Posted Wed October 02, 2019 11:38 AM
    As archecker is a stand-alone utility the worse case is it will not work. It won’t hurt to try it.

    The 14.10 cdr binary runs happily on 11.7 install for example

    Cheers
    Paul

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


    Original Message


  • 5.  RE: Trying to recover a corrupt IDS 7.31 backup with ontape

    Posted Wed October 02, 2019 02:01 PM
    I will try to mount a 14.10 developer of the same platform and see what happens

    I will duely report on the result

    Thanks PW

    ------------------------------
    [eric] [Verceletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]
    ------------------------------

    Original Message


  • 6.  RE: Trying to recover a corrupt IDS 7.31 backup with ontape

    Posted Thu October 03, 2019 09:54 AM
    It's been a long time since I did anything with 7.31 but one thing I do clearly remember is trying and failing to recover a "corrupt" ontape backup using 7.31.UC8. It was fine when the restore target was 7.31.UD10. Can you try with this version? Ben.

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

    Original Message


  • 7.  RE: Trying to recover a corrupt IDS 7.31 backup with ontape

    Posted Thu October 03, 2019 09:54 AM
    Apologies if you get this twice but I distinctly remember there were bugs with ontape restores in 7.31.UC8 and the backup will appear to be "corrupt". Trying again with 7.31.UD10 might get a successful result, assuming you can get hold of this. Ben.

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

    Original Message