DBAsupport.com Forums - Powered by vBulletin
Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 34

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

  1. #11
    Join Date
    Jan 2002
    Posts
    96
    I get the following error:

    SVRMGR> ALTER DATABASE DATAFILE 'rbs01.dbf' offline;
    ALTER DATABASE DATAFILE 'rbs01.dbf' offline
    *
    ORA-01516: nonexistent log file, datafile or tempfile 'rbs01.dbf'

  2. #12
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charlton
    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?
    This is not very nice stuff what we are doing.

    If there is an active transaction in a rollback segment and that rollback segment is removed from the database without the transaction being able to undo the changes made to the database (e.g. rollback), then those changes will be assumed to be committed. This can lead to inconsistencies in application data and/or the data dictionary. There is no help that can be provided to determine what those changes were. While inconsistencies in application data may have an effect on a customers application (e.g. loss of data, loss of access to data), inconsistencies in the data dicationary can cause the database to hang and/or crash at some later point in time and require a restore at that time.

    In the case of a lost rollback segment datafile, there is no way Oracle can guarantee that a data dictionary transaction was not active in the rollback segment as there is no way to view that information.

    The proper way in this situation would be to open an iTar with Metalink.

    If I was next to you, may be together we could fix it but that is difficult.

    Try to take the RBSs offline first:

    alter ROLLBACK SEGMENT rbs01 offline;
    alter ROLLBACK SEGMENT rbs02 offline;
    ..
    alter ROLLBACK SEGMENT rbs07 offline;

    If this succeeds, then we are almost OK.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #13
    Join Date
    Jan 2002
    Posts
    96
    Do you have a MSN or AOL loggin? Would you be able to use it if you do?

  4. #14
    Join Date
    Jan 2002
    Posts
    96
    SVRMGR> alter ROLLBACK SEGMENT rbs01 offline;
    alter ROLLBACK SEGMENT rbs01 offline
    *
    ORA-01598: rollback segment 'RBS01' is not online
    SVRMGR> alter ROLLBACK SEGMENT rbs02 OFFLINE;

  5. #15
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charlton
    I get the following error:

    SVRMGR> ALTER DATABASE DATAFILE 'rbs01.dbf' offline;
    ALTER DATABASE DATAFILE 'rbs01.dbf' offline
    *
    ORA-01516: nonexistent log file, datafile or tempfile 'rbs01.dbf'
    That's OK, because you obviously have given a wrong name of the file.

    It cannot be only rbs01.dbf. There is some directory before this.

    I have to go to watch an Woody Allen moovie soon, so call me if you want. I will send you my phone number if you write me an email to ocp_9i@yahoo.com
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  6. #16
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charlton
    SVRMGR> alter ROLLBACK SEGMENT rbs01 offline;
    alter ROLLBACK SEGMENT rbs01 offline
    *
    ORA-01598: rollback segment 'RBS01' is not online
    SVRMGR> alter ROLLBACK SEGMENT rbs02 OFFLINE;
    That's OK, then lets:

    DROP tablespace RBS including contents and datafiles;

    Is the name RBS?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  7. #17
    Join Date
    Jan 2002
    Posts
    96
    Sorry, Julian....
    I am in South Africa and I can't call internationally.
    It's 8:30 PM in the evening. Do you think I should just do a restore then? I really don't want to cause I know it takes 9 hours to do a restore.

  8. #18
    Join Date
    Jan 2002
    Posts
    96
    How do I check the name?

    I must be a pain in the @ss, hey!
    Sorry..

  9. #19
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charlton
    Sorry, Julian....
    I am in South Africa and I can't call internationally.
    It's 8:30 PM in the evening. Do you think I should just do a restore then? I really don't want to cause I know it takes 9 hours to do a restore.
    It should be 9:30 in South Africa :-) Try to take all RBSs online, if not possible open an iTar with Oracle Metalink.

    Let me know if you are able to online all RBSs. Try to drop the ones that you cannot take online.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  10. #20
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charlton
    How do I check the name?

    I must be a pain in the @ss, hey!
    Sorry..
    Select tablespace_name from dba_tablespaces;

    Take some other DBA with you. Don't do that stuff alone! I wouldn't :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    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