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
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: 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 on metalin
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
origin DB
3-) Copy all
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 - only
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 in the
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 in
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 and
11:15 AM
> 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 th