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

Thread: delete rollback segment

  1. #1
    Join Date
    Jul 2001
    Location
    Tokyo, Japan
    Posts
    4

    Question

    Hi!

    I use oracle8i for linux

    I delete rollback segment's file by mistake.
    (with rm command)

    and I couldn't open DB.

    That's DB message.

    ORACLE instance started.
    Total System Global Area 4754704 bytes
    Fixed Size 48400 bytes
    Variable Size 4222976 bytes
    Database Buffers 409600 bytes
    Redo Buffers 73728 bytes
    Database mounted.
    ORA-01545: rollback segment 'R01' specified not available
    ORA-01109: database not open

    And I edited init.ora

    # rollback_segments = (r01,r02,r03,r04)

    and tried to startup DB.
    but error was occured.

    ORACLE instance started.
    Total System Global Area 4754704 bytes
    Fixed Size 48400 bytes
    Variable Size 4222976 bytes
    Database Buffers 409600 bytes
    Redo Buffers 73728 bytes
    Database mounted.
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00376: file 2 cannot be read at this time
    ORA-01110: data file 2: '/u02/oradata/COMMONDB/rbs01.dbf'

    How can I open DB?



  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Backup your database first before do this, since itīs RBS that is missing this can be tricky if you dont have a backup


    startup mount

    alter database datafile '/u02/oradata/COMMONDB/rbs01.dbf' offline drop

    alter database open

    drop tablespace rbs

    then rcreate your rbs tablespace

    IF, when you deleted the rbs tablespace datafile there were active transactions going then this process would be different and itīs tricky

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Nothing to worry since it is RB segment datafile only.
    Do the following..

    1. Shutdown the database.
    2. edit the init.ora file and comment the parameter rollbak_segments.
    3. go to server manager.
    4. connect internal
    5. startup mount
    6. alter database datafile '/u02/oradata/COMMONDB/rbs01.dbf' offline drop;
    7. alter database open;
    8. create the rollback tablespace with new datafile.
    9. bring back the rollback segmetns online or drop and create the rollback segments.
    10. put back the entries for the created rollback segments in init.ora.

    Good luck...
    Sanjay


  4. #4
    Join Date
    Jul 2001
    Location
    Tokyo, Japan
    Posts
    4

    Thanks for replying

    Thanks Pando and SANJAY_G for replying.

    I did following your comment.
    But I couldn't open database.

    So I try to write init.ora following statement,

    _corrupted_rollback_segments=(r01,r02,r03,r04)

    and I can open database.

    I recreate RBS, and I can recover database.

    Thanks.

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