Problem:

Capture fails with tone of the following errors:

F_JD2822 Unable to find log files or archives with valid non-zero sequences in the system tables while searching for timestamp.

F_JT0528: The previous error occurred while initializing cluster thread in reader.

Environment

HVR 5

Cause:

The 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"