Rollback segment - OFFLINE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Rollback segment - OFFLINE

  1. #1
    Join Date
    Nov 2000
    Posts
    9

    Angry

    any one please help
    Some rollback Segments status are OFFLINE when shutdown and restart the database.
    thanks in advance

  2. #2
    Join Date
    Feb 2001
    Posts
    123
    Add an entry (or modify the existing one) in the init_SID.ora file in the following format

    rollback_segments = (r01, r02, r03, r04, r05, r06, r07,r08,r09,r10)

    (Where r01, r02 etc. are the names of your rollback segments)

    HTH

    David.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Which version? 8.1.7 automatically brings public rollback segments online. You have to specify the private RBS in your init.ora.
    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."

  4. #4
    Join Date
    Nov 2000
    Posts
    9
    Thanks for your reply,
    I do not want to make them Private Rollback Segments as put them in the initSID.ora. Moreover that i want know what is the real problem in this case.

    The Config is as follows
    Hardware - Compaq prolaint 400 P-III.
    RAM - 256 MB
    HDD - 12 GB (3x4GB RAID)
    SWAP - 800 MB
    OS - SCO UnixWare 7 release 7.1.1 - 50 user
    RDBMS - Oracle 8i release 8.1.5.
    Config. - Multi Master Replication - Master Definition Site Server
    Database Size - around 2.5 GB
    Rollback Segments - Ext=2MB, Min=2, Max=Unlimited
    Could you please help.
    Thanking you



  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    If you don't have parallel server configuration (obviously you don't) then there is no difference between public and private rollback segments.

    When your instance starts it checks if you have ROLLBACK_SEGMENTS parameter set. If you have it, it will open all the specified RB segments. But if you don't have this parameter set, then the instance will calculate the number of RB segments it needs to put online based on two other init parameters, based on the following formula:

    number_of_RB_to_open = TRANSCTIONS/TRANSACTIONS_PER_ROLLBACK_SEGMENT

    So for example if this formula results in number 5, but you have 10 rollback segments in the database, it will put only 5 segments online (plus the system RB), while other 5 will remain offline. If you want the instance to put all your RB segments online at startup, you either have to specify them in your ROLLBACK_SEGMENTS parameter (this has nothing to do with privite/public RB definition) or to modify your TRANSACTIONS and/or TRANSACTIONS_PER_ROLLBACK_SEGMENT parameters.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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