Re: Fractured block found during backup
- From: "Maris Elsins" <elmaris@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Sun, 16 Nov 2008 16:28:15 +0200
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:
