Re: Fractured block found during backup
- From: "sanjay bauskar" <sanjaybauskar@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Mon, 17 Nov 2008 11:52:05 +0530
HI ,
Try out following things to cross check block corruptions.
1) Run DBVERIFY on Datafile file (47)
2) try to locate the object type (Index or table in corrupted block number).
if it is index rebuild it. if it is not index then
3) last option would be take the datafile from recent good backup and then
restore it with required archive logs and recover it.
Regards
Sanjay
On Sun, Nov 16, 2008 at 7:58 PM, Maris Elsins <elmaris@xxxxxxxxx> wrote:
> Hi,
>
> As you have your previous RMAN backups, you should be able to try
> blockrecovery:
>
> blockrecover datafile 47 block 1393523;
>
> best regards,
> Maris
> http://appsdbalife.wordpress.com
>
>
>
> On Sun, Nov 16, 2008 at 9:36 AM, khabeer khayyam <khabeer1983@xxxxxxxxx>wrote:
>
>> Hello!
>>
>> The backup policy we've in our organization is:
>>
>> RMAN - 0300 hrs
>>
>> Export - 0500 hrs
>>
>> When I logged in today n checked the Alert logfile it shows:
>>
>> Corrupt block relative dba: 0x0bd54373 (file 47, block 1393523)
>> Fractured block found during backing up datafile
>> Data in bad block -
>> type: 6 format: 2 rdba: 0x0bd54373
>> last change scn: 0x0002.cf262152 seq: 0x1 flg: 0x04
>> consistency value in tail: 0x26e70606
>> check value in block header: 0x7058, computed block checksum: 0x3ce2
>> spare1: 0x0, spare2: 0x0, spare3: 0x0
>> ***
>> Reread of blocknum=1393523, file=/u1/ibs/data/datausr04.dbf. found valid
>> data
>> Hex dump of Absolute File 47, Block 1393863 in trace file
>> /u5/ibs/dump/udump/mcibs54_ora_22273.trc
>>
>> Please help me in resolving this
>>
>> Thanks & Regards,
>>
>> Khayyam
>>
>> ------------------------------
>> Connect with friends all over the world. Get Yahoo! India
>> Messenger.<http://in.rd.yahoo.com/tagline_messenger_1/*http://in.messenger.yahoo.com/?wm=n/>
>>
>
>
>
Other related posts:
