ORA-01092: ORACLE instance terminated. Disconnection forced

[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

[stecal]

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

[mathur_78]

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.

[mathur_78]

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.