| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to duplicate production database onto development box
Hi New Bee,
Duplicatiing Oracle Applications has become successively complicated with every release. If you are on 11i and want to use a supported method, then use the 'adclone' method - details on MetaLink. Other unsupported methods exist out there - just search the web for 'clone 11i' and you will come across a ton of them.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
Grace - Getting something we don't deserve Mercy - NOT getting something we deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!
> -----Original Message-----
> From: CHAN Chor Ling Catherine (CSC) [mailto:clchan_at_nie.edu.sg]
> Sent: Wednesday, March 27, 2002 9:23 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to duplicate production database onto development box
>
>
> 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 (likesubscribing).
-- 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: John Kanagaraj INET: john.kanagaraj_at_hds.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).Received on Thu Mar 28 2002 - 11:43:24 CST
 |
 |