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 =)