ORA-01578 in Oracle RDS SE/2 GovCloud West 3/1/2022

Question

In one instance in our RDS Oracle SE/2 in GovCloud West region, we have transactions that are receiving ORA-01578 error as shown:

ORA-01578: ORACLE data block corrupted (file # 9, block # 149082)
ORA-06512: at line 108
ORA-01110: data file 9: '/rdsdbdata/db/ORCL_A/datafile/o1_mf_tp_pmdb__htvs55dx_.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option

java.sql.SQLException: ORA-01578: ORACLE data block corrupted (file # 9, block # 149082)
ORA-06512: at line 108
ORA-01110: data file 9: '/rdsdbdata/db/ORCL_A/datafile/o1_mf_tp_pmdb__htvs55dx_.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
ORA-06512: at line 67

Since this is a managed RDS instance, we are unclear about how best to proceed with resolving this issue, particularly if this indicates an underlying hardware issue on the RDS instance. Can anyone please advise next steps?

Thanks for your time.

Answer

The approach to fix/address this issue depends on the type of segment that block is holding i.e. if its a temporary table, application table, index.

Meaning, if this block turns out to be holding temporary table, then you can skip that block after following this - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.Database.html#Appendix.Oracle.CommonDBATasks.SkippingCorruptBlocks

If its an index, you can rebuild it or use dbms packages to repair it.

If its an application table, then do a PITR using the backups, skip the corrupted block(s) and import the table from restored RDS.

I would say, validate the database using RMAN to see if there are any more corruptions ( https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.RMAN.html#Appendix.Oracle.CommonDBATasks.ValidateDB )and reach out to support for more help.

ORA-01578 in Oracle RDS SE/2 GovCloud West 3/1/2022

관련 콘텐츠