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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:43

ORA-16211：在归档重做日志中找到不支持的记录,
.原因：日志应用服务遇到归档重做日志中无法解释的记录。,
.操作： 1.使用DBMS_LOGSTDBY.INSTANTIATE_TABLE在备用数据库上重新创建表，或者如果表不重要，则删除表。,
.2. ALTER数据库开始逻辑待机应用;,
.,
.3.检查DBA_LOGSTDBY_EVENTS视图中的current_scn列，以确定哪个日志文件包含不支持的记录。,
.,
.4.将日志文件提供给Oracle支持服务。,
.,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题