Controlfile creation from Backup controlfile with couple of missing datafiles created successfully.
I used the script generated by Backup controlfile to trace.
I created a new controlfile. While editing the script I accidently deleted the datafiles related to the UNDO tablespace.
Controlfile created successfully.
Recovered database.
But while trying to open the database I get
ORA-30046: Undo tablespace APPS_UNDOTS2 not found in controlfile.
d in controlfile.
Sat Jul 31 15:54:32 2010
Error 30046 happened during db open, shutting down database
USER: terminating instance due to error 30046
Instance terminated by USER, pid = 15631
ORA-1092 signalled during: ALTER DATABASE OPEN RESETLOGS...
Is there any way I can add undo tablespace before I open database. I am not able to recreate the controlfile since the system already has the new SID and the UNDO datafiles have the old SID.