< Previous  | TOC | Index | Next  >

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.

See Creating Storage Checkpoints using dbed_ckptcreate

See Mounting Storage Checkpoints using dbed_ckptmount

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. 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