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

Thread: Rollback segment offline

  1. #1
    Join Date
    Aug 2000
    Posts
    143

    Question

    What causes a rollback segment to go offline by itself?

  2. #2
    Join Date
    Dec 2000
    Posts
    15

    Arrow Rollback offline

    ALL rollback are in your INITPROD.ORA ?
    Sandro Lobo
    Oracle DBA
    www.geocities.com/sslobopt

  3. #3
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    I have never seen this happening all by itself.
    could you elabotate ?
    Is there any info in the alert log ?

    - Rajeev

  4. #4
    Join Date
    Nov 2000
    Posts
    71
    It's impossible that rollback segments go offline by themselves.
    May be what happen is this:
    You rollback segment are online.
    When shutdown your db and than startup it again you find them offline because in you init<sid>.ora you have not specified in the rollback_segment parameter what rollback segments are to put online when starting up the instance.
    Try to check it into your init<sid>.ora.
    Bye.

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