15.00 - 2809 Invalid recovery sequence detected - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

2809 Invalid recovery sequence detected

Explanation:

An illegal sequence of recovery actions has been detected. This could be a cluster Restore of a fallback table that was not preceded by a dictionary restore or a specific-AMP restore operation during a Fast Load or MLoad.

Generated By:

AMP Software.

For Whom:

End User.

Notes:

All cluster restores of fallback tables must be preceded by a dictionary restore. This situation may arise in doing a specific-AMP restore of a no fallback table after CREATE/ DROP INDEX, a Fast Load, or an MLoad.

Remedy:

To restore a fallback table to AMP clusters, you must first perform a dictionary restore of the table from a dictionary dump. If the problem is CREATE/DROP INDEX, perform an all-AMPs restore followed by a specific-AMPs restore of the no fallback table. Then do the CREATE/DROP INDEX. If the problem is Fast Load or MLoad, the operation must finish prior to issuing the recovery operation, or all-AMPs must be restored first.