ORA-01534 rollback segment 'R1' does not exist

Advertisement
November 30

Greetings
HELP!! We are using oracle 8.0.5 ...
The database will not open because it says the system
rollback segment does not exist.
The database mounts but won't open. from the file system checks,
the dbf file that contains the system rollback segment appears to
be fine.
Is there anyway to recreate the sys rb seg ? any way to correct
whatever is causing it to think it doesn't exist?
or if it is just hosed, is there any way to retrieve the data in
the data dbf files through another oracle installation or another
oracle database??
Thanks for any input!
null

Advertisement

Replay

Check your init<SID>.ora file. Check the parameter
rollback_segments. If its value contains R01, delete R01. After
that, save the file and startup again.
Robert Xu
Laurie (guest) wrote:
: Greetings
: HELP!! We are using oracle 8.0.5 ...
: The database will not open because it says the system
: rollback segment does not exist.
: The database mounts but won't open. from the file system
checks,
: the dbf file that contains the system rollback segment appears
to
: be fine.
: Is there anyway to recreate the sys rb seg ? any way to
correct
: whatever is causing it to think it doesn't exist?
: or if it is just hosed, is there any way to retrieve the data
in
: the data dbf files through another oracle installation or
another
: oracle database??
: Thanks for any input!
null

View 2 Replies

Tags:

  1. software to stop pops safari 5.1.10
  2. java deconfig for old jav r12
  3. difference in fgi0 and ke30
  4. backup-spsite when to use sqlsnapshot
  5. how to set program run dat in rffoedi1
  6. modifing a ke30 report
  7. download BSP application
  8. I2S6
  9. whitecca
  10. 65S0
Copyrights 2019 Fcffair BigData Resource, All rights reserved