Veritas Storage Foundation™ 5.0.1 for Oracle RAC Installation, Configuration, and Administrator's Guide Extracts for the HP Serviceguard Storage Management Suite on HP-UX 11i v3
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:
Table 4-7 Scheduling Storage Checkpoints Notes
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
• 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/10g -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/10g -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/10g -o offline
Mounting Storage Checkpoints Using dbed_ckptmount
You can use the dbed_ckptmount command to mount a Storage Checkpoint for the database
from the command line.
Before mounting Storage Checkpoints, the following conditions must be met:
Examples of Using the Command Line Interface 43