Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

Scheduling Storage Checkpoints using dbed_ckptcreate and
cron
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:
■ You must be logged on as the database administrator (typically,
the user ID oracle).
Prerequisites
■ 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.
Usage notes
Scheduling Storage Checkpoint creation in a cron job
Depending on when you want to schedule Storage Checkpoint creation, make
entries to the crontab file.
■ 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/ORA_HOME -o instant
Note: Instant Storage Checkpoints are not supported for Oracle RAC.
■ 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:
217Using Database Storage Checkpoints and Storage Rollback
Database Storage Checkpoint Commands