Post

2 followers Follow
0
Avatar

FATAL-9087: Could not find any valid archive or online redo log 199049)


We took an initial load on last sunday and after that we have restarted the mine process but it was continuously abending with the following FATAL error ( INFO> Redo file considered E:\ORCL\ARCHIVELOG/.../O1_MF_1_199049_914818875_.ARC (score: 11010)
2017/11/23 11:01:09 INFO> Trying to create support package (base error: FATAL-9087: Could not find any valid archive or online redo log 199049)

we have change the parameter (*.MINE_ARCH_DEST_FORMAT = %t_%s_%r.ARC) in mine ddc file before taking the initial load, now we don't have previous archive log format to reset the value.

please suggest how to fix this issue.

himanshu mathpal Answered

Official comment

Avatar

The issue is MINE is looking for an archive log file which is no longer available. Check that the redo log199049 (thread 1) is in v$archived_log.

It should be in this view and the file name should be filled in. The error message suggest the file name is NULL now, meaning it was deleted by rman.

Solution

You can either restore the archive log(s) from backup using rman or start the replication from scratch.

Charmaigne Bezuidenhout

Please sign in to leave a comment.

1 comment