- 新しい順
- 投票が多い順
- コメントが多い順
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.
関連するコンテンツ
- 質問済み 6年前
- AWS公式更新しました 2年前