RE: what is the main purpose of cloning a database.

I've also used db cloning to get a copy of the data at a previous point in time (when flashback is not available, of course).

hth

Guillermo Alan Bort
DBA / DBA Main Team

EDS, an HP company

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dave Sent: Wednesday, December 17, 2008 3:44 PM To: oracledba.williams_at_gmail.com
Cc: JEREMY.SHEEHAN_at_fpl.com; dofreeman_at_state.pa.us; ORACLE-L Subject: Re: what is the main purpose of cloning a database.

Like others have mentioned, cloning provides you with the ability to take a copy of a production environment and use it for development, testing patches and configuration changes before you make them into production, etc.

There are a couple of ways to clone a database but the easiest is to use RMANs duplicate feature. Its very easy to automate a clone and I even have some databases which are refreshed nightly with a copy of production.

On 12/17/08, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
> Nilesh
>
> 1. Some databases are so large that cloning is the only method of
creating a
> test database.
> 2. Before a production change is made, it is recommended that change
be made
> in a test database and then tested. This can avoid the awkward
situation of
> production changes that need to be backed out. Cloning produces an
exact
> copy of the production database.
>
> Dennis Williams
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l