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

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