I created a DB with 1 undo TS and later added another one and took the first one offline. And when I tried to bring it back online it started to give me following errors—
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: ‘D:\RAJ\UNDOTBS01.DBF’

Then I restarted the DB and got the following error—
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

So I decide to shut down the DB and change the initraj.ora parameter
UNDO_TABLESPACE=undo2 (which is the name of the second undo TS). And now when I start the DB I get the same errors.

What can I do to get my DB back? I don’t have any backup at all. I would be grateful if you can send me a solution asap.

Kind regards,

raj