Was this helpful?
Checkpoint and Roll Forward of Tables
Whenever a database is rolled forward (restored), we recommend that a new checkpoint be taken to allow subsequent table-level roll forward activities.
When a roll forward is performed at the table level, you can choose either to roll forward the table excluding or including all secondary indexes. You cannot specify a secondary index name as a table.
If it is necessary to do a roll forward with the No Secondary Index option, the base table’s secondary index in the RDF cache become inconsistent. To clear the inconsistency, do one of the following:
Drop or recreate the inconsistent secondary index
Restart Ingres to refresh the RDF cache
If additional assistance is required, call Actian Support.
Last modified date: 11/28/2023