Issue Information
| Issue Number | 701532a |
| Issue | After dropping a tablespace, recreating it with the same name and filename, and performing Flashback Database to a point before the drop, the database is restored to that point. If resetlogs is then performed and the tablespace is read, a TBR-1060 error occurs. |
| Cause | The Tablespace ID and Datafile ID can be reused after a DROP operation. During CF-DD correction, datafiles are compared using only the file ID, causing a datafile created later to be incorrectly recognized as the datafile at the target point in time. As a result, the system fails to recognize that the datafile at the target point in time does not exist. |
| Solutions | The CF-DD correction has been changed to also compare the datafile create TSN. This is controlled by a hidden parameter to account for datafiles created with older binaries whose create TSN may differ. |
| Occurrence Date | 26.10.07. |
| Version Requiring the Patch | 6FS07PS 7FS02PS |
Patch Information
| Patch Name | FS02PS_701532a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Enhanced to compare the datafile create TSN during CF-DD checks |
| Available Release Date | 26.10.21. |
| Compatibility | • TAC rolling patch: Available • TSC rolling patch: Available • Backup data compatibility: Available • Protocol compatibility: Available • Data format compatibility: Available |
| AP Impact | • Plan change: No • Result value change: No • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameter | - |
| Workaround | Use tbhdreditor to forcibly match the create TSN with DD |