ORA-01161: database name string in file header does not
match given name of string

Answers were Sorted based on User's Feedback



ORA-01161: database name string in file header does not match given name of string..

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

ORA-01161: database name string in file header does not match given name of string..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-10586: Test recovery had to corrupt 1 data block in order to proceed

1 Answers  


RMAN-08531: channel string: proxy copy string is string in media management catalog

1 Answers  


KUP-04040: file string in string not found

1 Answers  


ORA-29268: HTTP client error string

1 Answers  


TNS-01005: trace OFF | USER | ADMIN | SUPPORT [<listener_name>] : set tracing to the specified level

1 Answers  






DRG-50946: Invalid unary operator for theme index

1 Answers  


ORA-29301: wrong DBMS_PITR package function/procedure order

1 Answers  


ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed

1 Answers  


ORA-19671: media management software returned invalid proxy handle

1 Answers  


ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents

1 Answers  


ORA-25149: Columns of UROWID type may not be indexed

1 Answers  


ORA-12432: LBAC error: string

1 Answers  


Categories