ORA-01103 - restoring database to new name.
Hi, I'm attempting to restore a database from a cold backup. It's not RMAN, it's just an OS level backup.
The technical details are
Windows 2003
Oracle 11.1
What's happened is- I upgraded our development database from 11.1 to 11.2 and we discovered a bug, so i want restore the database in the 11.1 instance. The 11.2 version of the database is running, people are using it, we have a workaround so i can't delete that database. What I want to do is create a new instance in 11.1 restore all the datafiles/control files/etc, setup the parameter file and start up the database, obviously I had to use a different name.
However the problem I'm seeing is
ORA-01103: database name 'ALPHA' in control file is not 'ALPHADB'. ALPHADB is the new database. I thought to do the backup to trace and recreate the control files, but I can't mount the database. I have performed 'backup to trace' on the OLD database.
Any advice please?