文档解释
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有效重新启动重做日志组。
