| susk |
Posted: Jan 10, 2008 01:11:15 AM |
Total Post: 7
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 |
|
|
 dd |
| Posted: Jan 11, 2008 12:19:51 AM |  |
|
Total Post: 14
Joined: Jan, 2007
|
Since SP file is a binary file maintained by server so we cannot edit if modified it will be useless.
If you have binary back up of control file (backup control file to TRACE) then you can recreate it in NOMOUNT stage.
we can start the instance using pfile mentioning during instance start up
Startup pfile=.............
Then create sp file from pfile
Please somebody correct it, if I am wrong.
|
|
|
|
|
| MOH_DBA |
| Posted: Jan 12, 2008 11:39:32 AM | |
|
Total Post: 133
Joined: Nov, 2007
|
creating pfile from spfile and vise versa can be done even if the database is shutdown. so you can log to (sqlplus /nolog) and then create the pfile from spfile, correct the parameters you want and then create spfile from the pfile and start the database.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
