4 Replies Latest reply: Jan 30, 2013 10:58 AM by Mark D Powell RSS

    ORA-01103 - restoring database to new name.

    ChrisDugdale
      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?