Restoring Data on the Standby Node

standby_page_repair

Parameter description: Specifies whether to enable automatic page repair during replay on the standby node. In the current version, only the CRC check failure type can be repaired. Bad blocks in hash bucket tables, heap table FSM files, and VM files cannot be repaired. This is a SIGHUP parameter. Set it based on instructions provided in Table 1.

Value range: Boolean

• on indicates that the standby node automatically detects and repairs pages during replay.
• off indicates that the standby node does not automatically detect and repair pages during replay.

Default value: on

If a large number of physical bad blocks are continuously injected to the standby node, the replay performance of the standby node is affected, and Xlogs may be stacked on the standby node.