| susk |
Posted: Jan 10, 2008 01:08:41 AM |
Total Post: 22
Joined: Jan, 2008
|
hi friends i am sushil new to dba pool needs ur help.
yesterday while multiplexing the control file with the spfile
syntax as follows
SQL> ALTER SYSTEM SET control files =
'$HOME/ORADATA/u01/ctrl01.ctl',
'$HOME/ORADATA/u02/ctrl02.ctl' SCOPE=SPFILE;
instead of .ctl i typed .ctr . And now database is not mounting it showing message like unable to identify control files , plz check in alert log file . I tried to recover control file with the nomount stage but it says keywords missing needs ur help .
thnx in advance |
|
|
 Babu |
| Posted: Jan 10, 2008 04:09:29 AM |  |
|
Total Post: 94
Joined: Oct, 2007
|
I want to know why multipost?
Check here: http://www.dbapool.com/forumthread/topic_9382.html
Babu
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 10, 2008 09:32:02 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
follow below procedure
1. shutdown database
2. edit pfile and remove wrong extension controlfile
3. remove physical from file system.
4. create new spfile from pfile
5. startup database
now if you want to multiplex your controlfile then apply below procedure.
1. shutdown database
2. copy existing controlfile from other location(multiplex location)
3. edit pfile and add other location in CONTROL_FILES parameter
4. recreate spfile from edited pfile
5. startup database
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
