Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't delete rollback segment.
"Bonjour" from Paris,
ora-600 3020 :
The error signals that recovery is stuck due to conflicting information in the datafile/redolog. Generally a change is missing in the redo. This prohibits the recovery process from completing successfully. It may be necessary for you to recover from an offline backup or to a point in time prior to the error.
I suggest you recover again your database your database ( restore again
all the files) and cancel
before the
1_6094_ADP1.arc
archive (recover until cancel).
You will lost all the transactions after this time but i think you will be able to open your database safety.
"Au revoir" from Paris.
Hieraklion
James Williams wrote:
>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 Tue Sep 18 2001 - 03:40:28 CDT