If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

recreate new control file.

Hi,

Iam using oracle 9i and win2000 server in my PC. I have taken backup control file to trace and then deleted all my control files,then edited control file (removed reuse in create control file command) and saved in f: drive,then i did following process..

I have typed it here with spelling mistake.but actually the file is taken from alter ..backup trace command and i have removed commented lines and (reuse)in that file and remaining are correct.
Why it shows this error?

Last edited by ams-jamali; 03-22-2007 at 06:21 AM.
Reason: to increase details

I have copied the above file in sql prompt and added "SET" and executed it prompts me to change Noresetlogs to "RESETLOGS" , after changing it executed and results as 'Control file Created';
then i opened my database and everything is fine.

then deleted all control files & tried to repeate the same process in 'Command mode'
c:\sqlplus
connect /as sysdba
connected to the ideal instance.
SQL>@f:\control
sp2-0042 : unknown command " DATAFILE " rest of line ignored
then the same error repeats.(which i posted in first thread.)

The same content in f:\control is used previously in SQL (copy&Paste).

Why does it run smoothly if i use sql prompt(using copy & paste) and not in CMD mode.

Last edited by ams-jamali; 03-23-2007 at 03:06 AM.
Reason: to increase details

when you specify the SET option,
you are instructing oracle to create the database with a new database name, so the redo logs will always be RESET.
Either create the database with no SET option and open the db with NORESETLOGS option, or create a new controlfile with new DBname with SET option and open the database with RESETLOGS option.