Hi,
What is the maximum number of control files and redo log files you can create.
Thanks
Anurag
Printable View
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
control files max of 32 and log groups of max 255
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