| Control file's [message #157241] |
Wed, 01 February 2006 04:30  |
Bharath Kumar ,V
Messages: 18
Registered: February 2004
|
Junior Member |
|
|
Hi,
1.Why we need to create more then one control file?
2.How many control file is required and how many is recommended?
3.If we create more then one control file, all control files will have the same information?
Regards
Bharath.
|
|
|
|
| Re: Control file's [message #157251 is a reply to message #157241] |
Wed, 01 February 2006 05:13  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Hi,
the questions indicate that you are not very clear about purpose and use of control files. For complete details refer:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/control.htm#5999
To give short answers to your questions:
1.we need more than one control file ,to protect the database..just as we keep more than one key of the locker..if one key is lost , we can use the other one.Same way,more than one control file will help to protect the database, say when one of the control file is corrupted, you can replace it with the other good copy.
2. Minimum one. recommended at least 2.
3. Yes, oracle gurantees it. These are binary files and the all details in it are maintained in it automatically by oracle.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
Nice support, Thanks for your clear explanation