Re: Corruption with active duplication

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 8 Nov 2018 22:08:51 -0500
Message-ID: <20bbfadd-8671-b863-9305-543429487dd9_at_gmail.com>



No, unfortunately, the database is active. The dbverify isn't very good on active data files.

Regards

On 11/8/18 10:03 PM, Ruel, Chris wrote:
>
> Try running a dbverify command on the corrupt datafile?
>
> _____________________________________________________________________
>
> Chris Ruel * Distributed Database Services * Lincoln Financial Group
>
> cruel_at_lfg.com <mailto:cruel_at_lfg.com>* Desk:317.759.2172 * Cell
> 317.523.8482
>
> *From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Mladen Gogala
> *Sent:* Thursday, November 08, 2018 9:17 PM
> *To:* oracle-l <oracle-l_at_freelists.org>
> *Subject:* Corruption with active duplication
>
> ***This email is from an external source. Only open links and
> attachments from a Trusted Sender.***
>
> 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
>
> Notice of Confidentiality: **This E-mail and any of its attachments
> may contain
> Lincoln National Corporation proprietary information, which is
> privileged, confidential,
> or subject to copyright belonging to the Lincoln National Corporation
> family of
> companies. This E-mail is intended solely for the use of the
> individual or entity to
> which it is addressed. If you are not the intended recipient of this
> E-mail, you are
> hereby notified that any dissemination, distribution, copying, or
> action taken in
> relation to the contents of and attachments to this E-mail is strictly
> prohibited
> and may be unlawful. If you have received this E-mail in error, please
> notify the
> sender immediately and permanently delete the original and any copy of
> this E-mail
> and any printout. Thank You.**
>

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


--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 09 2018 - 04:08:51 CET

Original text of this message