-
Hi,
What is the maximum number of control files and redo log files you can create.
Thanks
Anurag
-
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
-
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
-
control files max of 32 and log groups of max 255
A Winner never Quits, A Quitter never Wins
Ganesh .R
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|