Re: Database synchronization?

Kevin,
I clone many databases and I feel very strongly that copying the datafiles and recreating the control files is totally the fastest way to go, unless you have some fast upload reload utility, but nothing can beat the speed of copying the datafiles. I would like to say that there are some pitfalls to doing this. In v8 oracle has used a dbid or unique identifier for each database. Initially I thought that this would be no problem, but I soon came to realize that rman uses the dbid and if you have a database that is a clone (created using the copy datafiles method) rman will choke because all of your db's will have the same dbid but if you are on 7.3.3 I think ebu handled clones well.

Exp/Imp I have found to be too time consuming. Hope this helped.
--glen

Kevin Cheung wrote:
>
> Our shop is running Oracle Applications 10.7 against Enterprise Server
> 7.3.3. The installation contains some shared product installation, i.e
> Oracle Purchase and some full installation, like Order Entry and
> Inventory.
>
> There are 3 different enviroments for production, training and
> development. I was asked to synchronize data from production to other 2
> environments. Is there any good way of doing this?
>
> Approaches I think of:
>
> 1. Copy data files and then rename control file (Too clumsy since
> datafiles are really big)
> 2. Export the schemas for each installed product and then import into
> another environment (Need to truncate all the affected tables beforehand
> to avoid duplicated rows)
>
> Any commetns?

--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407 Glen.Upreti_at_NOSPAMnau.edu

Received on Fri Jul 02 1999 - 11:18:44 CDT