Oracle capture fails with error F_JD2822

This topic contains 0 replies, has 1 voice, and was last updated by  Herman Verheul 1 month, 1 week ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #8745

    Herman Verheul
    Participant

    Problem:

    Capture fails with error F_JD2822 Unable to find logfiles or archives with valid non-zero sequences in the system tables while searching for timestamp and additional error F_JT0528: The previous error occurred while initializing cluster thread in reader

    Cause:

    Specific redo thread mentioned in error F_JT0528 is not used. The status in view v$log shows UNUSED for the specific thread

    Solution:

    On the location group for the capture (source database) add a new action with /Name=HVR_ENROLL_VLOG_RESTRICT /Value=”thread# <> ” , then run HVR LOAD/HVR Initialize with options “Table enrollment” and “Scripts and Jobs” or Drop the logfile groups belonging to the specific thread , e.g if groups 7,8,9 are belonging to thread 2 and status for those groups in v$log is UNUSED;

    ALTER DATABASE DROP LOGFILE GROUP 7;
    ALTER DATABASE DROP LOGFILE GROUP 8;
    ALTER DATABASE DROP LOGFILE GROUP 9;

    then run HVR LOAD/HVR Initialize with options “Table enrollment” and “Scripts and Jobs”

    • This topic was modified 1 month, 1 week ago by  HVR Software.
    • This topic was modified 1 month, 1 week ago by  HVR Software.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

© 2017 HVR Software

Request Trial Contact Us