How to Resolve ORA-00357: too many members

  • by

ORA-00357

Tried to add more member to an existing group, but it failed with ORA-00357.

SQL> alter database add logfile member '+DATA/ORCLCDB/redo01g.log' to group 1;
alter database add logfile member '+DATA/ORCLCDB/redo01g.log' to group 1
*
ERROR at line 1:
ORA-00357: too many members specified for log file, the maximum is 5

ORA-00357 means that you can't add more logfiles to the group, because the number of members in that group has already reached the maximum.

According to Database Limits of 19c Database Administrator's Reference for Linux and UNIX System-Based Operating Systems, the upper limit of MAXLOGMEMBERS is 5, no more.

Here I list the database limits in controlfile.

ParameterDefaultMaximum
MAXLOGFILES164220
MAXLOGMEMBERS25
MAXLOGHISTORY10065534
MAXDATAFILES3065534
MAXINSTANCES11055

In some databases, multiplexing more redo log members could cause undesired IO bottlenecks. To balance IO resource and media loss, having 2 members at most in a group is pretty safe in practice.

Further reading: How to Check Archive Log Size.

Leave a Reply

Your email address will not be published. Required fields are marked *