The following errors are observed when analyzing a config starting with a specified SCN #:
sp_ctrl (alvsupu15:5438)> analyze config config1 SCN=2327896006 5 minutes
Error: Unable to activate config at 2327896006
The “show log reverse” gives the following errors:
Info 2016-12-06 16:59:03.219564 12410 1 Activation exited with code=1, pid = 22875 (activating sid ORA11GR2)
Error 2016-12-06 16:59:03.184161 22875 1 Compile of "config1" for sid o.ORA11GR2 failed: Error: Unable to activate config at 2327896006
Error 2016-12-06 16:59:03.179851 22875 1 Activation: Failed to find redo sequence# associated with recovery SCN 2327896006 for instance: 'ORA11GR2' thread: '1'. ORA-01405: fetched column value is NULL (activating sid ORA11GR2) [module ocf]
Warning 2016-12-06 16:59:02.890361 22875 1 Activation: 13007 - No unique keys or primary key for object id 204368 (activating sid ORA11GR2) [module osp]
Restore the archive logs beginning with the one that is associated with the specified SCN # and re-issue the analyze command.
OR
Issue the analyze command with a different SCN # for which the archive log exists.
