Informix

Expand all | Collapse all

HDR shutdown and Restart

  • 1.  HDR shutdown and Restart

    Posted 12 days ago
    Dears,

              Please let me know, if have HDR setup for PRIMARY AND SECONDARY and if we have to shutdown for patching activity both server then can we directly shutdown (onmode -ky) and then restart (oninit -vy) ?

    In this case if we start both servers directly thru oninit -vy  then will they automatically start as PRIMARY and Secondary?

                                                                       OR
    again when starting PRIMARY then also need to run onmode -d PRIMARY <sec_server>  and for Secondary onmode -d SECONDARY <prim_server>.

    kindly suggests.


    Thanks
    Amit


    ------------------------------
    AMIT PATEL
    ------------------------------


  • 2.  RE: HDR shutdown and Restart

    Posted 12 days ago

    Amit:

    No, there is no need to run onmode -d again just to restart either the primary or the secondary. You just restart both. If you have auto-upgrade set in the ONCONFIG file or through the Connection Manager, you will want to start the primary first so that the secondary doesn't upgrade itself or be upgraded to primary mode by the CM, otherwise it's just a restart.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: HDR shutdown and Restart

    Posted 12 days ago
    Dear Art,

        Yes , Currently DRAUTO set to 2 (Automatic).

         Thanks for clarification.

    Thanks
    Amit

    ------------------------------
    AMIT PATEL
    ------------------------------



  • 4.  RE: HDR shutdown and Restart

    Posted 12 days ago
    Just a side issue: You should ONLY use DRAUTO set to 2 if the network connection between the primary and secondary is ABSOLUTELY reliable to avoid the possibility of suffering from the "two brain problem". It is better to use Connection Manager to handle upgrading a secondary automatically because it can use other means to determine whether the primary is still online beyond just that the primary and secondary have stopped communicating. Just an FYI for you and to put this out there for others.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 5.  RE: HDR shutdown and Restart

    Posted 5 days ago
    Amit

    Another aside to bear in mind is that when you've patched the Primary node and brought it back online, don't leave it too long to patch the Secondary node and reestablish HDR connectivity. What you can not afford is for the Logical Logs on the Primary node to wrap around as that would mandate that you rebuild the Secondary from a fresh ontapeL0 of the Primary, or ifxclone if you prefer that method.

    ------------------------------
    Kirit Rana
    ------------------------------



  • 6.  RE: HDR shutdown and Restart

    Posted 5 days ago
    Not entirely true.

    If your secondary server (HDR or RSS) was down for so long that the oldest log it requires to start resyncing with primary isn't available any more on the primary, or if the backup you used to instantiate the secondary using physcial restore was so old, or restore took so long, the secondary simply would say:

    "DR: Start failure recovery from tape ..."

    in which case you now could perform a logical restore using ontape or onbar, so all you'd need are the log backups available.

    ------------------------------
    Andreas Legner
    ------------------------------



  • 7.  RE: HDR shutdown and Restart

    Posted 5 days ago
    Andreas

    LOL, too much hassle. I elect not to get into that situation, but yes you are quite correct.

    ------------------------------
    Kirit Rana
    ------------------------------



  • 8.  RE: HDR shutdown and Restart

    Posted 6 days ago
    Just a side note:  there's no point in -y (-vy) option if not using in conjunction with -i.  There's a severe risk, though, in using -y as it only takes an accidentially typed 'i' at that to cause major havoc (only FULL_DISK_INIT 0 will protect you nowadays.)

    ------------------------------
    Andreas Legner
    ------------------------------



  • 9.  RE: HDR shutdown and Restart

    Posted 6 days ago

    But you need the '-i' to put the engine into interactive mode .....

     

    Cheers

    Paul

     






  • 10.  RE: HDR shutdown and Restart

    Posted 6 days ago
    Naughty Paul.


    Clive Eisen
    GPG: 3818B5F1











  • 11.  RE: HDR shutdown and Restart

    Posted 5 days ago
    Edited by Kirit Rana 5 days ago
    LOL! That is funny.

    ------------------------------
    Kirit Rana
    ------------------------------



  • 12.  RE: HDR shutdown and Restart

    Posted 5 days ago
    Paul, that's a lie! I red years ago (1999) that: "I had this whole story ready about how oninit -i prepares your database for the internet! :-)" - by Obnoxio The Clown (https://bit.ly/3g4XlUu)
    :)
    Hrvoje


    ------------------------------
    Hrvoje Zokovic
    ------------------------------



  • 13.  RE: HDR shutdown and Restart

    Posted 5 days ago

    Sort of thing OTC would do – she could never be trusted :-P

     






  • 14.  RE: HDR shutdown and Restart

    Posted 6 days ago
    oninit -i is the reason why I stopped using onstat -i many years ago and only have once since (very CAREFULLY and very SLOWLY)!

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 15.  RE: HDR shutdown and Restart

    Posted 6 days ago

    FULL_DISK_INIT has saved us all many times :-P