-
And to answer your previous question the Tablespace name is RBS
checked 1 of my logs now....
-
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?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
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!
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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.
-
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?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
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
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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.
-
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?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|