![]() ![]() No subsequent read of the block is successful until the block is recovered. Usually, the database marks a block as media corrupt and then writes it to disk when the corruption is first encountered. In such cases, data file media recovery is the best solution. Block media recovery is not intended for cases where the extent of data loss or corruption is unknown and the entire data file requires recovery. Block-level data loss usually results from intermittent, random I/O errors that do not cause widespread data loss, and memory corruptions that are written to disk. ![]() With block media recovery, only the blocks actually being recovered are unavailable during the recovery.īlock media recovery is most useful for physical corruption problems that involve a small, well-known number of blocks. ![]() The entire file is unavailable until media recovery completes. You must apply all redo generated for the data file after the backup was created. Without block media recovery, if even a single block is corrupt, then you must take the data file offline and restore a backup of the data file. Lowers the mean time to recover (MTTR) because only blocks needing recovery are restored and recoveredĮnables affected data files to remain online during recovery Use block media recovery to recover one or more corrupt data blocks within a data file.īlock media recovery provides the following advantages over data file media recovery: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |