Data Replication

  • 1.  Subscription stopped

    Posted Thu August 19, 2021 03:25 AM

    Oracle Database 19c Enterprise Edition Release
    IBM InfoSphere Data Replication 11.4

    IBM InfoSphere Data Replication daemon has encountered an error message.
    Redo log file information not found for subscription SHAREDSCRAPE. The Oracle database does not contain valid redo log file information corresponding to the log position '251350198014.0.0.0.0.0.0' for the current database incarnation. Error detected in file OracleRedoNativeApi.java at line 1526. This may be caused by any of the following: a) The SCN portion of the log position 251350198014.0.0.0.0.0.0 is invalid. b) The SCN associated with log position 251350198014.0.0.0.0.0.0 does not correspond to a current on-line redo log file and ARCHIVELOG mode is not enabled. c) The redo log file(s) corresponding to log position 251350198014.0.0.0.0.0.0 does not currently exist, exists but is inaccessible or exists and is corrupt. d) The control file contains invalid information. e) The database was shut down abort. Re-start replication will resolve this issue. f) There was error archiving redo logs because of insufficient disk space. Try to resolve this issue by doing the following and re-start replication: a) Change the log position to specify a correct SCN value. b) Examine the views V$LOG and V$ARCHIVED_LOG to determine a valid SCN for which a corresponding online or archived redo log file exists. Change the log position to specify a valid SCN for the current database incarnation. c) Restore a valid copy of the required redo log file(s) from backup. d) Ensure the disk space for archived redo logs is not full.

    How can I check the redo log?
    The subscriptions is stopped when I checked back, may I know what scn number should I use to continue back the mirroring?
    What is the step I need to do before I run mirroring?
    May i know need to use the current SCN number to run start mirroring and will it cause data lost?
    Kindly advise.

    ------------------------------
    data icons
    ------------------------------



    ------------------------------
    data icons
    ------------------------------


    #DataReplication
    #DataIntegration


  • 2.  RE: Subscription stopped

    Posted Fri August 20, 2021 03:22 AM
    Looks like your subscription was down for longer time and log file is not there in disk now. 

    Please work with your Infrastructure oracle DBA to get logs file restored ( they can use SCN number from below alert).

    once  you have log restored you can start mirroring.

    ------------------------------
    Abhishek Kumar
    ------------------------------



  • 3.  RE: Subscription stopped

    Posted Fri August 20, 2021 12:28 PM
    Hi:

    Most probably the issue is a missing archive log.  You can check that with dmshowlogdependency command executed where the  source agent is installed.  Details on paramters are in dmshowlogdependency - Show log dependency - IBM Documentation. For example, to list missing archive logs:

    dmshowlogdependency -I MYINSTANCE -m -A

    ------------------------------
    DANIEL JOSE LEMA GUANZIROLI
    ------------------------------