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: How to duplicate production database onto development box

RE: How to duplicate production database onto development box

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Wed, 27 Mar 2002 21:23:20 -0800
Message-ID: <F001.00435981.20020327212320@fatcity.com>


Hi Waleed,

I am not sure about other applications but for Oracle HRMS Applications, I am afraid it's so. For example, refer to metalink Note 117012.1 Viewing Reports in 11I Applications & ADI 7.0. In this article, you will realize that the machine name is hardcode in the column FND_CONCURRENT_QUEUES.target_node.

Regds,
New Bee

		-----Original Message-----
		From:	Khedr, Waleed [mailto:Waleed.Khedr_at_FMR.COM]
		Sent:	Thursday, March 28, 2002 9:53 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: How to duplicate production database
onto development box

                This will be ridiculous to hardcode this kind of information. So if my

                system crashed and I had to import a full export into a new machine, it's

                not going to work?!!

                I do not believe this could be true.

                Waleed

                 Any views or opinions presented in this email are solely those of the

                author and do not necessarily represent those of the company

		-----Original Message-----
		Sent: Wednesday, March 27, 2002 7:43 PM
		To: Multiple recipients of list ORACLE-L


		Hi,

		Does anyone know whether I could duplicate the Oracle HRMS
Applications
		using the same methods as described ? I understand that some
of the Oracle
		Applications tables hardcode the server name etc. Has anyone
done it before
		? I need to migrate my production Oracle HRMS Apps database
to a more
		powerful machine. 

		TIA

		Regds,
		New Bee

-----Original Message-----
From: Marc Cure [mailto:Marc.CURE_at_gemplus.com] Sent: Wednesday, March 27, 2002 4:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to duplicate production database onto development box Is there any need to create a standby database in this case? My procedure for copying production to development is: 1. alter database backup controlfile to trace; (in production) 2. Restore a production backup (either hot or cold) to the development server 3. Update database name and filenames in the controlfile script from step 1, as required 4. Run script from step 3 on development server to create new controlfiles 5. Recover new development database up to desired point in time using archived redo from production 6. Open the new development database with
resetlogs

                                This approach allows me to rename the database and the

		datafiles (if the
				datafiles need to be placed differently on
the development
		server than in
				production, for example) in one step, rather
than manually
		renaming 50+
				datafiles in a standby database, and then
recovering,
		activating, and
				renaming that database.

				Marc Cure
				Oracle DBA, OCP



-----Original Message-----
Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L I use a hot backup to create a standby database then apply logs to the point I want to get a copy of production of a
specific time.

                                Then you can rename the database if you want to.

-----Original Message-----

				Sent: Tuesday, March 26, 2002 9:18 AM
				To: Multiple recipients of list ORACLE-L


				Just copy the files over and recreate the
control file.
				Abraham

-----Original Message-----
Sent: Tuesday, March 26, 2002 7:48 AM To: Multiple recipients of list ORACLE-L 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Cure INET: Marc.CURE_at_gemplus.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: clchan_at_nie.edu.sg 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).
		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: Khedr, Waleed
		  INET: Waleed.Khedr_at_FMR.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

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).
Received on Wed Mar 27 2002 - 23:23:20 CST

Original text of this message

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