Oracle Error ORA-26926: Unable to attach because capture “string” is missing dictionary redo logs

Oracle Error Message

ORA-26926: Unable to attach because capture “string” is missing dictionary redo logs

Reason for the Error

The specified capture was unable to locate the dictionary redo log.

Solution

Check the state of the specified capture from GV$STREAMS_CAPTURE to determine the SCN or file name of the missing log file. Confirm that the file name exists and is accessible online and also in the DBA_REGISTERED_ARCHIVED_LOG view. In addition, for local capture, confirm that an entry exists for the file in the V$ARCHIVED_LOG view. If an entry is missing, it can be added using the ALTER DATABASE REGISTER …. LOGFILE command, specifying the keyword LOGICAL LOGFILE or PHYSICAL LOGFILE as appropriate.