This discussion is archived
1 Reply Latest reply: Oct 18, 2012 3:10 AM by Ajay S RSS

skip Missing Redo File in oracle streaming

malhi Newbie
Currently Being Moderated
Is it possible to skip a Missing/corrupt Redo File in oracle streaming. If it is possible, then how.
  • 1. Re: skip Missing Redo File in oracle streaming
    Ajay S Newbie
    Currently Being Moderated
    Hi,

    If your are facing missing archive logs in Oracle streams , the STATE column in V$STREAMS_CAPTURE view will show you WAITING FOR REDO.
    during this you can run below QUERY to find sequence of missing archive logs:

    1)
    SELECT THREAD, seq + 1 first_seq_missing, next_seq - 1 last_seq_missing,
    next_seq - seq - 1 missing_count
    FROM (SELECT thread# THREAD, sequence# seq,
    LEAD (sequence#, 1, sequence#) OVER (PARTITION BY thread# ORDER BY sequence#)
    next_seq
    FROM dba_registered_archived_log, dba_capture
    WHERE capture_name = '&capture_name'
    AND consumer_name = capture_name)
    WHERE next_seq - seq > 1
    ORDER BY 1, 2;

    2)Once you get list of missing archive logs , you can check them physically by checking on archive log path.
    3) if the archived log is not in location then, it is missing.
    4) if archived log is present in location, means it is not registered, then register them manually for CAPTURE process to pick them up.

    Thanks,
    Ajay

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points