Home » RDBMS Server » Server Administration » MAXLOGMEMBER exceeded but no error
MAXLOGMEMBER exceeded but no error [message #185529] Wed, 02 August 2006 03:03 Go to next message
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

Re: MAXLOGMEMBER exceeded but no error [message #186106 is a reply to message #185529] Sat, 05 August 2006 20:51 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
The MAXLOGMEMBERS parameter in the CREATE DATABASE statement determines the maximum number of redo logs in a group. As per Don Berleson, one of Oracle's gurus.
Re: MAXLOGMEMBER exceeded but no error [message #186177 is a reply to message #186106] Sun, 06 August 2006 19:08 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
yep i know, that's why i asked why i was able to go beyond that MAXIMUM NUMBER.
Previous Topic: Change Character set from UTF8 to WE8MSWIN1252
Next Topic: ORA-01575: timeout waiting for space management resource
Goto Forum:
  


Current Time: Mon Dec 05 10:41:46 CST 2016

Total time taken to generate the page: 0.05108 seconds