Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can't delete rollback segment.

Can't delete rollback segment.

From: James Williams <techsup_at_mindspring.com>
Date: Mon, 17 Sep 2001 23:06:26 GMT
Message-ID: <3ba680e7.30471296@nntp.mindspring.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US