ROLLBACK SEGMENT VERSION 7.3

Advertisement
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!
We don't have any backup and the archivlog was not activated.
HELP is there any way to solve this problem?????
Thank for your help

Advertisement

Replay

Oracle XML Team wrote:
: Jerome Sigua (guest) wrote:
: : My company has version 7.3.4 and my group is thinking of
using
: : XML for some data transfers between us and our vendors. From
: : what I could see from this web site, it looks like we would
: need
: : to move to ver 8i in order to do so. Is there any way of
: : leveraging ver 7 to do XML? I'm sure we'll move up to ver 8
: : sometime in the future but I don't know if we will within our
: : timeline(next 3-4 months) for the next phase of the project
: I'm
: : working on.
: : TIA
: : Jerome Sigua
: As long as you have the appropriate JDBC 1.1 drivers for 7.3.4
: you should be able to use the XML SQL Utility to extract data
in
: XML.
: Oracle XML Team
: http://technet.oracle.com
: Oracle Technology Network
For JDBC drivers, please take a look at
http://technet.oracle.com/tech/java/sqlj_jdbc/
Take a look at : Oracle 7 JDBC OCI and JDBC Thin Drivers
Oracle Technology Network
http://technet.oracle.com
null

View 3 Replies

Tags:

  1. migo stock type
  2. inbound delivery gr
  3. what hv to do after stolen kaptop
  4. descargar iBooks 3.1.1 .ipa
  5. PEXR 2002
  6. elitepad 900 shutsdown
  7. I2S6
  8. UFE3
  9. usefule1m
  10. cardumj
Copyrights 2019 Fcffair BigData Resource, All rights reserved