ORA-01092: ORACLE instance terminated. Disconnection forced

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

What does this have to do with feedback and questions regarding the forums?

Dear Raj

do these steps.

1.)Specify the undotablespace in init.ora.

2.)startup DB in mount stage.

3.)query the status of tablespace (recover)

4.)alter database datafile ‘D:\RAJ\UNDOTBS01.DBF’ offline;

5.)recover database datafile ‘D:\RAJ\UNDOTBS01.DBF’

6.)alter database datafile ‘D:\RAJ\UNDOTBS01.DBF’ online

7.)alter database open;

I Think these steps are helpful for you.

Quote:

---

Originally Posted by kanthbethi

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

---

Dear Raj

do these steps.

1.)Specify the undotablespace in init.ora.

2.)startup DB in mount stage.

3.)query the status of tablespace (recover)

4.)alter database datafile ‘D:\RAJ\UNDOTBS01.DBF’ offline;

5.)recover database datafile ‘D:\RAJ\UNDOTBS01.DBF’

6.)alter database datafile ‘D:\RAJ\UNDOTBS01.DBF’ online

7.)alter database open;

I Think these steps are helpful for you.