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

Thread: MAXLOGFILES, MAXLOGMEMBERS...

  1. #1
    Join Date
    Apr 2001
    Posts
    8
    Hi,

    Maybe, I was a little unclear before.

    How can I find MAXLOGFILES, MAXLOGMEMBERS,
    MAXDATAFILES... information for an existing DB ?

    For example, I am working with a database that has been created
    by somebody else who no longer works with our company.

    Where can I look to find out MAXLOGFILES, MAXLOGMEMBERS,
    MAXDATAFILES parameters that are currently allocated for the
    database? Is there a data dictionary view that could tell me this?

    Thank you in advance for all your responses.

    Ksana

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    In the future, please reply to your original thread instead of creating a new one. http://www.dbasupport.com/forums/sho...threadid=14920
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    Cool

    The following will tell you everything that you want to know.

    log into svrmgrl and execute the following command
    alter database backup controlfile to trace;

    This will create a file in you udump or trace directory depending on you version of oracle. Edit the file and you will find the answer. This file can be edited and used to recreate your control files. At which time you can change MAXLOGFILES, MAXLOGMEMBERS etc.

    STARTUP NOMOUNT
    CREATE CONTROLFILE REUSE DATABASE "MYSID" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 4
    MAXDATAFILES 254
    MAXINSTANCES 1
    MAXLOGHISTORY 226
    LOGFILE
    GROUP 1 'D:\ORACLE\ORADATA\MYSID\REDO01.LOG' SIZE 1M,
    GROUP 2 'D:\ORACLE\ORADATA\MYSID\REDO02.LOG' SIZE 1M,
    GROUP 3 'D:\ORACLE\ORADATA\MYSID\REDO03.LOG' SIZE 1M
    DATAFILE
    'D:\ORACLE\ORADATA\MYSID\SYSTEM01.DBF',
    'D:\ORACLE\ORADATA\MYSID\RBS01.DBF',
    'D:\ORACLE\ORADATA\MYSID\USERS01.DBF',
    'D:\ORACLE\ORADATA\MYSID\TEMP01.DBF',
    'D:\ORACLE\ORADATA\MYSID\TOOLS01.DBF',
    'D:\ORACLE\ORADATA\MYSID\INDX01.DBF',
    'D:\ORACLE\ORADATA\MYSID\TMPMYSID.ORA',
    'D:\ORACLE\ORADATA\MYSID\USER_DATA.ORA'
    CHARACTER SET WE8ISO8859P1
    ;

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