Maximum Logfile memebers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Maximum Logfile memebers

  1. #1
    Join Date
    Aug 2002
    Posts
    176
    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



    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Aug 2002
    Posts
    176
    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
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.

    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Aug 2002
    Posts
    176


    Thank You So Much

    It Works fine

    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width