Maximum number of Control Files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Maximum number of Control Files

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    What is the maximum number of control files and redo log files you can create.

    Thanks
    Anurag

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    As per oracle, you could have any number of control files but as they are usually multiplexed, I feel, it is limited to the number of disks you have. I may be wrong, but is logical
    badrinath

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi

    I agree with badrinath logically I dont think there is maximum no of control files and redo log files in oracle as they are multiplexed I dont think we will go to a limit where we are going to have 100's of control files for an Instance and 100's of redo log file.The resources in ur environment is the only restriction.

    Regards
    Santosh

  4. #4
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    control files max of 32 and log groups of max 255
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  5. #5
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    The maximum number of control files is 8 whereas maximum no of log groups is 32.The default mininum and maximum are dependend on ur O/S

    regards,
    Rohit Nirkhe,Oracle DBA,OCp 8i
    rohitsn@altavista.com

  6. #6
    Join Date
    Sep 2000
    Posts
    362
    I thought that I am the only person who has different views about this question. Now I have varied answers for the same question and have become more confused.

    Thanks
    Anurag

  7. #7
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    I agree with Rohitsn,
    COntrol file = 8
    logfiles = 32
    There Nothing You cannot Do, The problem is HOW.

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