Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Add the new volume to the volume set:

# vxvset -g dgname addvol myvset new_vol

Add the new volume to the file system. You must specify the size of the

volume:

# fsvoladm add /mnt1 new_vol 2g

where new_vol is the name of the newly added volume and 2g is the size of

the volume:

Verify the new volume in the file system:

# fsvoladm list /mnt1

Backing up and recovering the database using Storage

Checkpoints

Storage Checkpoints can be created by specifying one of the following options:

online, offline, or instant. To create a Storage Checkpoint with the online option,

the database should be online and you must enable ARCHIVELOG mode for the

database. For the offline option, the database should be offline. For the instant

option, the database should be online and it can be running in either ARCHIVELOG

or NOARCHIVELOG mode.

During the creation of the Storage Checkpoint, the tablespaces are placed in

backup mode. Because it only takes a few seconds to take a Storage Checkpoint,

the extra redo logs generated while the tablespaces are in online-backup mode

are very small. You can roll back the entire database or individual tablespaces or

datafiles to an online or offline Storage Checkpoint. After the rollback is complete,

you may roll the database forward to recover the database if you have used an

online Storage Checkpoint.

You can only roll back the entire database to an instant Storage Checkpoint.

Rolling back individual tablespaces or datafiles to an instant Storage Checkpoint

is not possible. After the rollback is complete, you need to perform database

recovery. Rolling the database forward is not supported; that is, you cannot apply

archived redo logs.

Note: Storage Foundation for Oracle RAC configurations do not support rollbacks

using instant Storage Checkpoint.

163Using Storage Checkpoints and Storage Rollback

Backing up and recovering the database using Storage Checkpoints