where:
- (dbname)
- Name of the database to be rolled forward.
- ALL
- Rolls forward the named database and its descendants.
- (dbname.tablename)
- Name of the table to be rolled forward.
- EXCLUDE
- Prevents the named database from recovery.
- (dbname)
- Name of the database excluded from recovery.
- ALL
- Excludes from recovery the named database and its descendants.
- (dbname1) TO (dbname2)
- Alphabetical list of client databases to be excluded from recovery.
- chkptname
- or
- chkptname, eventno
- or
- eventno
- Specifies the termination point for the rollforward operation.
- PRIMARY DATA
- Applies primary and fallback row images during the rollforward process.
- RELEASE LOCK
- Releases utility (HUT) locks on the named databases automatically when rollforward completes.
- NO DELETE
- or
- DELETE
- Deletes, or refrains from deleting, the restored journal subtable after the rollforward is complete.
- ABORT
- Aborts the roll operation if an AMP to which a non-fallback archive to be recovered is offline.
- CURRENT or RESTORED
- Uses the current journal or a subtable that was previously restored to the Teradata Database.