Displaying Storage Checkpoints using dbed


		< Previous \| TOC \| Index \| Next >

You can use the 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.

Before displaying Storage Checkpoints, the following conditions must be met:

Prerequisites

Usage Notes

In addition to displaying the Storage Checkpoints created by SF Oracle RAC, dbed_ckptdisplay also displays other Storage Checkpoints (for example, Storage Checkpoints created by the Capacity Planning Utility and NetBackup).
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.
See Mounting the snapshot volumes and backing up
See the dbed_ckptdisplay(1M) manual page for more information.

To display Storage Checkpoints created by Veritas Storage Foundation for Oracle

To display other Storage Checkpoints

To display other Storage Checkpoints without updating the repository

To display all Storage Checkpoints

To display all Storage Checkpoints without updating the repository

To display fileset quota values

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

Before scheduling Storage Checkpoints, the following conditions must be met:

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.

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