Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Resync RSS server

    Posted Thu January 23, 2025 02:31 AM
    Edited by Sh To Thu January 23, 2025 02:31 AM

    Hello

    I need to re-initiate synchronization between a primary server and the RSS.

    They re currently connected, active

    prim:/prod/dbown>onstat -g cluster

    ...

    Server      ACKed Log    Applied Log  Supports     Status

                (log, page)  (log, page)  Updates

    ids_tlv_rss 0,0          0,0          No           ASYNC(RSS),Connected,Active

    Do I need to first disconnect them completely and run the commands

    On primary server

    onmode -d add RSS rss_ha_alias

    ontape -s -L 0 -t STDIO -F | ssh secondary_host ontape_RSS_restore.ksh

    On RSS server

    onmode -d RSS primary_ha_alias

    Or, or just re-run the script

    ontape -s -L 0 -t STDIO -F | ssh secondary_host

    Thanks


    Sam



  • 2.  RE: Resync RSS server

    Posted Thu January 23, 2025 06:27 AM

    Hi Sam,

    ain't this - the two servers "connected" and "active", yet no logs being transferred - the picture when the primary is too far ahead of the secondary, so won't have the logs on disk any more that the secondary expects next?  You'd be able to tell this from a message on secondary side to the effect that it expects logs from tape (rather than disk).

    If this is the case, what you can try is

    1. bring the secondary up in recovery mode (oninit -PHY)  -  as if it had been physically restored, expecting logical restore now
    2. tell it it's meant to be an RSS:  onmode -d RSS <primary_name>     (it should still be known as an RSS on the primary)
    3. initiate a log restore, provided everything required for this is in place: ontape -l

    HTH,
     Andreas



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------



  • 3.  RE: Resync RSS server

    Posted Fri January 24, 2025 02:37 AM
    Edited by Dennis Melnikov Fri January 24, 2025 02:38 AM

    Sam,

    3. If you use onbar for backup, then copy ixbar.<SERVERNUM> to the RSS before running `onbar -r -l`. Make sure the ixbar contains a log physical restore has reached.

    Did you try to restart the RSS?


    ------------------------------
    Sincerely,
    Dennis
    ------------------------------

    Original Message


  • 4.  RE: Resync RSS server

    Posted Sun January 26, 2025 02:39 AM

    Hello,

    Yes I tried to restart.

    Andreas, effectively it expects logs from tape

    14:39:25  RSS: Start failure recovery from tape ...

    I'll try a log recovery

    Thanks



    ------------------------------
    Samuel To
    ------------------------------

    Original Message


Related Content