Infodb Command Output – Checkpoint History for Dump Section
The following is sample output from the checkpoint history for dump section:
----Checkpoint History for Dump------------------------------------------
Date Ckp_sequence First_dmp Last_dmp valid mode
---------------------------------------------------------------------
11-NOV-2015 13:58:52.65 2 1 1 1 ONLINE
11-NOV-2015 13:58:52.65 3 1 1 1 ONLINE,
TABLE
Fields are as follows:
Date
Indicates the date and time the checkpoint operation was done.
Ckp_sequence
Indicates the sequence number of the checkpoint.
First_dmp
Indicates the dump sequence number of the first (or oldest) dump file corresponding to the checkpoint.
Last_dmp
Indicates the dump sequence number of the last (or youngest) dump file corresponding to the checkpoint.
Valid
Indicates whether the checkpoint is valid (1 implies valid, 0 implies invalid).
Mode
Indicates whether the checkpoint operation was online or offline (should always be online). Also indicates TABLE if the checkpoint was a table checkpoint.