Re: Minimum Files to Clone a Database

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Wed, 12 May 2004 17:21:23 -0700
Message-ID: <4czoc.124287$Jy3.15521@fed1read03>

Mike Blocker wrote:

> Sure it is. We've done it many times before but usually we copy all the
> related database files. What I mean by snapshot is an extra mirror is added
> to the disk, all the tablespaces are placed in backup mode, the mirror is
> split or detached, then the tablespaces are taken out of backup mode. The
> detached mirror is then mounted on an alternate system. My question is
> really about the indices. Can they be rebuilt from "scratch". In other
> words, to the database it will appear as though all the disks that contain
> index files are missing.

>Can they (indexes) be rebuilt from scratch? Of course they can, but how long will that take? P.S.
You'll have to convince Oracle to get rid of the index tablespaces & then rebuild them too. Received on Wed May 12 2004 - 19:21:23 CDT