Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can't delete rollback segment.
ER DATABASE RECOVER tablespace rbstsxx
Mon Sep 17 15:36:12 2001
ORA-959 signalled during: ALTER DATABASE RECOVER tablespace rbstsxx
..
Mon Sep 17 15:36:12 2001
ALTER DATABASE RECOVER CANCEL
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL...
Mon Sep 17 15:36:34 2001
ALTER DATABASE RECOVER tablespace rbtsxx
Mon Sep 17 15:36:34 2001
Media Recovery Tablespace: RBTSXX
Media Recovery Start
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER tablespace rbtsxx ...
Mon Sep 17 15:36:48 2001
ALTER DATABASE RECOVER CONTINUE DEFAULT
Mon Sep 17 15:36:48 2001
Media Recovery Log /u01/app/oracle/admin/ADP1/arch/1_6094_ADP1.arc
Mon Sep 17 15:36:49 2001
Errors in file /u01/app/oracle/admin/ADP1/udump/adp1_ora_23917.trc:
ORA-00600: internal error code, arguments: [3020], [604053338], [1],
[6094],
[6]
Media Recovery failed with error 600
ORA-283 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Mon Sep 17 15:36:52 2001
ALTER DATABASE RECOVER CANCEL
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL...
Mon Sep 17 15:38:25 2001
alter database datafile '/u31/oradata/ADP1/rbtsxx.dbf' offline
Mon Sep 17 15:38:25 2001
Completed: alter database datafile '/u31/oradata/ADP1/rbtsxx.
Mon Sep 17 15:38:32 2001
alter database open
Mon Sep 17 15:38:35 2001
I had to take the rollback offline. I can't access the drop the rollback. I get the below. Trying to figure out how to get rid of this guy the best way.
SMON: about to recover undo segment 22
SMON: mark undo segment 22 as needs recovery
Received on Mon Sep 17 2001 - 18:06:26 CDT