Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creation of control file in Oracle 10g

492688Jan 3 2007 — edited Jan 3 2007

Hi,
I had taken the backup of control file(backup control file to trace) and edited it to change the new location of the datafile.But when i try to create the Control file(Startup nomount,@cntrl.sql) it fails with the following error

ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01276: Cannot add file
/oracle/DBS/redolog/DBS/controlfile/o1_mf_2s4ho2n8_.ctl. File has an Oracle
Managed Files file name.

how can i recreate it?

Regards,
Cherry

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2007

Added on Jan 3 2007

#general-database-discussions

3 comments

194 views