-
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
-----------------------------------------------------------
-
-
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??
-
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
-
Thanks for your reply
I have taken offline backup yesterday night.
So, i have restore SYSTEM tablespace's datafile and recover it??
-
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!
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|