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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...