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

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s