Error: F_JD2822 Unable To Find Log Files or Archives With Valid Non-Zero Sequences
Issue
Capture fails with 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
Resolution
On the location group for the capture (source database), add a new action with **/Name=HVR_ENROLL_VLOG_RESTRICT /Value="thread# <> ", then run HVR Initialize with options Table enrollment and Scripts and Jobs or drop the logfile groups belonging to the specific thread, for example, 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 Initialize with options Table enrollment and Scripts and Jobs.
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.