VERITAS Storage Foundation 4.1 for Oracle RAC HP Serviceguard Storage Management Suite Extracts, December 2005
Backing Up and Recovering the Database Using Storage Checkpoints
combination of data redundancy (disk mirroring) and Storage Checkpoints is
recommended for highly critical data to protect them from both physical media failure
and logical errors.
Backing Up Using the Command Line
You can back up a database by creating a Storage Checkpoint using the
sfrac_ckptcreate command, mounting the Storage Checkpoint as read-only using the
sfrac_ckptmount command, and then backing it up using tools such as tar or cpio.
Usage Notes
◆ See the sfrac_ckptcreate(1M), sfrac_ckptmount(1M), tar(1), and cpio(1)
manual pages for more information.
◆ Also refer to the examples, “Creating Storage Checkpoints Using sfrac_ckptcreate”
on page 144 and “Mounting Storage Checkpoints Using sfrac_ckptmount” on
page 148.
▼ 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 sfrac_ckptcreate command:
$ /opt/VRTS/bin/sfrac_ckptcreate -S DB12 -H $ORACLE_HOME \-o
online
NOTICE: Creating online Storage Checkpoint of database DB12.
Storage Checkpoint Checkpoint_1068762379 created.
2. Mount the Storage Checkpoint using the sfrac_ckptmount command:
$ /opt/VRTS/bin/sfrac_ckptmount-S DB12 -c \
Checkpoint_1068762379 -m /ckptmnt
3. Use tar to back up the Storage Checkpoint:
$ cd /ckptmnt
$ ls
db01
$ tar cvf /tmp/DB12_db1_1068762379.tar ./db01
136 VERITAS Storage Foundation for Oracle RAC Installation and Configuration Guide