| Creating Control File [message #135875] |
Sat, 03 September 2005 14:39  |
A.Mohammed Rafi
Messages: 15
Registered: September 2004
|
Junior Member |
|
|
Hai,
Could you please let me know the syntax for creating the control file.
thanks in advance.
Regards,
A.Mohammed Rafi.
|
|
|
|
|
|
|
|
| Re: Creating Control File [message #137597 is a reply to message #135875] |
Thu, 15 September 2005 11:30  |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
Hi A.Mohammed Rafi,
Are you trying to create a multiplex copy of your controlfile? Or have you lost your controlfiles and are trying to build a whole new one?
If you've lost them then a controlfile script will help, however if you are trying to multiplex (having more than 1) then the procedure would be..
1. shutdown your database
2. copy your controlfile to it's new location.
3. update your init.ora file
controlfiles='original ctl file','copy ctl file'
4. restart the database
If you follow then in that order you should have no problems.
Allie
PS Check the permissions on the file you have just copied to make sure they have the same as the original.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
