Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MaxLogMembers has been exceeded...

sgalaxyFeb 10 2009 — edited Feb 11 2009

Hi,
I created a 10g v.2 db using the DBCA...
Having executed the following command:
SQL> alter database backup controlfile to trace as '......' NoResetLogs;
so as to have the capability to re-create the control file in case of its destruction....
I have noticed in the file generated:

...
.....
CREATE CONTROLFILE REUSE DATABASE "INFO" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\INFO\REDO01.LOG'  SIZE 50M,
.....
..... 

But,

alter database add logfile member 'D:\OracleDB_Backup\a','D:\OracleDB_Backup\b','D:\OracleDB_Backup\c' to group 5;
 
Database altered
 
SQL> alter database add logfile member 'D:\OracleDB_Backup\r' to group 5;
 
Database altered

SQL>  select status,type,member from v$logfile where group#=5;
 
STATUS  TYPE    MEMBER
------- ------- --------------------------------------------------------------------------------
        ONLINE  D:\ORACLEDB_BACKUP\A
        ONLINE  D:\ORACLEDB_BACKUP\B
        ONLINE  D:\ORACLEDB_BACKUP\REDO06.LOG
        ONLINE  D:\ORACLEDB_BACKUP\C
        ONLINE  D:\ORACLEDB_BACKUP\R 

Note: I created 5 members in this group... not only 3.

Additionally, when i try to insert another log file member to this log group i get the expected(!) error message:

SQL> alter database add logfile member 'D:\OracleDB_Backup\x' to group 5;
 
alter database add logfile member 'D:\OracleDB_Backup\x' to group 5;
 
ORA-00357:too many members specified for log file, the maximum is 5

Why is there this difference between the maxlogfilemembers written in the trace file (using the backup controlfile....) and the max log file members reported in the error message(ORA-00357)...???

Thank you,
Sim

This post has been answered by 181444 on Feb 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2009
Added on Feb 10 2009
3 comments
2,358 views