Re: Clone questions

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 08 Jul 2005 06:59:30 -0700
Message-ID: <1120831178.534836@yasure>

Andreas Mosmann wrote:
> DA Morgan schrieb am 08.07.2005 in <1120811823.663524_at_yasure>:
>

>> Assuming 9i or 10g my recommendation wold be to create a new database
>> from scratch. Then use transportable tablespaces to move the data.

>
>

>> To really help you we need to know:
>> 1. Oracle version and edition
>> 2. Number of tablespaces
>> 3. Size of data files
>> 4. Number of schemas
>> 5. Other similar metrics

>
>
> If I understand it correct there is no simple/schematic way (or tool) to
> clone a database and to install the copy (with same behavior regarding
> interface to existing programs) on a second system, f.i. for application
> debugging etc.?
>
> Andreas

Depending on you definition of "simple": No.

But consider this. Suppose you take a cold backup and your server burns itself to the ground two seconds later. What would you do? Hopefully you know how to quickly reconstitute your production db. I just happen to find transportable tablespaces among the easiest and cleanest ways to move things around.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Jul 08 2005 - 08:59:30 CDT