| MAXLOGMEMBER exceeded but no error [message #185529] |
Wed, 02 August 2006 03:03  |
ehegagoka
Messages: 493
Registered: July 2005
|
Senior Member |
|
|
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
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?
SYS@xe:SQL>select group#, members from v$log
2 /
GROUP# MEMBERS
---------- ----------
1 1
2 1
3 4
updates ..........
its not an error, it really automatically extends to the control file the changes, after exceeding the max allowed my control file is updated.
[Updated on: Wed, 02 August 2006 05:12] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
