Starting a Snapshot of a Database

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 10 Apr 2003 23:11:45 +0200
Message-ID: <m2399vo43mvja2pnb5jnnl4v3pi2u9ogc2@4ax.com>

I am planing to "clone" a database residing on a disk array via the snapshot function (a snapshot is just a virtual copy of a LUN, where only changed blocks are physically written in a new smaller LUN).

We use Oracle 8.1.7 and a EMC CX-400 (Clarion) and a Sun E3500/Solaris 2.7.

My question is, since it is a good practice to keep active copies of the control file and of redolog files on *different* devices, they are not all residing on the LUN that is to be copied with the snapshot. That means that the new "cloned" Database won't start because some files are missing.

Has anyone here some experience making snapshots of databases? These snapshots can be used to either make a subsequent backup or to setup a virtually "clone" database as explained. Shouldn't the database be put in backup mode to guarantee that the copy will be consistent? How can the cloned DB be recovered at first startup?

If some one here had a template script to do this things, that would be great!

Bye
Rick Denoire Received on Thu Apr 10 2003 - 16:11:45 CDT