Corruption with active duplication

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 8 Nov 2018 21:16:42 -0500
Message-ID: <0ebce676-13c4-da12-7429-571c19a036d0_at_gmail.com>



Hi!

I am doing an active duplication of one test database to another one, for another group of developers. Here is what I am getting:

consistency value in tail: 0x00000001
  check value in block header: 0xb601
  computed block checksum: 0x0
Reading datafile '/U02/oradata/test2a/data21.dbf' for corruption at rdba: 0x11000001 (file 68, block 1)
Reread (file 68, block 1) found same corrupt data (no logical check) Hex dump of (file 69, block 1) in trace file /app01/oracle/diag/rdbms/test2a/test2/trace/test2_ora_25016.trc Corrupt block relative dba: 0x11400001 (file 69, block 1)

It probably means that the source database is corrupt, yet there is nothing in the alert log.  I will do backup validate logical, but this will take some time, since it's a database over 2TB. Does anyone have any idea how to establish whether the source DB is corrupt faster than using backup validate?

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 09 2018 - 03:16:42 CET

Original text of this message