Scheduling Storage Checkpoints Using sfrac_ckptcreate and cron

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

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/sfrac_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 sfrac_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/sfrac_ckptcreate -S DB12 \
-H $ORACLE_HOME -o online
• 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/sfrac_ckptcreate -S DB12 \
-H $ORACLE_HOME -o online
• To create a Storage Checkpoint at 1:00 a.m. every Sunday, with a prefix name of cronckpt_, and while the database is offline, include the following entry in your crontab file:

0 1 * * 0 /opt/VRTS/bin/sfrac_ckptcreate -S DB12 \
-H $ORACLE_HOME -o offline