Hello,
I've been restoring databases using a backup appliance (commvault). It has been working fairly well until now where I am experiencing an issue restoring 2 databases on the same instance that have the same value for SELECT NAME FROM V$DATABASE;
How this came to be is that the database name has been truncated due to the 8 character size limit. For example I have these 2 databases:
longdatabasename1
longdatabasename2
These will get truncated to longdata (8 characters) as show by SELECT NAME FROM V$DATABASE;
So when I restore the first database I get an error on the CREATE CONTROLFILE REUSE SET DATABASE longdatabasename1
ORA-01127: database name exceeds size limit of 8 characters
The work around has been to edit the file that executes this statement to CREATE CONTROLFILE REUSE SET DATABASE longdata and it works the control file restores and I'm able to open the database with resetlogs.
The issue I'm now having is when trying the same steps with longdatabasename2 I am getting the following error:
CREATE CONTROLFILE REUSE SET DATABASE longdata RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01158: database already mounted
I'm assuming it is looking at longdatabasename1 which has been brought online and not the one i'm currently connect to longdatabasename2 in nomount. Is there a workaround for this? Can I shutdown longdatabasename1 and try this again for longdatabasename2?