Re: Cloning an Oracle 8.1.7 DB

From: Gary Streeter <gstreeter_at_NOUCE.id-bs.com>
Date: Thu, 24 Oct 2002 12:29:57 +0100
Message-ID: <iQQt9.6373$Af5.229521@newsfep2-win.server.ntli.net>

You should check out the Oracle documentation on the "RMAN" backup and recovery tool. This can create a full copy of a database for you which you can then update from the original whenever required.

Gary

"Ed" <sid.james_at_virgin.net> wrote in message news:3DB71033.2ED8_at_virgin.net...
> Hi.
>
> Does anyone know how to automate the cloning of an Oracle database on
> Solaris?
> At the moment we can do this manually by altering the control file to
> trace, copying and then renaming the datafiles but then there is manual
> stuff to do, like altering the crdb<INSTANCE_NAME>.sql file (sorry this
> is from memory).
>
> Anyone got a script they'd like to share?
>
> Cheers.
>
> Ed.
Received on Thu Oct 24 2002 - 06:29:57 CDT