Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Editing the Control Files
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 Thu Apr 04 2002 - 11:00:17 CST