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

Thread: Any way to prevent or bypass recovery mode?

  1. 04-02-2004, 02:30 PM #1
    Nikee
    Nikee is offline Member
    Join Date
    Jul 2001
    Posts
    108

    Any way to prevent or bypass recovery mode?

    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
    Last edited by Nikee; 04-02-2004 at 02:33 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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