Title: How to move 200 GB db from prod to dev?
Hi!
We are supposed to clone our production database onto a new development box (both boxes are Sun Solaris). The db is about 200 GB in size.
What would be the best way to achieve this? Simply copying over the files won't work, since
To: '[EMAIL PROTECTED]'
Subject: RE: How to move 200 GB db from prod to dev?
Dump the prod control to trace
Copy the db files over to dev
edit the dumped controlfile (you can change db name here)
replace the copied controlfile with the new eidted one and bring up dev
I forget exactly
Title: How to move 200 GB db from prod to dev?
Helmut,
Why
can't you simply copy the files and then re-create new control files? This
gives you the option of renaming the database.
Not
sure what your backup procedures are, but you could always restore a backup to
the development box
Title: How to move 200 GB db from prod to dev?
Search the
Oracle-L archives- this question has been covered several times recently.
Also, Oracle
DBA Tips Techniques by Sumit Sarin (2000, Oracle Press) has detailed
instructions for cloning a database in Chapter 1. Note the error
Title: RE: How to move 200 GB db from prod to dev?
Dump the prod control to trace
Copy the db files over to dev
edit the dumped controlfile (you can change db name here)
replace the copied controlfile with the new eidted one and bring up dev
I forget exactly what needs to change
Title: How to move 200 GB db from prod to dev?
1) use
RMAN to clone the db; or
2)
create the new dev db with the required users but without all the data/index
tablespaces, and use transportable tablepsace feature to move tablespaces/data
files . . . export/import of meta-data is quick
Title: How to move 200 GB db from prod to dev?
Helmut,
I have just done it right this
morning. Not that big but worked.
Pasos para Clonar Bases de Datos
1-) Take a cold backup of the Origen DB-
Preferiblemente frio
2-) Take a backup of the controlfile of the
originDB
3-) Copy all
Title: How to move 200 GB db from prod to dev?
A few options. Do you use RMAN for backups? , if so
duplicate the database and rename the files as part of that
process.
Otherwise clone the database by copying the files at
the o/s level and change the instance name. Several documents
I have a similar situation and here's how I deal with it.
(I'm assuming your datafiles have the same name but the pathname is
different)
Production: SID = PROD = e.g.
/zbackup/array3/oracle8/dbs73/PROD/wds01.data.dbf
Development: SID = WDSU = e.g. /extdisk/oracle8/dbs73/PROD/wds01.data.dbf
Title: RE: How to move 200 GB db from prod to dev?
Helmut,
This works perfectly for cloning a DB where the instance names are different,
but the directory structure is exactly the same, which looks to be the case from
your original post for the /u02 file system. We do this in order to clone
10 matches
Mail list logo
