Skip to main content

Search

Welcome to Tibero GTS!

Recovery Failure Due to TBR-1027 Error When Performing Media Recovery

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.
Caution
Apply the patch through technical support provided by Tmax Tibero.
Note
As 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.
 
 
 

Related to