This content has been marked as final. Show 4 replies
01161, 00000, "database name %s in file header does not match given name of %s" // *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.
Thanks for the suggestion. I have dropped and re-created the redo log groups. I am going to try the same step for create controlfile. Let me see if that fixes it.
-- Dropping and Recreating the redolog group fixed the issue
Control file created.
SQL> ALTER DATABASE OPEN;
Edited by: user8932632 on Apr 11, 2013 8:42 AM