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

Thread: rollback segs

  1. #1
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Running 8.1.6 on AIX:

    I'm a little confused! When trying to open my database I get the message: rollback segment RBS01 doesnt exist.
    I now cant get the database open so I cant take the rollback segment offline or drop it.

    I can view v$rollstat and get the following results:

    USN EXTENTS RSSIZE WRITES XACTS GETS WAITS
    ---------- ---------- ---------- ---------- ---------- ---------- ----------
    OPTSIZE HWMSIZE SHRINKS WRAPS EXTENDS AVESHRINK AVEACTIVE
    ---------- ---------- ---------- ---------- ---------- ---------- ----------
    STATUS CUREXT CURBLK
    --------------- ---------- ----------
    0 59 4825088 0 0 3 0
    4825088 0 0 0 0 0
    ONLINE 4294967295 4294967295

    From this it seemd the current extent and block are 4.2 GB where as the rollback segement size is 4MB ???????

    I guess my question is can anyone shed any light on what is going on?

    Regards,

    Fraze

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Delete RBS01 from init.ora, startup the db. Try to bring RBS01 online, manually or just drop it.

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