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

See “Creating Storage Checkpoints using dbed_ckptcreate” on page 212.
See “Mounting Storage Checkpoints using dbed_ckptmount” on page 218.
In the example procedure, all the database datafiles reside on one VxFS file system
named /db01.
To back up a frozen database image using the command line
1
As an Oracle user, 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
If the specified mount point directory does not exist, then the dbed_ckptmount
command 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 roll back an entire database, a
tablespace, or a single database file. Rolling back to or restoring from any Storage
Checkpoint is generally very fast because only the changed data blocks need to
be restored.
205Using Database Storage Checkpoints and Storage Rollback
Backing up and recovering the database using Storage Checkpoints