When I issue an alter table move statement and afterwards an alter index
rebuild for the primary key on this
table I got an error duplicate rows found. This primary key is unique.
The database has just been migrated for test purposes. In production we are
still on oracle 7.3.4.

I found the offending rows by validating into an exceptions table. When I
compared these with
production it didn't exist there. I turned out that these records were
updated during the time of copying the
database. This database is on EMC Symmetrix and the copy has been made
through a bcv. Before starting the
bcv all tablespaces are put into backup mode and then a split is done
through EMC software to get a copy.
About 20 seconds before the update in the table the tablespace has been put
into backup mode and 40 seconds
after the update the tablespaces are brought back to normal.

Besides a hotbackup to tape we use this bcv regularly to copy databases so
this behaviour is starting to worry me.
Any idea what might be going wrong here?



Production : HP-UX 10.20, Oracle, Symmetrix 3330
Test: HP-UX 11.11, Oracle

Please see the official ORACLE-L FAQ: http://www.orafaq.net
Author: Jeroen van Sluisdam
INET: jeroen.van.sluisdam_at_vrijuit.nl

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
postedNov 26, '03 at 8:59a
activeNov 26, '03 at 8:59a

1 user in discussion

Jeroen van Sluisdam: 1 post



site design / logo © 2022 Grokbase