Infodb Command Output – Checkpoint History for Journal Section
The following is sample output from the checkpoint history for journal section:
----Checkpoint History for Journal--------------------------------------
Date Ckp_sequence First_jnl Last_jnl valid mode
--------------------------------------------------------------------
11-NOV-2015 13:23:43.57 1 1 1 1 OFFLINE
11-NOV-2015 13:24:50.40 2 2 2 1 ONLINE
11-NOV-2015 13:58:52.65 3 3 3 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_jnl
Indicates the journal sequence number of the first (or oldest) journal file corresponding to the checkpoint.
Last_jnl
Indicates the journal sequence number of the last (or youngest) journal 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. Also indicates TABLE if the checkpoint was a table checkpoint.
To recover the entire database, you must specify #c2, for example, in the rollforwarddb command to roll forward from the database checkpoint. Checkpoint 3 was taken on selected tables.