ORA-01161: database name string in file header does not
match given name of string
Answers were Sorted based on User's Feedback
Answer / scavenger
CREATE CONTROLFILE SET DATABASE "TARGET" RESETLOGS NOARCHIVELOG
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name SOURCE in file header does not
match given name of TARGET
ORA-01110: data file 19:
'/apps/oracledata/TARGET/osys3/stat0001.dbf'
=> no solution, the datafile is corrupt
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / guest
Cause: The database name given at the command line does not
match the database name found in the file header.
Action: Chance are good that the database name specified at
the command line is incorrect. Resolve the descepency, and
resubmit the command. If you are attempting to change the
database name, be sure to use the SET DATABASE option.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
PCC-00118: Use of host variable initialization not supported by ANSI SQL
ORA-22602: pickler TDS handle [string] is not well-formed
RMAN-08133: channel string: the autobackup does not contain a standby controlfile.
RMAN-08031: released channel: string
ORA-28561: unable to set date format on non-Oracle system
RMAN-08060: unable to find archive log
ORA-26690: datatype not supported at non-Oracle system
ORA-16024: parameter string cannot be parsed
TNS-00203: Unable to start tracing in intlsnr
ORA-23346: primary key or object ID is undefined for table or materialized view string
DRG-11810: Partial Update OK
ORA-23412: master table's primary key columns have changed