Datablock corruption

[former_member199632]

Hi,

In the DEV server it is getting this message  (Oracle version 10.2.0.4.0)

ORA-01578: ORACLE data block corrupted (file # 23, block #...)

Due to this, some dumps are popup.

> ORA-01578: ORACLE data block corrupted (file # 23, block #> 302146)#ORA-01110: data file 23:
> '/oracle/DEV/sapdata4/sr3_20/sr3.data20'
Run-time error "DBIF_RSQL_SQL_ERROR" occurred

But still there is no disturbance for the operation of the server. Server works okay.

pl, let me know how to rectify this issue!

in the alert_SID.log file it shows --> Hex dump of (file 23, block 302146) in trace file /oracle/DEV/saptrace/usertrace/dev_ora_14807.trc

When checking thru    SQL> SELECT * FROM V$DATABASE_BLOCK_CORRUPTION; , it shows as NO ROWS SELECTED

Is it possible to check from brtools and to recover those corrupted blocks from brtools -> check and verify -> verification of database blocks?

regards,

Zerandib

[Brindavan_M]

Hi,

Check the below methods

1) The target database must run in ARCHIVE-LOG mode

2) RMAN can use only archived redo logs for the recovery.

3) RMAN cannot use level 1 incremental backups.

SQL>SELECT instance_name,  host_name,  version, status, archiver FROM v$instance;

To recover specific data blocks:

SELECT NAME, VALUE FROM   V$DIAG_INFO;

RECOVER   DATAFILE 8 BLOCK 13   DATAFILE 2 BLOCK 19;

Recovering All Blocks in V$DATABASE_BLOCK_CORRUPTION

SQL> SELECT * FROM V$DATABASE_BLOCK_CORRUPTION;

Start RMAN and connect to the target database.

RMAN> RECOVER CORRUPTION LIST;

Thanks,

[JamesZ]

V$DATABASE_BLOCK_CORRUPTION will be filled after performing rman consistency check.

As Bíborka mentioned, you should perform complete database consistency according to SAP note 23345.

If the corruption is index, then you can solve the corruption via rebuild index.

Please note under almost cases, the corruption was caused by hardware failure, you have to verify your hardware as soon as possible.

[former_member207186]

Hi,

To handle corruption issue, you can proceed as per SAP Notes 23345 - "Consistency check of ORACLE database" and 365481 - "Block corruptions". For more information, please also refer to SAP KBA 1559652 - "How to deal with block corruptions on Oracle".

Also for a possible way to fix block corruption with Zero Downtime, please refer to point 12 of SAP Note 540463- "FAQ: Consistency Checks + Block Corruptions".

For restore&recovery please check SAP Note 605062 - "FAQ: Restore and recovery".

Regards,
Bíborka