Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

An invalid checksum is detected on a redo log group member. What happens to archiving when this error is detected?

April 26, 2017archiving checksum detected Error group happens invalid log redo

0

10 Posted

An invalid checksum is detected on a redo log group member. What happens to archiving when this error is detected?

1 Answer

0

10 Posted

An attempt is made to archive another redo log member. If the initialization parameter LOG_BLOCK_CHECKSUM is set to TRUE, each block in a redo log file is given a checksum before a write is performed. A checksum is used to detect block corruption before a block is read. If a corrupt block is detected in a member of a redo log group, the server will attempt to read from another member of the group. If the entire group is invalid, the group cannot be archived.