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! ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -----Original Message----- > From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] > 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:[EMAIL PROTECTED]] > 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:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).