The “show capture detail” returns a status of “waiting for logfile” (4297939)

The “show capture detail” returns a status of “waiting for logfile”

The “show capture detail” returns a status of “waiting for logfile”

Capture has been instructed to wait for restoration of archive logs during a log wrap situation.

Normally Capture will error out when a log wrap situation is encountered. It is now possible to instruct the Capture to stop altogether or wait for a specified time interval before attempting to restart once it encounters a log wrap. This is done by configuring the Capture parameter SP_OCT_LOGWRAP_RESTART to a value of 0 or a specific time interval expressed in seconds. If it set to 0, then the Capture will remain stopped till the archived logs required by it are restored and the Capture is then restarted manually. If it is set to a specific time interval, then Capture will restart after the elapse of that time interval. It is imperative that the archive logs required by Capture be restored during that time interval or else Capture will keep attempting to read the archive logs, stop if the logs are not restored and then make another attempt to read them and so on.

If you wish to have Capture stop altogether when encountering a log wrap, set the parameter as follows and bounce Capture to have the parameter take effect:

sp_ctrl>set param SP_OCT_LOGWRAP_RESTART 0

sp_ctrl>stop capture

sp_ctrl>start capture

In the event a log wrap occurs after the above setting of Capture, then Capture will be stopped due to error when encountering a log wrap. You can restore the missing archive log(s) and then manually restart Capture.

If you wish to have Capture stop for a designated time interval when encountering a log wrap and then subsequently restart and keep checking for the availability of the missing archive logs, set the parameter as follows and bounce Capture to have the parameter take effect:

sp_ctrl>set param SP_OCT_LOGWRAP_RESTART <n seconds>      (where n is an integer)

sp_ctrl>stop capture

sp_ctrl>start capture

The following describes the parameter as taken from SharePlex Reference Guide for SharePlex 9 and up: SP_OCT_LOGWRAP_RESTART This parameter controls how Capture behaves in response to the following situations: *The archives are not available. *Capture is denied permission to open a log. When Capture cannot find an archive log, or when it cannot open a log, the process stops by default (a setting of 0). At this setting, when Capture cannot access a log, the show capture command returns a status of "Stopped due to missing archive log." You can configure Capture to wait a certain amount of time (in seconds) and then start again automatically. This allows time to assign the correct read permissions or run any external log-management processing that moves the archives into the location expected by SharePlex. Capture waits, checks for the logs, stops if they are not yet available or cannot be opened, and continues checking and stopping until the logs are restored or opened. At this setting, the show capture command returns a status of "waiting for logfile." Default: 0 seconds (do not restart automatically if logs are not available) Range of valid values: 1 to any positive number of seconds Takes effect: when Capture is restarted