Hi ,
OS Version : Solaris SPrc 64 bit
Database Version : 11.2.0.2
We were cloing the database using the cold backup. Somehow we missed a few datafiles and started getting Ora-600 error.
Steps followed were :
1.transfer the cold backup.
2. create the control file using create controlfile command
after executing this command the database was not opening (Ora-600 error), so added the missing datafiles from the coldbackup and tried creating the controlfile again. At this moment we got the below error :
SQL> @control.sql
CREATE CONTROLFILE SET DATABASE "newdb" RESETLOGS
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name db in file header does not match given name of newdb
ORA-01110: data file 795: '/p6/oracle/newdbdata/applsysx29.dbf'
We tried renaming the database db to newdb.
Is there anyway we can reset the header with the database name ?
Can something be done to open this database ?
Regards
kk