RE: How to move 200 GB db from prod to dev?

Oh yeah,

        The dumped controfile script with give you all of the files name s too. Then just search and replace in a text editor PCLDB1 and ROLAND,,,,,

Hope it helps at all,

Hannah

> -----Original Message-----
> From: Doran, Johanna
> Sent: Thursday, June 06, 2002 11:15 AM
> To: 'ORACLE-L_at_fatcity.com'
> 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 what needs to change in the controlfile file script but db name and I believe reset logs
>
> Hannah
>
>
> -----Original Message-----
> From: root_at_fatcity.com_at_SUNGARD On Behalf Of "Daiminger, Helmut" <Helmut.Daiminger_at_KirchGruppe.de>
> Sent: Thursday, June 06, 2002 10:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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 the instance names are different:
> Production: SID=PCLDB1 => e.g. /u02/oradata/PCLDB1/system01.dbf
> Development: SID=ROLAND => e.g. /u02/oradata/ROLAND/system01.dbf
> So would export/import the entire db be the only way? (But writing out dump file that big should be a little disk space problem...)
> Renaming all the datafiles (approx. 100) would be kind of annoying...
> Any ideas?
> This is 8.1.7 on Sun Solaris.
> Thanks,
> Helmut
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: johanna.doran_at_sungard.com

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_at_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).