Thanks for the question, Meru.
Asked: March 10, 2017 - 6:47 am UTC
Last updated: March 10, 2017 - 8:14 am UTC
Version: Oracle 12.102
Viewed 1000+ times
You Asked
Dear TOM,
I have the database that doesn't have good enough backups and it went down. The database starts up to mount state, but does not open. I figured out which block is corrupted, however, I could not find what does that block belong to, rman validate command shows that it belongs to 'other'. Advise failure command states that the block corruption is media corruption and the only option to recover is to write to Oracle support. Is it somehow possible to repair that one broken block if I don't have the backups?
Thank you in advance!
The alert logs are showing the following error:
Thu Dec 08 06:56:39 2016
Hex dump of (file 1, block 32780) in trace file u01/oracle/diag/rdbms/sk/trace/sk_p004_2370.trc
Corrupt block relative dba: 0x0040800c (file 1, block 32780)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x0040800c
last change scn: 0x0000.01f814c9 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x12e40601
check value in block header: 0x3876
computed block checksum: 0x62d
Reading datafile 'u01/oracle/oradata/sk/system01.dbf' for corruption at rdba: 0x0040800c (file 1, block 32780)
Reread (file 1, block 32780) found same corrupt data (no logical check)
Best regards,
Meru
and Connor said...
You have a system tablespace corruption so I'd be enlisting the assistance of Support.
There are some special parameters that (sometimes) will allow you get your database open, or at least "sufficiently open" to let you export out as much data as possible.
But yeah...no backups = not good.
Is this answer out of date? If it is, please let us know via a Comment