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!

ORA-01161: database name

user151917Oct 3 2012 — edited Oct 3 2012

DB 10.2.0.4
AIX 5.2

I am trying to make clone.Even I made clone, the database was up but when I saw in the alert log file it was giving continue below error(1) and the size of alert log file was getting increase so I decided to restore missed file and I restored and trying to create control file but this time it is giving below second(2) error.

1:
ORA-00376: file 35 cannot be read at this time
ORA-01111: name for data file 35 is unknown - rename to correct file
ORA-01110: data file 35: '/vol01/oracle/product/10g/dbs/MISSING00035'

2:
SQL> @clone.ctl
CREATE CONTROLFILE SET DATABASE "dev" RESETLOGS
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name prod in file header does not match given name of dev
ORA-01110: data file 35: '/vol01/oracle/index08.dbf'

Suggest me.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2012

Added on Oct 3 2012

#general-database-discussions

3 comments

1,196 views