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
------------------------------
Original Message:
Sent: Thu August 19, 2021 03:25 AM
From: data icons
Subject: Subscription stopped
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