URGENT: ORA-01092: ORACLE instance terminated. Disconnection forced
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 34

Thread: URGENT: ORA-01092: ORACLE instance terminated. Disconnection forced

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    96

    Unhappy URGENT: ORA-01092: ORACLE instance terminated. Disconnection forced

    HI there Fellow DBS's

    This is really urgent.

    What I did: I moved my RBS file to another mount point. When I started the move I realised my Database was still up (online).
    When the file was done moving, I moved it back to the original directory. I then did a shutdown immediate and it took too long, so i did a shutdown abort. When I tried doing a startup I got the following error:

    SVRMGR> startup
    ORACLE instance started.
    Total System Global Area 802885792 bytes
    Fixed Size 73888 bytes
    Variable Size 433106944 bytes
    Database Buffers 368640000 bytes
    Redo Buffers 1064960 bytes
    Database mounted.
    ORA-01092: ORACLE instance terminated. Disconnection forced

    This is my production database. I need to get it back up ASAP.

    The only solution I have now is to do a restore from a hot backup and recover to a point in time..... Is there perhaps a easier solution?

    Thanks
    Charlton

  2. #2
    Join Date
    Jan 2002
    Posts
    96
    In my log file it shows the following error:


    ORA-01545: rollback segment 'RBS01' specified not available

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Comment out the RBSs from the init.ora file and startup the instance.

    When the database is open recreate the rollback segments.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Jan 2002
    Posts
    96
    How do you recreate the RBS? I never needed to this before so you help will be greatly appreciated.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charlton
    How do you recreate the RBS? I never needed to this before so you help will be greatly appreciated.
    First, after commenting out the RBSs in init.ora, are you able to open the database?

    Which version?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Jan 2002
    Posts
    96
    Yes it did open after I commented out the entire RBS line in the init.ora file.

    The version I am running is 8i.

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charlton
    Yes it did open after I commented out the entire RBS line in the init.ora file.

    The version I am running is 8i.
    OK, so far so good. Now carefully:

    1. Take all rollback segments offline.
    2. Take the tablespace offline.
    3. Drop the RBS tablespace.

    If this succeeds we will recreate the RBS tablespace.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Here is how to recreate the RBSs. After you have dropped all old ones:

    1.

    SQL> CREATE ROLLBACK SEGMENT rbs_dummy
    TABLESPACE system
    STORAGE (INITIAL 10k NEXT 10k MINEXTENTS 2);

    Rollback segment created.

    2.

    SQL> ALTER ROLLBACK SEGMENT rbs_dummy ONLINE;

    Rollback segment altered.

    3.

    SQL> CREATE ROLLBACK SEGMENT rbs1
    TABLESPACE ts_name_rbs
    STORAGE (...);

    Rollback segment created.

    SQL> ALTER ROLLBACK SEGMENT rbs1 ONLINE;

    Rollback segment altered.

    4.

    Like in 3, create the rest.

    5.

    SQL> DROP ROLLBACK SEGMENT rbs_dummy;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  9. #9
    Join Date
    Jan 2002
    Posts
    96
    Julian, I am a bit scared so just confirm if this is correct:

    ALTER DATABASE DATAFILE 'rbsxx.dbf' ONLINE;

    Which I will do for all 7 rbs datafiles?

    alter tablespace RBS offline;

    DROP ROLLBACK SEGMENT rbs01.dbf

    Is this correct?

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Please, if you cannot drop a RBS, query first dba_rollback_segements and check that its status is a 'NEEDS RECOVERY' or 'ONLINE'.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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