Document Type | Troubleshooting
Category | Backup/Recovery
Applicable Product Version | 6FS07
Document Number | TBATS011
Issue
Note
Affected Version: Tibero6 FS07 CS2005
The data files remained in a hot backup state, requiring media recovery when starting the database.
However, the checkpoint was stuck at a past point in time, so the end backup was not performed properly. When recovery was attempted under this condition, a TBR-1027 error occurred due to a TSN mismatch between the data files and log files.
Cause
Previously, for performance reasons, there was logic to skip full checkpoints (Full CKPT). This was designed to improve performance so that even when reusing log files, a Full CKPT would not occur every time.
However, this caused the end backup not to be performed correctly, resulting in TSN mismatches during recovery and causing the error.
Solutions
Apply the patch to resolve the issue. (Patch Applied: 326173)
This patch improves the process to ensure that Full CKPT is performed without omission.
CautionApply the patch through technical support provided by Tmax Tibero.
NoteAs a workaround, you can set the _USE_CLOSEST_ARCHIVE_FOR_RECOVERY=Y parameter to perform recovery using only the currently available archive logs.However, archive logs containing the checkpoint TSN based on online must exist for successful recovery.