VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Backing Up and Recovering the Database Using Storage Checkpoints Prerelease 8 September 2005, 8:55am
178 VERITAS Storage Foundation for Oracle Administrator’s Guide
Backing Up Using a Storage Checkpoint
You can back up a database by creating a Storage Checkpoint using the dbed_ckptcreate
command, mount the Storage Checkpoint as read-only using the dbed_ckptmount command,
and then back it up using tools such as tar or cpio.
Usage Notes
◆ See the dbed_ckptcreate(1M), dbed_ckptmount(1M), tar(1), and cpio(1) manual
pages for more information.
▼ To back up a frozen database image using the command line
Note In this example, all the database datafiles reside on one VxFS file system named /db01.
1. Create a Storage Checkpoint using the dbed_ckptcreate command:
$ /opt/VRTS/bin/dbed_ckptcreate -S PROD -H /oracle/product -o
online
Creating online Storage Checkpoint of database PROD.
Storage Checkpoint Checkpoint_903937870 created.
2. Mount the Storage Checkpoint using the dbed_ckptmount command:
$ /opt/VRTS/bin/dbed_ckptmount -S PROD -c \
Checkpoint_903937870 -m /tmp/ckpt_ro
Note If the specified mount point directory does not exist, then dbed_ckptmount creates it
before mounting the Storage Checkpoint, as long as the Oracle DBA user has permission to
create it.
3. Use tar to back up the Storage Checkpoint:
$ cd /tmp/ckpt_ro
$ ls
db01
$ tar cvf /tmp/PROD_db01_903937870.tar ./db01
Recovering a Database Using a Storage Checkpoint
Since Storage Checkpoints record the before images of blocks that have changed, you can use them
to do a file-system-based storage rollback to the exact time when the Storage Checkpoint was
taken. You can consider Storage Checkpoints as backups that are online, and you can use them to