URGENT - Data Block corruption

Printable View

10-14-2004, 04:39 AM
bhattnirav

URGENT - Data Block corruption

When i try to take backup using RMAN (incremental level 0) it was terminated and showing block corruption in system datafile.

I have check the dba_extents and the object is OBJ$

and below message indicated in alert log file

----------------------------------------------------------------
Corrupt block relative dba: 0x00403492 (file 1, block 13458)
Bad check value found during backing up datafile
Data in bad block -
type: 6 format: 2 rdba: 0x00403492
last change scn: 0x0000.0001a9d5 seq: 0x1 flg: 0x06
consistency value in tail: 0xa9d50601
check value in block header: 0x80a7, computed block checksum: 0x8656
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=13458, file=D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF. found same corrupt data

-----------------------------------------------------------
10-14-2004, 05:22 AM
davey23uk

raise a TAR
10-14-2004, 06:10 AM
bhattnirav

Thanks

But i do not have oracle support so i cannot raise TAR.

Presently my database is running. i have not shutdown the DB after getting this error. If i bounce the DB then what will happen? will it opened??
10-14-2004, 06:48 AM
davey23uk

restore from backup and roll forward then.

And seeing as thought you don't have support, it cant be very important so you could just delete it and re-create it
10-14-2004, 07:10 AM
bhattnirav

Thanks for your reply

I have taken offline backup yesterday night.

So, i have restore SYSTEM tablespace's datafile and recover it??
10-15-2004, 03:51 AM
OracleDoc

Quote:

Originally posted by davey23uk
restore from backup and roll forward then.

And seeing as thought you don't have support, it cant be very important so you could just delete it and re-create it

Now that's funny! good call Davey lol!