11 Replies Latest reply on Feb 11, 2013 3:28 PM by Munish

    rollback issue


      We have 8.1.7 oracle EE database running.
      I got a message saying that RBS could not be extended , I looked into it and found out that the disk was out of space.
      I created another RBS02 on another disk and shutdown the DB and restarted it.

      Now there are errors in the alert.log that says RBS20 cannot be extended "ORA-1562" ERRORS.

      I tried to take RBS20 offline, it says statement processed but it never takes it offline. It will not let me drop rollback segment. Now when I try to go into an application I get ORA-01562 ERRORS.

      I tried to see if there was anything in these rollback segments and there is nothing. It is empty.

      How can I remove them or fix them.