Re: Tracking down NOLOGGING objects

From: Andrey.Kriushin <>
Date: Tue, 02 Sep 2008 13:27:22 +0400
Message-ID: <>

Hi Mark,

Perfect point. Thanks!

Assuming that the one, not very familiar with the current operations on the database and having no other input to identify NOLOGGING, still tries to figure it out... And has a standby (as many of us do)...

  • Andrey

Mark Brinsmead wrote:
> But it /does/ track them at the /block/ level! If you have a physical
> standby, at least. Blocks affected by non-logged operations will
> manifest there as "corrupt" blocks. Something like an RMAN "BACKUP
> VALIDATE" will be sufficient to find them; they will be reported both
> in the RMAN output and a dictionary view (V$BLOCK_CORRUPTION maybe).

Received on Tue Sep 02 2008 - 04:27:22 CDT

Original text of this message