ORA-16161: Cannot mix standby and online redo log file members for group string

文档解释

ORA-16161: Cannot mix standby and online redo log file members for group string

Cause: An attempt was made to add a log file member that did not match the other member types. This problem typically occurs when adding a standby log file member to an online redo log file group, or adding an online redo log file member to a standby redo log file group.

Action: Verify the log file group type using the TYPE column of the V$LOG fixed view.

？

ORA-16161 错误提示不能混合指定组中的线上和备用重做日志文件成员。

官方解释

ORA-16161表示无法将备份重做日志文件和在线重做日志文件组合在同一组中。

常见案例

在实施Oracle的压缩重做日志文件的普遍STATELESS时，用户会收到ORA-16161错误消息。

一般处理方法及步骤

ORA-16161错误可以通过以下步骤来修复：

1.将在线和备用重做日志文件设置到不同的组中。

2.考虑为在线重做日志重新索引比较好的文件组。

3.删除不必要的重做日志文件。

4.用ALTER SCHEMA SESSION有效重新启动重做日志组。