Oracle Solution for Error ora-55519

Solution for Oracle Error ORA-55519

ORA-55519: Supplemental logging not available for mining SCN range

What triggered the Error:

Flashback Transaction cannot work if there are regions in the mining range where supplemental logging is not enabled.

What should we do to fix it:

If you have provided a SCN/time hint which is approximate and far beyond the specified transaction start time, then readjust the SCN hint and try again. If the system has figured out the transaction start time or you are sure of the range, then the specified transaction cannot be backed out.