MAXLOGMEMBER exceeded but no error

Printable View

08-02-2006, 04:31 AM
ehegagoka

MAXLOGMEMBER exceeded but no error

hi!
im reading on maxlogmembers which is supposed to be the maximum number of members per redo log group, i have in my control file like this

Code:

CREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_2BVJPVKD_.LOG' SIZE 50M, GROUP 2 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_2BVJPXM1_.LOG' SIZE 50M -- STANDBY LOGFILE DATAFILE 'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF', 'C:\ORACLEXE\ORADATA\XE\UNDO.DBF', 'C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF', 'C:\ORACLEXE\ORADATA\XE\USERS.DBF' CHARACTER SET AL32UTF8

so my maxlogmembers is 3, why is that i was able to create a group with 4 members?

Code:

SYS@xe:SQL>select group#, members from v$log 2 / GROUP# MEMBERS ---------- ---------- 1 1 2 1 3 4

thank you so much sir/mam =)
08-02-2006, 04:41 AM
davey23uk

it will just expand the limit in the control file
08-02-2006, 04:46 AM
ehegagoka

hi! thanks for the reply, but shouldnt it report an error? that i exceeded the number of members? does that mean i can also exceed the number of groups?

i traced controlfile, and it changed =)

Code:

CREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 5 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_2BVJPVKD_.LOG' SIZE 50M, GROUP 2 'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_2BVJPXM1_.LOG' SIZE 50M -- STANDBY LOGFILE DATAFILE 'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF', 'C:\ORACLEXE\ORADATA\XE\UNDO.DBF', 'C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF', 'C:\ORACLEXE\ORADATA\XE\USERS.DBF' CHARACTER SET AL32UTF8
08-02-2006, 05:03 AM
Thomasps

Also you can see the current value for MAXLOGMEMBERS

select x$kccdi.dimlm from sys.x$kccdi;
08-02-2006, 05:05 AM
davey23uk

its not an error, the same happens with madatafiles as well, if you go past the limit in the controlfile it expands
08-02-2006, 05:06 AM
ehegagoka

hi!
thank you so much sir for that =) also what does the document mean in here that it will consume space?

Quote:

Using group numbers can make administering redo log groups easier. However, the group number must be between 1 and MAXLOGFILES. Do not skip redo log file group numbers (that is, do not number your groups 10, 20, 30, and so on), or you will consume space in the control files of the database.

also....(sorry for too many questions)

if logwriter write on a per group batch (is that right?) why is there a situation where in two groups a marked as CURRENT (does this mean the'yre both being written to?), heres the query =)

Code:

SQL> select group#, members,status from v$log; GROUP# MEMBERS STATUS ---------- ---------- ---------------- 1 2 INACTIVE 2 2 CURRENT 3 2 INACTIVE 4 2 ACTIVE 5 2 INACTIVE 6 2 INACTIVE 7 2 INACTIVE 8 2 CURRENT 8 rows selected

i hope i've explained it well thanks =)