DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: MAXLOGMEMBER exceeded but no error

Threaded View

  1. #3
    Join Date
    Aug 2006
    Posts
    22
    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
    Last edited by ehegagoka; 08-02-2006 at 04:53 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width