Quote Originally Posted by gandolf989 View Post
I suppose you could restore it as the original name and then do an alter database backup controlfile to trace; and then rename and move everything to the new proper place and recreate the control file to point to the right database name and location for all the data files and online redo.
Alternatively you may use the DBNEWID utility like following :

Code:
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP MOUNT
CMD> nid TARGET=/  DBNAME=NEWSID
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP