Displaying Storage Checkpoints Using sfrac_ckptdisplay
You can use the VERITAS Storage Foundation for Oracle RAC sfrac_ckptdisplaycommand from the command line to display the Storage Checkpoints associated with a running Oracle database.
Usage Notes
- See the sfrac_ckptdisplay(1M) manual page for more information.
- The default ordering for sorting Storage Checkpoint names is "-r" (most to least recent). By setting this variable to another sort option, the Status field identifies if the Storage Checkpoint is partial (P), complete (C), invalid (I), mounted (M), read-only (R), writable (W), or of type online (ON), offline (OFF), instant (IN), or unknown (UN).
To display VxDBA Storage Checkpoints without updating the VxDBA repository
Use the sfrac_ckptdisplay command as in the following example:
$ /opt/VRTS/bin/sfrac_ckptdisplay -S DB12 \ -H $ORACLE_HOME -o dbed -n
Checkpoint_971672042 Sun Oct 15 13:55:53 2000 C+R+IN
Checkpoint_903937870 Fri Oct 13 22:51:10 2000 C+R+ON
Checkpoint_901426272 Wed Oct 11 16:17:52 2000 P+R+ON
To display VxDBA Storage Checkpoints
Use the sfrac_ckptdisplay command as in the following example:
$ /opt/VRTS/bin/sfrac_ckptdisplay -S DB12 \ -H $ORACLE_HOME -o dbed
Checkpoint_971672042 Sun Oct 15 13:55:53 2000 C+R+IN
Checkpoint_903937870 Fri Oct 13 22:51:10 2000 C+R+ON
Checkpoint_901426272 Wed Oct 11 16:17:52 2000 P+R+ON
|