Re: logical corruption
Date: Fri, 23 May 2008 13:36:33 -0400
Message-ID: <OFFAA5BA7E.A3497426-ON85257452.00607819-85257452.0060BAD9@lazard.com>
I forgot to mention one thing.
There is no error/message in alert.log
I do not want to set maxcorrupt. I would like to leave it as default 0. My question was how to check current setting maxcorrupt? Any way that is not my concern at this time.
Thanks
Mayen
"Bradd Piontek" <piontekdd_at_gmail.com>
May 23 2008 01:31 PM
To
Mayen Shah/ITS/Lazard_at_Lazard NYC
cc
oracle-l_at_freelists.org, oracle-l-bounce_at_freelists.org
Subject
Re: logical corruption
Touching on the RMAN piece. Check out the Reference guide and look at the 'SET MAXCORRUPT" setting.
<snip>
Tests data and index blocks that pass physical corruption checks for
logical
corruption, for example, corruption of a row piece or index entry. If RMAN
finds logical corruption, then it logs the block in the alert.log and
server
session trace file.
Provided the sum of physical and logical corruptions detected for a file
remain below its MAXCORRUPT setting, the RMAN command completes and
Oracle populates V$DATABASE_BLOCK_CORRUPTION with corrupt block
ranges. If MAXCORRUPT is exceeded, then the command terminates without
populating the views.
Note: For COPY and BACKUP, the MAXCORRUPT setting represents the total
number of physical and logical corruptions permitted on a file.
On Fri, May 23, 2008 at 12:24 PM, <Mayen.Shah_at_lazard.com> wrote:
Hi List,
env: Oracle 9.2.0.8 Solaris 9
v$database_block_corruption reported logical corruption for three
datafiles.
I ran "backup check logical validate database" which completed without
any error.
dbv also reported corruption for all three datafiles.
I did not set maxcorrupt in RMAN so I assume it is set to default 0 (Is
there any way to check this setting?)
Last night RMAN full backup completed without any error.
When I checked, corrupted blocks does not belong to any segment in two
tablespaces to which these three files belong. (I used dbs_extents to map
corrupted block to segment)
This is production database so I am concerned.
- Why "rman backup check logical validate database" does not report any error?
- What are my options? I assume these blocks are marked as soft corrupt. Is there any way to repair/reclaim them?
- Am I correct to assume that if I do not do any thing these blocks will not be used ever and will not cause any issue in future?
Your valuable guidance is greatly appreciated.
Thank you.
Mayen
-- Bradd Piontek Twitter: http://www.twitter.com/piontekdd Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd Last.fm: http://www.last.fm/user/piontekdd/ -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 23 2008 - 12:36:33 CDT