Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Using FlashSnap for Backup and Recovery

Preparing Hosts and Storage for Database FlashSnap

Chapter 5

Figure 5-2 Example of an Off-host Database FlashSnap Solution

Host and Storage Requirements

Before using Database FlashSnap, ensure that:

• All files are on VxFS file systems over VxVM volumes. Raw devices are not

supported.

• Symbolic links to datafiles are not supported.

• ORACLE_HOME is on a separate file system.

• Archive logs are on a separate VxFS file system and are on a different VxFS file

system than Oracle datafiles or ORACLE_HOME.

• The database does not contain BFILES and external tables.

• Oracle datafiles, archive logs, redo logs, and control files are in a single disk group.

In addition, before attempting to use Database FlashSnap with two hosts, ensure that:

• The versions of HP Serviceguard for Oracle RAC on the primary and secondary hosts

are the same.

• The same version of Oracle is installed on both hosts

• The Oracle binaries and datafiles are on different volumes and disks.

• The UNIX login for the database user and group must be the same on both hosts.

• You have a HP Serviceguard for Oracle RAC license on both hosts.

Creating a Snapshot Mirror of a Volume or Volume Set Used by

the Database

With Database FlashSnap, you can mirror the volumes used by the database to a

separate set of disks, and those mirrors can be used to create a snapshot of the database.

These snapshot volumes can be split and placed in a separate disk group. This snapshot

disk group can be imported on a separate host, which shares the same storage with the

primary host. The snapshot volumes can be resynchronized periodically with the

primary volumes to get recent changes of the datafiles. If the primary datafiles become

Network

Disks containing primary

volumes used to hold production

databases

Disks containing snapshot

volumes

SCSI or Fibre Channel

Connectivity

Secondary HostPrima ry Host