DBAsupport.com Forums - Powered by vBulletin
Page 4 of 4 FirstFirst ... 234
Results 31 to 34 of 34

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

  1. #31
    Join Date
    Jan 2002
    Posts
    96
    SVRMGR> SELECT STATUS FROM DBA_ROLLBACK_SEGS
    2> WHERE SEGMENT_NAME = 'rbs01';
    STATUS
    ----------------
    0 rows selected.

  2. #32
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Check Note:28812.1.

    It might solve the problem.

    P.S.: IMHO you should not have run that ABORT statement
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #33
    Join Date
    Jan 2002
    Posts
    96
    I've read the the doc on Metalink. I think I am just going to restore all the database files from my backup tape, which is going to take forever. Hope and pray that the database comes back up.
    Alter database using backup controlfile until cancel;
    And see what happens?
    What do you think?

  4. #34
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charlton
    I've read the the doc on Metalink. I think I am just going to restore all the database files from my backup tape, which is going to take forever. Hope and pray that the database comes back up.
    Alter database using backup controlfile until cancel;
    And see what happens?
    What do you think?
    That's one way to go ahead. I would have set event = "10015 trace name context forever, level 10" in order to see what object Oracle is trying to apply the undo to, i.e, why it needs the RBS(s). Then droping the object(s) will help reuse the RBS(s) because the undo will be released. But it depends on what objects we are taling about.
    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