Hi
There are several ways to move a database :
1 : Shutdown the db and copy all the data files, redologfiles, control file
and the parameter file to the dev box then open the db.
2 : Take a online backup of the database and then copy the control file,
data files and the archiverfiles and do a incomplete recovery
3 : user RMAN duplicate command to make a copy of the database to the dev
box
1 - 3 are fast and easy to do.
4: use transportable table spaces to move part of the database to the dev
box is a possibility that work but requires more skills.
Daiminger, Helmut wrote:
How to duplicate production database onto development box
Hi!
We want to put an exact copy of our production database
(approx. 200 GB) onto a development box. What would be the best way to achieve
this? Export/import would take kinda long... ;)
Would transportable tablespaces be the way to go?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
--
/regards
Peter Gram
Phone : +45 2527 7107
Fax : +45 4466 8856
Miracle A/S
Kratvej 2
2760 Målev
http://miracleas.dk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter Gram
INET: peter.gram@miracleas.dk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Mar 26 2002 - 08:43:27 CST
