Re: ORA-01161 weirdness trying to recreate controlfile

From: GS <>
Date: Tue, 26 Feb 2008 22:56:44 GMT
Message-ID: <MO0xj.41020$FO1.18295@edtnps82>

GS wrote:
> database is running on windows 2003
> I have done this lots of times, copy latest hot backup over from prod
> machine, startup mount, re create controlfile with 'set database
> "newname" resetlogs noarchivelog' clause.
> After control file is created recover the database using backup
> controlfile until cancel and apply archives if need be and open with
> resetlogs.
> Only this time, for reasons I can't figure out, I keep getting
> ORA-01161: database name NEWNAME in file header does not match given
> name of OLDNAME
> I am stumped, can't see any typos, or any other reason why it is not
> letting me rename the database ?
> Am I missing something real simple here?
> tia

yup I was :-(

in my haste (they were in a rush for this) I missed one file in the copy   and it was using the test dbs original file..

yes my face is red.. Received on Tue Feb 26 2008 - 16:56:44 CST

Original text of this message