WAITING FOR DICTIONARY REDO: FILE
649789Mar 9 2009 — edited Mar 30 2009Hi all ,
I am getting WAITING FOR DICTIONARY REDO: FILE NAME state
SELECT STATE FROM V$STREAMS_CAPTURE ;
I tried to resolve it and found that some redo log file is missing.
Can anybody please let me know what could be the cause of missing redo log file?
If the cause for this is that some redo log file is not registered then how would i register it ?
I already have queried the DBA_REGISTERED_ARCHIVED_LOG and DBA_CAPTURE data dictionary views and i am getting some rows.
Thanks to all.
Regards
Nick