Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Q:Copy production database to Q/A or test environment

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

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 18 Apr 2005 09:51:19 -0700
Message-ID: <bf463805041809512be88e@mail.gmail.com>


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_at_ectel.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 18 2005 - 12:55:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US