| add controle files oracle 10 [message #131090] |
Thu, 04 August 2005 05:48  |
patrick
Messages: 83
Registered: December 2000
|
Member |
|
|
I am running oracle 10g.
I know it is possible to use the EM to add additional control files. But i can't find it anymore.
I went to administration --> all initialization paramaters --> SPfile --> but here i can't add additional control files.
How do i do this?
Thanks for the help.
|
|
|
|
| Re: add controle files oracle 10 [message #131097 is a reply to message #131090] |
Thu, 04 August 2005 06:24  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
hi ,
STEPS
--> shutdown the database with shutdown immediate/normal.
--> Copy the control file to another location using your OS commands.
--> Modify the CONTROL_FILES parameter in init.ora file to include the additional control file.
--> Restart the Oracle .
u can verify the changes through V$CONTROLFILE view.
regrds,
tarun
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
