How to fix the Oracle error ORA-16161: Cannot mix standby and online redo log file members for group string?

In this post, you’ll learn more about the Oracle ErrorORA-16161: Cannot mix standby and online redo log file members for group string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error ORA-16161: Cannot mix standby and online redo log file members for group string ?

You can fix this error in Oracle by following the below steps

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