ORA-00362: member is required to form a valid logfile in group 3ORA-01517: log member:

Posted on April 23, 2022 by kishan1 Minute Read

Cause:

If a new member is added to group and old logfile is dropped, then the error is triggered due to invalid status of new logfile.

kIsH@x3z6zx9<^>alter database drop logfile member '+RECOX/x3z6zx9/onlinelog/group_3.259.1098264695';
alter database drop logfile member '+RECOX/x3z6zx9/onlinelog/group_3.259.1098264695'
*
ERROR at line 1:
ORA-00362: member is required to form a valid logfile in group 3
ORA-01517: log member: '+RECOX/x3z6zx9/onlinelog/group_3.259.1098264695'

Action:

Initialize the logfile with a manual log switch

kIsH@x3z6zx9<^>alter system switch logfile;

System altered.

kIsH@x3z6zx9<^>alter database drop logfile member '+RECOX/x3z6zx9/onlinelog/group_3.259.1098264695';

Database altered.

Published by kishan

Desire and obsessive to learn ! Generic technology enthusiast who have dynamic experience in database and other technologies. I have persistence to learn any niche skills faster. Served multiple DBA roles in fortune 500 companies to proactively prevent unexpected failure events. Inclined to take risks,face challenging situations and embrace fear! ***I would like to share my thoughts and ideas to this world !*** View all posts by kishan