logical corruption
From: <Mayen.Shah_at_lazard.com>
Date: Fri, 23 May 2008 13:24:25 -0400
Message-ID: <OF401F1E7F.975E9ADF-ON85257452.005E36FD-85257452.005F9EB1@lazard.com>
Date: Fri, 23 May 2008 13:24:25 -0400
Message-ID: <OF401F1E7F.975E9ADF-ON85257452.005E36FD-85257452.005F9EB1@lazard.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 23 2008 - 12:24:25 CDT