Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

coruption after data migration

450591Aug 18 2005 — edited Aug 23 2005

hello, i have problem with data migration

i migrate data using third party software TDMF/Replicator. not oracle tool ( replicate from current disk to another disk)
the migration is ok, oracle can startup with out recovery, aplication ok. but the problem when we run backup using veritas backup, complaining about data file coruption.
so i want to know is oracle have command to check data file coruption?

best regards
freddy

error from veritas backup
***
Corrupt block relative dba: 0xbd806c8f (file 758, block 27791)
Fractured block found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0xbd806c8f
last change scn: 0x0003.55107f93 seq: 0x1 flg: 0x02
consistency value in tail: 0xb3110601
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=27791, file=/orabig18/GENEVA/cedat2_7.dbf. found same corrupt data
Wed Aug 17 02:23:44 2005
***
Corrupt block relative dba: 0xbc43f3d3 (file 753, block 259027)
Fractured block found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0xbc43f3d3
last change scn: 0x0002.d5e5888f seq: 0x1 flg: 0x02
consistency value in tail: 0x12960601
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=259027, file=/orabig18/GENEVA/cedat2_3.dbf. found same corrupt data
Wed Aug 17 02:37:11 2005

***
Corrupt block relative dba: 0xbf86d90e (file 766, block 448782)
Fractured block found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0xbf86d90e
last change scn: 0x0002.d74c1d89 seq: 0x1 flg: 0x00
consistency value in tail: 0xf6f40601
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=448782, file=/orabig18/GENEVA/cedat2_15.dbf. found same corrupt data
Wed Aug 17 02:40:35 2005

***
Corrupt block relative dba: 0xbe8c160f (file 762, block 792079)
Fractured block found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0xbe8c160f
last change scn: 0x0002.d3d40159 seq: 0x1 flg: 0x02
consistency value in tail: 0xe9bc0601
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=792079, file=/orabig18/GENEVA/cedat2_11.dbf. found same corrupt data
Wed Aug 17 02:56:50 2005

***
Corrupt block relative dba: 0xbd806c8f (file 758, block 27791)
Fractured block found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0xbd806c8f
last change scn: 0x0003.55107f93 seq: 0x1 flg: 0x02
consistency value in tail: 0xb3110601
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=27791, file=/orabig18/GENEVA/cedat2_7.dbf. found same corrupt data
Wed Aug 17 02:23:44 2005
***
Corrupt block relative dba: 0xbc43f3d3 (file 753, block 259027)
Fractured block found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0xbc43f3d3
last change scn: 0x0002.d5e5888f seq: 0x1 flg: 0x02
consistency value in tail: 0x12960601
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=259027, file=/orabig18/GENEVA/cedat2_3.dbf. found same corrupt data
Wed Aug 17 02:37:11 2005

***
Corrupt block relative dba: 0xbf86d90e (file 766, block 448782)
Fractured block found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0xbf86d90e
last change scn: 0x0002.d74c1d89 seq: 0x1 flg: 0x00
consistency value in tail: 0xf6f40601
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=448782, file=/orabig18/GENEVA/cedat2_15.dbf. found same corrupt data
Wed Aug 17 02:40:35 2005

***
Corrupt block relative dba: 0xbe8c160f (file 762, block 792079)
Fractured block found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0xbe8c160f
last change scn: 0x0002.d3d40159 seq: 0x1 flg: 0x02
consistency value in tail: 0xe9bc0601
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=792079, file=/orabig18/GENEVA/cedat2_11.dbf. found same corrupt data
Wed Aug 17 02:56:50 2005

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 20 2005

Added on Aug 18 2005

#general-database-discussions

14 comments

586 views