Rollback segment needs recovery
Date: 1995/08/26
Message-ID: <41nmpp$rj9_at_vkhdsu01.hda.hydro.com>#1/1
I run an Oracle 7.0.16 database on a RS/6000 M570 (AIX 3.2.5).
I have the following problem:
After changing disks I restored a backup taken just before the disk
change.
When I try to start up the database I have to do "media recovery" on the
SYSTEM tablespace file. The rocover procedure looks like it works fine,
but when the database starts up one of the rollback segments is in a
"need recovery" status.
I can not log in from anything other than SQLDBA (sqlplus gives error
1578 in rollback segment r01).
I can not drop the rollback segment since it's not offline.
I can not drop the tablespace since it contains rollback segments.
I can not do recover on the tablespace, the system says it ok.
I can not bring the rollback segment online, since it needs recovery.
I can not use the system without fixing or droping this rollback segment.
What do I do?
Malvin Received on Sat Aug 26 1995 - 00:00:00 CEST