Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

To back up a frozen database image using the command line
1
Assuming all the database datafiles in this example reside on one VxFS file
system named /db01, create a Storage Checkpoint using the dbed_ckptcreate
command:
$ /opt/VRTS/bin/dbed_ckptcreate -S PROD -H /oracle/product \
-o online
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 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
For example:
a ./db01/PROD/users01.dbf 10256 blocks
a ./db01/PROD/undotbs01.dbf 92176 blocks
a ./db01/PROD/sysaux01.dbf 1264400 blocks
a ./db01/PROD/system01.dbf 1474576 blocks
a ./db01/PROD/control01.ctl 40672 blocks
a ./db011/PROD/control02.ctl 40672 blocks
a ./db01/PROD/control03.ctl 40672 blocks
a ./db01/PROD/redo01.log 102402 blocks
a ./db01/PROD/redo02.log 102402 blocks
a ./db01/PROD/redo03.log 102402 blocks
a ./db01/PROD/temp01.dbf 40976 blocks
Using Storage Checkpoints and Storage Rollback
Backing up and recovering the database using Storage Checkpoints
168