URGENT: ORA-01092: ORACLE instance terminated. Disconnection forced

[charlton]

And to answer your previous question the Tablespace name is RBS
checked 1 of my logs now....

[julian]

Originally posted by charlton
And to answer your previous question the Tablespace name is RBS
checked 1 of my logs now....

Could you take all RBSs online?

Could you drop the ones that you could not?

[charlton]

Julian, this is what I get when I try to put the online.
It says it's online and when i try to take it offline it says it is not online.

SVRMGR> alter ROLLBACK SEGMENT rbs02 ONLINE;
alter ROLLBACK SEGMENT rbs02 ONLINE
*
ORA-01636: rollback segment 'RBS02' is already online

SVRMGR> alter ROLLBACK SEGMENT rbs02 OFFLINE;
alter ROLLBACK SEGMENT rbs02 OFFLINE
*
ORA-01598: rollback segment 'RBS02' is not online

[julian]

Originally posted by charlton
Julian, this is what I get when I try to put the online.
It says it's online and when i try to take it offline it says it is not online.

SVRMGR> alter ROLLBACK SEGMENT rbs02 ONLINE;
alter ROLLBACK SEGMENT rbs02 ONLINE
*
ORA-01636: rollback segment 'RBS02' is already online

SVRMGR> alter ROLLBACK SEGMENT rbs02 OFFLINE;
alter ROLLBACK SEGMENT rbs02 OFFLINE
*
ORA-01598: rollback segment 'RBS02' is not online

That's good. Are they all online? All RBSs?

If so, no worries!

[charlton]

Just check the previous error I sent to you. The 1st staement says , it is ONLINE
and the 2nd statement says that it is NOT online.
It is confused.

[julian]

Originally posted by charlton
Just check the previous error I sent to you. The 1st staement says , it is ONLINE
and the 2nd statement says that it is NOT online.
It is confused.

I just noticed that. Bugger ...

Are you able to drop it?

[charlton]

No , I was not able to drop the RBS. :(

SVRMGR> DROP ROLLBACK SEGMENT rbs01;
DROP ROLLBACK SEGMENT rbs01
*
ORA-01545: rollback segment 'RBS01' specified not available

[julian]

Originally posted by charlton
No , I was not able to drop the RBS. :(

SVRMGR> DROP ROLLBACK SEGMENT rbs01;
DROP ROLLBACK SEGMENT rbs01
*
ORA-01545: rollback segment 'RBS01' specified not available

Try firs this:

Off-line and bring back on-line all the user tablespaces.

Once this is done, the problem rollback segments status will change to on-line.

Then do shutdown immediate on the database and startup.

You will then be able to drop this rollback segment.

If this does not work you may try this but using the undocumented parameters is not that good:

insert the following line in the INIT.ORA:

_corrupted_rollback_segments=(RBS01,RBS02)

You may add all other ones.

1. bounce tha database
2. drop the RBSs

[charlton]

Do I have to bring down and up all the other user tablespaces?
This user has +/- 100 tablespaces, it is a Oracle Financials Database.
And the _corrupted_rollback_segments=(RBS01,RBS02)
I read in metalink that this could be dangerous......
I am not starting to feel well.

[julian]

Originally posted by charlton
Do I have to bring down and up all the other user tablespaces?
This user has +/- 100 tablespaces, it is a Oracle Financials Database.
And the _corrupted_rollback_segments=(RBS01,RBS02)
I read in metalink that this could be dangerous......
I am not starting to feel well.

Yes, all tablespaces. Don't start doing that then...

And yes, setting _corrupted_rollback_segments=(RBS01,RBS02) might be dangerous because you might have there a non-rollbacked data dictionary transaction. Don't do that either.

Bad situation...

Open iTar with Metalink.

What is the status of the rollback segments?