Displaying Storage Checkpoints Using dbed_ckptdisplay

You can use the VERITAS Storage Foundation for Oracle dbed_ckptdisplay command to display the Storage Checkpoints associated with an Oracle database from the command line. You can also use it to display fileset quota values.

Prerequisites

• You may be logged in as either the database administrator or root.

Usage Notes

• In addition to displaying the Storage Checkpoints created by VxDBA, dbed_ckptdisplay also displays other Storage Checkpoints (for example, Storage Checkpoints created by the Capacity Planning Utility and NetBackup).
• See the dbed_ckptdisplay(1M) manual page for more information.
• 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 (OF), instant (IN), or unknown (UN).
• Database FlashSnap commands are integrated with Storage Checkpoint functionality. It is possible to display and mount Storage Checkpoints carried over with snapshot volumes to a secondary host. However limitations apply. For details, see Mounting the Snapshot Volumes and Backing Up.

  To display Storage Checkpoints created by VERITAS Storage Foundation for Oracle

Use the dbed_ckptdisplay command as follows to display information for Storage Checkpoints created by VERITAS Storage Foundation for Oracle:

  To display other Storage Checkpoints

Use the dbed_ckptdisplay command as follows:

  To display other Storage Checkpoints without updating the VxDBA repository

Use the dbed_ckptdisplay command as follows:

  To display all Storage Checkpoints

Use the dbed_ckptdisplay command as follows:

  To display all Storage Checkpoints without updating the VxDBA repository

Use the dbed_ckptdisplay command as follows:

  To display fileset quota values

Use the dbed_ckptdisplay command as follows:

Scheduling Storage Checkpoints Using dbed_ckptcreate and cron

You can use the VERITAS Storage Foundation for Oracle dbed_ckptcreate command to schedule Storage Checkpoint creation in a cron job or other administrative script.

Prerequisites

• You must be logged on as the database administrator (typically, the user ID oracle).

Usage Notes

• Create a new crontab file or edit an existing crontab file to include a Storage Checkpoint creation entry with the following space-delimited fields:

minute hour day_of_month month_of_year day_of_week \
/opt/VRTS/bin/dbed_ckptcreate

where:

• minute - numeric values from 0-59 or *
• hour - numeric values from 0-23 or *
• day_of_month - numeric values from 1-31 or *
• month_of_year - numeric values from 1-12 or *
• day_of_week - numeric values from 0-6, with 0=Sunday or *

Each of these variables can either be an asterisk (meaning all legal values) or a list of elements separated by commas. An element is either a number or two numbers separated by a hyphen (meaning an inclusive range).

• See the dbed_ckptcreate(1M), cron(1M), and crontab(1) manual pages for more information.

Scheduling Storage Checkpoint Creation in a cron Job

• To create a Storage Checkpoint twice a day, at 5:00 a.m. and 7:00 p.m., every Monday through Friday, include the following entry in your crontab file:

0 5,19 * * 1-5 /opt/VRTS/bin/dbed_ckptcreate -S PROD \
-H /oracle/product/9i -o instant
• To create a Storage Checkpoint at 11:30 p.m., on the 1st and 15th day of each month, include the following entry in your crontab file:

30 23 1,15 * * /opt/VRTS/bin/dbed_ckptcreate -S PROD \
-H /oracle/product/9i -o instant
• To create a Storage Checkpoint at 1:00 a.m. every Sunday while the database is offline, include the following entry in your crontab file:

0 1 * * 0 /opt/VRTS/bin/dbed_ckptcreate -S PROD \
-H /oracle/product/9i -o offline