Home » RDBMS Server » Server Administration » control file
control file [message #241461] Tue, 29 May 2007 13:18 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Hello sir


we have tried to multiplexing the controlfile in our linux server

I have down the server and then copied the already exisited control file from disk1 to disk2

eg: cp /mnt/disk1/ctrl01.ctl /mnt/disk2/ctrl02.ctl

then also put new entry in parameter file for new control file path

after that i have strated the database and checked the new control file used with >v$controlfile

But it didn't shows the new control file path ,it shows only the old details only

Plz help me what can i do for creating new one

- Thanx.




Re: control file [message #241464 is a reply to message #241461] Tue, 29 May 2007 13:41 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
There could be spfile.make sure that your instance is running by pfile in which u made changes.


Re: control file [message #241489 is a reply to message #241464] Tue, 29 May 2007 15:28 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
we have use only pfile
Re: control file [message #241499 is a reply to message #241489] Tue, 29 May 2007 16:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure? Post "show parameter spfile".
Then are you sure you modified the correct pfile?

Regards
Michel
Re: control file [message #241501 is a reply to message #241499] Tue, 29 May 2007 16:06 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
just post the error when you trying to start oracle instance.
and also post the controlfiles parameter from PFILE.
Previous Topic: Gather Table Stats - Partition
Next Topic: Invalid Row ID
Goto Forum:
  


Current Time: Thu Sep 19 23:15:22 CDT 2024