Rollback Segment is OFFLINE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rollback Segment is OFFLINE

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    hi,

    I have just now created a larger rollback segment to handle a bulk deletes.

    I issued this command


    SQL> create public rollback segment
    large_rbs tablespace RBS
    STORAGE
    (INITIAL 10M
    NEXT 5M
    MAXEXTENTS UNLIMITED)

    Rollback segment created.

    SQL> set transaction use rollback segment large_rbs;
    set transaction use rollback segment large_rbs
    *
    ERROR at line 1:
    ORA-01598: rollback segment 'LARGE_RBS' is not online

    HOW DO I BRING THIS LARGE_RBS ONLINE;
    badrinath


  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    alter rollback segement rb_name online;
    -
    Make sure you include this rbs in the init.ora, else it will be offline whenever you bounce the db.

    [Edited by Halo on 02-27-2001 at 01:45 PM]

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Ur problem is that the rollback segment u created is offline and should be brought online for use.In Oracle whenever u create a rollback segment it is offline by default.So u have to bring it online in order to use it.
    The following syntax will bring the rollback segment online.
    SQL>ALTER ROLLBACK SEGMENT <segment_name> ONLINE;

    U can place the name of the rollback segment in ur init.ora parameter file
    ROLLBACK_SEGMENTS=(rbs1,rbs2,rbs3) and restart the instance.
    If u do so then when ur database is started the named rollback segments will automaically be brought online,instead of bringing them online each one-by-one

    If u have any doubts,please be free to ask me at
    rohitsn@orasearch.net

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP


  4. #4
    Join Date
    Feb 2001
    Posts
    2

    rollback segment

    u have created the large rollback segment but u havn't made it online. issue the following command:-
    alter rollback segment <segment_name> online;
    issue the rollback or commit command
    then issue the statment
    set transaction use rollback segment<name>;

    if u have any more queries contact me
    all the best

    shirish
    [QUOTE][i]Originally posted by badrinathn [/i]
    [B]hi,

    I have just now created a larger rollback segment to handle a bulk deletes.

    I issued this command


    SQL> create public rollback segment
    large_rbs tablespace RBS
    STORAGE
    (INITIAL 10M
    NEXT 5M
    MAXEXTENTS UNLIMITED)

    Rollback segment created.

    SQL> set transaction use rollback segment large_rbs;
    set transaction use rollback segment large_rbs
    *
    ERROR at line 1:
    ORA-01598: rollback segment 'LARGE_RBS' is not online

    HOW DO I BRING THIS LARGE_RBS ONLINE;
    badrinath

    [/B][/QUOTE]

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