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!

problem creating a control file from trace

Guess2Aug 5 2009 — edited Aug 5 2009

I made a backup of my production database and I want to do a non-rman recovery (this project does not use rman so I don't have that at my disposal and no I am not allowed to change it).

I have copied my datafiles to the appropriate location
I made a backup of the control file to trace and I changed my datafile locations in the controlfile to the new location
I have my sid set
i did a start up nomount.

I am trying to create my controlfile with the edited trace control file

CREATE CONTROLFILE DATABASE "mynewdb" resetlogs
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name myOLDDB in file header does not match given name of myNEWDB
ORA-01110: data file 1: '/oracle/mynewdb/system01.dbf'

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2009

Added on Aug 5 2009

#general-database-discussions

6 comments

531 views