Document Type | Troubleshooting
Category | Patch/Upgrade
Applicable Product Version | 6FS06
Document Number | TPATS024
Issue
After performing a hot backup, when attempting to execute the end backup command on the undo tablespace, the query held WLOCK_DD_TS in RS mode while it was currently held in X mode, causing the begin/end backup DDL to remain in a waiting state indefinitely.
Cause
Although the undo tablespace was replaced, the tip file was not updated to reflect the change. As a result, the undo tablespace specified in the tip file, which is different from the currently set default undo tablespace, was used, causing the inability to perform the end backup.
Solutions
- Set the undo path in the tip file to be the same as the currently configured undo.
- Apply the patch to resolve the issue. (Patch applied: FS06_CS_186914a)
- This patch changes the begin/end backup DDL to hold wlock_dd_ts in RX mode.
CautionApply the patch through technical support provided by TmaxTibero.