Sybase Database in a SAN Environment Using EVA Snapclone Technology (August 2007)

Executive Summary

EVA Snapclone is a feature that enables you to create copies of the existing data on EVA

disk arrays. Using this feature, you can create a copy of original data, which can be

restored whenever required. A Snapclone is an independent, point-in-time copy of a virtual

disk. It is independent because the data from the source virtual disk is copied to the

Snapclone. Snapclones are used to create independent and durable copies of data for

various purposes, such as:

• Data mining

• Data warehousing

• Preproduction testing

This document describes how to clone an Oracle9i/DB2/Sybase database in a SAN

environment using the EVA Snapclone feature.

Database administrators and developers clone databases for the following purposes:

• Updating test or development environments from a production environment

• Switching the production database to the clone in case of an emergency

This document addresses the following topics:

• Creating an Oracle9i production database and its components on EVA Storage

LUNs.

• Performing full and partial cloning of the production database in SAN environments

using the EVA Snapclone feature, Oracle User-Managed, and RMAN recovery

techniques.

• Validating the cloned database.

• Cloning the DB2 database using the EVA Snapclone technology.

• Cloning the Sybase database using the EVA Snapclone technology.

Introduction

A clone is an exact copy of the original. Cloning a database refers to the database

administrative task of updating test and development environments from the production

environment. It usually involves tasks, such as backup and recovery processes, which are

tedious and time consuming. A cloned database can run as an independent instance in a

new environment. It can exist either on the same host as the production database, or on a

different host.