Teradata Database Message 2809 - 2809 - Analytics Database - Teradata Vantage

Message

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.