hot backup 热备份中很重要的概念-- split block

最新推荐文章于 2022-07-03 15:36:27 发布

转载最新推荐文章于 2022-07-03 15:36:27 发布 · 124 阅读

本文探讨了当数据库写进程与操作系统备份同时进行时可能导致的数据块分裂现象，这种情况下产生的损坏块会对数据库恢复造成影响。文章还介绍了如何通过将表空间置于备份模式来避免这一问题，并说明了Oracle Recovery Manager是如何解决此问题的。

split block

See fractured block

fractured block

A type of media corruption that can occur when database writer is writing a block at the same time an operating system utility is reading the block for backup. The block that the operating system reads can be split, that is, the top of the block is written at one point in time while the bottom of the block is written at another point in time. If you restore a file containing a fractured block and Oracle reads the block, then the block is considered a corrupt block.

The potential for fractured blocks necessitates putting tablespaces in backup mode before user-managed online backups. A database in backup mode writes whole Oracle data blocks to the redo log, so that if a block is split during the backup, you can repair it by using redo. Recovery Manager does not experience this problem because the server process performing the backup or copy reads each block to determine whether it is split and re-reads the block until it gets a consistent version.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-84757/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-84757/