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

Thread: rollback segment

Hybrid View

  1. 05-23-2003, 09:33 AM #1
    shailendra
    shailendra is offline Senior Member
    Join Date
    Sep 2000
    Posts
    305

    rollback segment

    Hi

    Very funny problem
    I have five rollback segment rbs01...rbs05. I am using oracle 9i i also have one tablespace for these rollback segments.
    Well the problem is that when I exeute this command

    alter rollback segment rbs01 offline;

    I am getting this error
    "ORA-01636: rollback segment 'RBS01' is already online"

    when I execute this command
    alter rollback segment rbs01 online;

    I am getting this error
    ORA-01636: rollback segment 'RBS01' is already online

    Even I am not able to drop tablespaces also.

    Any idea why it is happening?

    Shailendra
    Reply With Quote Reply With Quote
  2. 05-23-2003, 10:06 AM #2
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    What is the condition of the rollback tablespace? Try taking it offline for recovery. Something is not right here.
    Reply With Quote Reply With Quote
  3. 05-23-2003, 10:25 AM #3
    patel_dil
    patel_dil is offline Senior Member
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Any active transactions on this rollback segment? Check status column in DBA_ROLLBACK_SEGS Table.
    -- Dilip
    Reply With Quote Reply With Quote
  4. 05-23-2003, 10:27 AM #4
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Why not use Automatic Undo Management when on 9i ?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  5. 05-23-2003, 10:40 AM #5
    shailendra
    shailendra is offline Senior Member
    Join Date
    Sep 2000
    Posts
    305
    Yeah there are six records in DBA_ROLLBACK_SEGS

    but I am not able to drop the segment well I know I can use undo segments but I was just trying to use rollback segment.

    any other information required??

    Shailendra
    Reply With Quote Reply With Quote
  6. 05-23-2003, 10:54 AM #6
    patel_dil
    patel_dil is offline Senior Member
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Course there would be as many records as number of rollback segments in DBA_ROLLBACK_SEGS. What does the status column say? PENDING OFFLINE or something?
    -- Dilip
    Reply With Quote Reply With Quote
  7. 05-25-2003, 11:27 AM #7
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    have you read the metalink note? some suggestions in there
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
  8. 05-26-2003, 01:45 AM #8
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: rollback segment

    Originally posted by shailendra
    Hi

    Very funny problem
    I have five rollback segment rbs01...rbs05. I am using oracle 9i i also have one tablespace for these rollback segments.
    Well the problem is that when I exeute this command

    alter rollback segment rbs01 offline;

    I am getting this error
    "ORA-01636: rollback segment 'RBS01' is already online"

    when I execute this command
    alter rollback segment rbs01 online;

    I am getting this error
    ORA-01636: rollback segment 'RBS01' is already online

    Even I am not able to drop tablespaces also.

    Any idea why it is happening?

    Shailendra
    Oracle i strying to punish you for not using UNDO tablespace in 9i :-)

    Why do you temper with the RBSs? Why should you drop it? There are things that should not be done on the fly.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    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