Re: Editing the Control Files

On 4 Apr 2002 08:39:38 -0800, arashamiri_at_hotmail.com (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?
>
>please help...
>arash.

go into svrmgrl

connect / as sysdba
startup mount
alter database rename file '....' to '....'; -- please check out the exact syntax in your sql reference manual alter database backup controlfile to trace; alter database open;
-- done
exit

Never even think of editing the controlfiles, and definitely not before reading any Oracle server administrators manual.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Apr 04 2002 - 11:05:32 CST