Block corruptions with Oracle DB

[Former Member]

Hi Experts..

We found 10+ block corruptions in our development Oracle DB. 

Validated the database using RMAN & DBVerify tool. both results were similar.

13 block corruptions with 9 user data files & 7 block corruptions with SYSAUX tablespace alone.

issues face:

1. From T-code se11 when tried to open a Z table (Ztest), it is navigating to a class builder (t-code se24) with class name (Ztest)

2. When trying to create Maintenance View in T-code SE11 it is giving us error which says “ SQL error in the database when accessing a table“. 

We don't have RMAN backup ,but BR tools - complete offline backup in place.

My query is :

1. Is it possible to recover the database without zero downtime

2. How to perform the block media recovery using br tools.

Is there any workaround here, to get rid these corrupted blocks.

Thanks in advance.

Ravi.T

[former_member207186 · Accepted solution]

Hi,

Please proceed as per the SAP Notes 23345 - "Consistency check of ORACLE database" and 365481 - "Block corruptions" to handle corruption issue. Please alo check the SAP KBA 1559652 - "How to deal with block corruptions on Oracle" for more details.

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

[Former Member · Accepted solution]

Hi Biborka Greta Toth,

Thanks for the SAP Notes.

None of the suggested techniques worked . we don't have complete backup and archived log files.

regards,

Ravi.T

[stefan_koehler]

Hi Ravi,

>> We don't have RMAN backup ,but BR tools - complete offline backup in place.

BR*Tools do not exclude RMAN explicitly. You can use BR*Tools with or without RMAN.

However if you still have a valid offline backup (i assume you mean image copies in that manner) without block corruptions, you can register these image copies in/with RMAN and perform a block recovery (with the additional needed archive logs) without any downtime at all.

Regards

Stefan

[Former Member]

Hi Stefan Koehler,

We are integrating  the BRTOOLS with RMAN.

regards,

Ravi.T

[Former Member]

i would suggest to check the note 365481 - Block corruptions

there will be downtime to recover the database from the backup.

[Former Member]

Thanks Sunil . But we don't have valid backup to recover the corrupted blocks...

regards,

Ravi.T

[Former Member]

We don't have RMAN backup ,but BR tools - complete offline backup in place.

but you mentioned earlier that you ahve BR tools backup?

and now you are saying you dont have valid backup.

Refer Stefan response.

[Former Member]

Yes, We had the BR  tools complete backup, taken 1 month back. We don't want to restore the DB with this backup. We are loosing critical client data, which is stored after taking this backup. Does BR TOOLS support block media recovery to perform ?? .

regards,

Ravi.T

[Former Member]

as mentioned by Stefan, you have to integrate the RMAN for the block recovery. I hope you have all the archive logs that are needed for the recovery. You wont be able to recover if you dont have the archive logs.

Is this prod or test system? Why you have only monthly backup and not daily? You need to immediately look into the backup solution.