Re: Editing the Control Files

I agree with Sean but would have some concerns as to how this situation occurred.
If, as you say, the control files are pointing at the *wrong* datafiles you should first
verify that you are using the correct init.ora to pick up the appropriate control files.

Regards,
Anthony Hogan
ahogan-nospam-_at_iespana.es

Sean M wrote:
>
> Arash wrote:
> >
> > Hi!
> > what can I do if:
> >
> > - when I want to start my oracle server says:
> > ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
> > ORA-01110: data file 1:'D:\ORATEST\SYSTEM01.DBF'
> >
> > - my problem is, that my *.DBF's are located in another directory.
> >
> > but I cant edit my CTL-files, to tell this to the server...
> > ...or can I?
> >
> > and if, how?
>
> Two choices: 1) rename the datafiles while the database is mounted, but
> not open, using 'alter database rename datafile <old_name> to
> <new_name>' (check my syntax on that - going from memory). 2) Recreate
> your controlfile with the new filenames/locations (i.e. in a nomount
> stage, issue 'create controlfile blah blah blah'). The former is
> probably your best bet - less chance to screw something up.
>
> Regards,
> Sean
Received on Fri Apr 05 2002 - 05:44:53 CST