Oracle Error Message
ORA-16211: unsupported record found in the archived redo log
Reason for the Error
Log apply services encountered a record in the archived redo log that could not be interpreted.
Solution
1. Use DBMS_LOGSTDBY.INSTANTIATE_TABLE to re-create the table on the standby database or simply drop the table if it’s unimportant.
2. ALTER DATABASE START LOGICAL STANDBY APPLY;
3. Examine the current_scn column in the DBA_LOGSTDBY_EVENTS view to determine which log file contains the unsupported record.
4. Provide the log file to Oracle Support Services.
