Oracle DBA, How To, Error, Cause and Action

ORA-16211: unsupported record found in the archived redo log

ORA-16211: unsupported record found in the archived redo log


Cause:


Log apply services encountered a record in the archived redo log that could not be interpreted.



Action:


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.

No comments:

Post a Comment

Thanks for your comment.