Rollback segment corruption on oracle 7.3

November 30

We have an oracle 7.3 database on solaris(sparc) 2.6.
In the midddle of the transactions, the following error message occured:
ORA 1578 Data block corrupted(file #2, block#8274)
ORA-1110 Datafile 2:'/user1/oradb/rbstbl.dbf'
(this datafile corresponds to the rollback segment table space).
Action Taken:
1. Tried to make the rollback segments offline, but out of 11, 2 rollback segments could not be taken offline. The status for these 2 was 'pending offline'.
2. Made the table space and datafile offline.
3. Created new rollback segments with new datafile and rollback segments, duly commenting the same in init.ora.
4. The status for these 2 rollback segments has now changed to 'needs recovery'. This status is preventing us from taking any further action.
We would like to drop the old table space.
We need you kind help in getting out of this loop!
Pls. mail your reply to [email protected]



Sorry, the character set scanner only supports 8.0.6 and above. Can you first migrate your US7ACII database to 9.2, and run the scanner before changing database character set to WE8ISO8859P15? Also you can read this paper
to understand why you may have invalid data in your US7ASCII database and the best way to migrate it. I am also wondering about your choice of P15 versus P1 and WIN1252? If you need further information you can contact me directly at [email protected]

View 3 Replies


  1. LinkedIn messages who dents them
  2. time capsule 500g default ip address
  3. inurl: sign.html
  4. changiing dtc folder nwds 7.0
  5. OB76
  6. smallestdky
  7. S4VP
  8. ibooks 3.1 ipa download
  9. grainoh6
  10. music52k
Copyrights 2019 Fcffair BigData Resource, All rights reserved