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
so my maxlogmembers is 3, why is that i was able to create a group with 4 members?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
thank you so much sir/mam =)Code:SYS@xe:SQL>select group#, members from v$log 2 / GROUP# MEMBERS ---------- ---------- 1 1 2 1 3 4




Reply With Quote