Cause: Log apply services encountered a record in the archived redo log that could not be interpreted. See the solution below.
Error 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.
Database version: Oracle 11g Release 2 (11.2)