Maximum Logfile memebers

[Rohit]

hi all

When i installed the database it had only one log file member per group as usual. Now i added a new member to each. Then when i try to remove it it shows error


SQL> alter database drop logfile member 'e:\jems\redo1.log';
alter database drop logfile member 'e:\jems\redo1.log'
*
ERROR at line 1:
ORA-00362: member is required to form a valid logfile in group 1
ORA-01517: log member: 'e:\jems\redo1.log'

Is it must that log files have to be multi plexed . If not where can i change the the number of minumum members.

Thanks

[jmodic]

The logfile you are trying to remove is the only member in the group 1, that's why you can't remove it from the group - each group must have at least 1 member. If you realy want to get read of this log file, you have to remove the redolog group:

ALTER DATABASE DROP LOGFILE GROUP 1;

[Rohit]

Sorry jmodic i do not want to remove the group i want to remove one of the member and the group has two members



SQL> select * from V$logfile where group#=1;

GROUP# STATUS MEMBER
----------------------------------------------
1 STALE E:\ORACLE\ORADATA\WINTER\REDO01.LOG
1 STALE E:\JEMS\REDO1.LOG


These are the members of the group
and i have three groups .

Could you Guide me now Please , Thanks

[jmodic]

Try switching logfiles couple of times in order to get rid of the status STALE in both members of group 1.

Isue "ALTER SYSTEM SWITCH LOGFILE;" three times to cycle through all the groups, then try your "DROP LOGFILE MEMBER..." again.

[Rohit]

Thank You So Much

It Works fine