DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Restarting fast_start parallel rollback

  1. #1
    Join Date
    Jul 2001
    Posts
    108

    Restarting fast_start parallel rollback

    Hello,

    9.2.0.4.0 on HP-UX

    SMON: Restarting fast_start parallel rollback

    I shut a DB down badly by killing the DB service during a very large transaction. It's been up again for 2hrs but it's still recovering and nothing else will run with any reasonable speed. Lots of IO.

    Is there any way of bypassing/shortcutting/stopping the recovery process? I am happy to abandon all work done since the last committed transaction pre-abort.


    Also the UNDO tablespace is not releasing the space used by the uncommited blocks. How can I free-up the UNDO tablespace?

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    duplicate, closing.
    Jeff Hunter

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