RE: Copy production database to Q/A or test environment

Hi,
If you have the right infrastructure, I would go with rman. It requires = DBA time to set it up, but once its there you can use it to duplicate = databases. Of course it sounds like you will need a decent network link.

Regards

Pete

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Amihay Gonen Sent: 18 April 2005 12:06
To: Oracle-L_at_freelists.org
Subject: Q:Copy production database to Q/A or test environment

Hi ,=20
=20

I've a requirement to develop a process to copy production database (3Tb = and
above) at customer site to QA or test environment (Vendor side).
=20

The requirements are :
* Database structures - This include tables,indexes , code (package,trigger ...) , views ...(select count(*) from DBA_objects =3D = 150,000
)
* Data of main configurations tables. (total size of all tables is less then 200M).

=20
=20

This copy is done in order to investigate problem in customer sites and = to
verify that patches which will be release , will run well.
=20

I'm thinking on two ways to developer such process :

1. Full exp without data + A list of tables to export with data. Zipped those files , transfer them to vendor site , import those files into a = clean database.
2. Take a hot backup of system and undo tablespaces and the configurations tablespace (let's assume that all the configurations = tables are in the same tablespace).Zipped those files , transfer them to vendor site , create a new instance , recover and open the database

=20

What do you think it , it's the best way to go ? Please note that this process should be done with minimal DBA resource in the process. (DBA is = a
rare resource :) )
=20

Amihay Gonen
DBA,
972-3-9268280=20

Be there ... -> http://golan/Forum%20DBA/default.aspx <http://golan/Forum%20DBA/default.aspx>=20

=20

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