Re: Q:Copy production database to Q/A or test environment
- From: Jared Still <jkstill@xxxxxxxxx>
- To: AmihayG@xxxxxxxxx
- Date: Mon, 18 Apr 2005 09:51:19 -0700
A full export of 3TB?
Using a full export of a large database via export is usually
reserved for moving between unlike platforms, and requires
multiple parallel exports.
Doing so in a simple manner is probably not feasible due
to time constraints. (ie. export/import is slow)
Moving datafiles is probably better, it's a much simpler process.
Moving via RMAN files to disk may be better yet, though
it may be somewhat more complex.
You mention minimal DBA support. Doing something like this
with minimal support will require a rather robust set of scripts
or application.
Doing so without DBA support doesn't seem feasible.
Jared
On 4/18/05, Amihay Gonen <AmihayG@xxxxxxxxx> wrote:
>
> Hi ,
>
>
> 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
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
