URGENT: ORA-01092: ORACLE instance terminated. Disconnection forced - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 34

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

  1. #21
    Join Date
    Jan 2002
    Posts
    96
    And to answer your previous question the Tablespace name is RBS
    checked 1 of my logs now....

  2. #22
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  3. #23
    Join Date
    Jan 2002
    Posts
    96
    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

  4. #24
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  5. #25
    Join Date
    Jan 2002
    Posts
    96
    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.

  6. #26
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  7. #27
    Join Date
    Jan 2002
    Posts
    96
    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

  8. #28
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  9. #29
    Join Date
    Jan 2002
    Posts
    96
    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.

  10. #30
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width