VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Using VxDBA to Perform Administrative Operations Prerelease 8 September 2005, 8:55am
348 VERITAS Storage Foundation for Oracle Administrator’s Guide
Mount Storage Checkpoints. Use this menu option to mount a Storage Checkpoint into the file
system namespace. Mounted Storage Checkpoints appear as any other file system on the machine,
and you can access mounted Storage Checkpoints using all normal file system-based commands.
Unmount Storage Checkpoints. Use this menu option to unmount a mounted Storage Checkpoint.
Remove Storage Checkpoints. Use this menu option to remove Storage Checkpoints that you no
longer need.
Creating Storage Checkpoints
This operation creates a Storage Checkpoint (point-in-time image) of the database instance. A
Storage Checkpoint for a database is a collection of Storage Checkpoints created at the same time
on each of the file systems where the database files reside.
It is recommended that you take a Storage Checkpoint after you convert to or from Quick I/O files.
Note Enable ARCHIVELOG mode before taking Storage Checkpoints. See “Creating Storage
Checkpoints” on page 349 and “Using Storage Checkpoints and Storage Rollback” on
page 162.
The database can be offline or online when a Storage Checkpoint is created. If the database is
online when the Storage Checkpoint is created, VxDBA switches the database to online backup
mode before creating the Storage Checkpoint. Once the Storage Checkpoint is created, VxDBA
switches the database back to its normal operation mode.
In addition to creating a Storage Checkpoint, VxDBA also automatically backs up the associated
control files, initialization file, and log information. Suppose that you made a structural change to
your database, and then needed to roll back the database to a Storage Checkpoint that was created
before the structural change. The Storage Rollback would only be successful if you could also
reconstruct the database to the same structure that it was when the Storage Checkpoint was created.
You can recreate the previous database structure using the control files, initialization file, and log
information that were backed up when the Storage Checkpoint was created.
Note VxDBA does not automatically roll back the control file associated with a Storage
Checkpoint. See “Rolling Back the Database to a Storage Checkpoint” on page 360 for more
information on rolling back control files and “Guidelines for Oracle Recovery” on page 181
for information on Oracle recovery.