needs recovery status of rollback segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: needs recovery status of rollback segment

  1. #1
    Join Date
    Nov 2000
    Posts
    33
    One of my rollback segment status in dba_rollback_segs is
    'needs recovery'. My database is not in archive mode.

    alter rollback segment rb23 offline;
    alter rollback segment rb23 online;
    drop rollback segment rb23;
    all above written statement does not work

    Kindly tell me how can i solve this problem

    from Anuj Pathak

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Did you get an error when you made the rollback segment offline?
    If so, what was it?

  3. #3
    Join Date
    Nov 2000
    Posts
    33
    following message comes when we try to put this segment offline.
    ORA-01598 rollback segment rb23 is not online

    though the staus of this rollback segment is 'needs recovery'

  4. #4
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    hi guys...
    now, the rollback segment have 3 states: online, offline, needs recovery.
    Ok, so the 3'd state meens that the rollback segment 'X' had a transaction active in it (active= non commited). Now
    you have 3 possibilities:
    1. try to release the transaction active (it remains in the datadictionary), by relesing in the DBA_2PC_PENDING view or
    PENDING_TRANS$ table.
    2. if nr.1 don't work you will have in the data dictionary for ever the segment 'X' with the nees recovery status until you recreate the database.
    3. (at your own risc):
    IF nr.1 DON'T WORK.
    update manualy undo$ table change the values status$ to online (numeric). Run catalog.sql & catproc.sql , then try keep offline by command and finaly drop.



  5. #5
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    If you can afford to reboot the db :

    reboot the db without using the rbs23, or use the parameter _corrupted_rollback_segs

    drop & create rbs23

    Hope this helps
    Gert

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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