Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Using Storage Checkpoints and Storage Rollback

Examples of Using the Command Line Interface

Chapter 4

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:

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.

Table 4-7 Scheduling Storage Checkpoints Notes (Continued)

Table 4-8 Mounting Storage Checkpoints Notes

Prerequisites You may be logged in as either the database administrator or

superuser.