RE: Oracle Applications Development Database Refresh

Hi all,

Looks like we have a fair bunch of Oracle Apps DBAs on this list! The issues of cloning for 10.7 (various flavors), 11 and 11i are quiet different from each other. This is mostly because the underlying technical architecture has changed between each of these versions. Have a look at the following link for a collection of the most comprehensive papers on this subject.

http://www.dbatoolbox.com/Content/cloning_wp.htm

11i cloning can be done 'officially' using the adclone utility, but this is cumbersome. Unofficially, there are a variety of methods that are addressed in these links.

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: April Wells [mailto:awells_at_csedge.com]
> Sent: Tuesday, July 09, 2002 6:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Applications Development Database Refresh
>
>
> Be careful who you get when you open the tar... there is one
> chick in Denver
> who INSISTS on repeatedly reading you the whitepaper over the
> phone, and
> INSISTS that bad things CAN'T happen in a clone (they can...
> I have had two
> failed clones... one I believed them and manually fixed every
> file and it
> took a month to get it repaired... the other I did not believe them,
> restored and fixed it in two days). There is a white paper
> on Metalink that
> will walk you through it.. but make sure you have a good
> backup before you
> start. It is very straight forward and very step by step,
> but it can still
> fail. You do not have to do a fresh install before each
> clone, don't let
> anyone tell you different. You have to do ONE install on the
> target system.
> The procedure for 11i is (from what I understand) much easier
> than for 10.7.
>
> April Wells
> Oracle DBA (Oracle OCP 8, 8i)
> Corporate Systems
> Amarillo Texas
>
> -----Original Message-----
> Sent: Tuesday, July 09, 2002 7:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> You will want to open a TAR on this. There is a lengthly
> procedure document
> that Oracle will provide for doing an Apps Clone on 11i.
> There are issues
> with just duplicating the executables and database. I got
> out of Apps on
> 10.7, but remember that a doc was being written by Oracle as
> of the 2001
> Open World for 11i.
>
> HtH,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
>
>
>
> -----Original Message-----
> Sent: Monday, July 08, 2002 11:43 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If anyone has refreshed the Dev database from the Production
> database Oracle
> HRMS 11/11I successful, please tell me how to do it ? Thanks.
>
> Regds,
> New Bee
> -----Original Message-----
> From: Scott.Shafer_at_dcpds.cpms.osd.mil
> [mailto:Scott.Shafer_at_dcpds.cpms.osd.mil]
> Sent: Tuesday, July 09, 2002 6:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Applications
> Development Database
> Refresh
>
> My apps person tells me that they just restore
> the db and
> the applmgr stuff
> works fine with 10.7. Its sloppier than restoring the
> appl_top as well, but
> works. 11/11i being an entirely different animal.
>
> Scott Shafer
> San Antonio, TX
> 210-581-6217
>
>
> > -----Original Message-----
> > From: Jared.Still_at_radisys.com
> [SMTP:Jared.Still_at_radisys.com]
> > Sent: Monday, July 08, 2002 5:06 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Oracle Applications
> Development Database
> Refresh
> >
> > Thanks Scott, but the applmgr stuff is where
> the details
> are.
> >
> >
> >
> >
> >
> >
> > Scott.Shafer_at_dcpds.cpms.osd.mil
> > Sent by: root_at_fatcity.com
> > 07/08/2002 11:23 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: RE: Oracle Applications
> Development Database
> > Refresh
> >
> >
> > Jared, we do that here, but just:
> > take a cold backup of the production db,
> > lay it down over the old dev db (via scp or tape),
> > and open it renaming with a backup
> cpontrolfile script.
> >
> > Works like a charm, though I'm not sure what
> applmgr steps
> are required.
> >
> > Scott Shafer
> > San Antonio, TX
> > 210-581-6217
> >
> >
> > > -----Original Message-----
> > > From: Jared.Still_at_radisys.com
> [SMTP:Jared.Still_at_radisys.com]
> > > Sent: Friday, July 05, 2002 5:43 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Oracle Applications
> Development
> Database Refresh
> > >
> > > Fellow listers,
> > >
> > > In addition to the usual SAP system that
> runs most of
> our company, we
> > have
> > > Oracle Apps 10.7 HR. For some reason the HR folks
> didn't like the SAP
> > HR
> > > module, so I have SAP and Oracle Apps.
> > >
> > > The problem is a request I have to refresh the Dev
> database from the
> > > Production database.
> > >
> > > If you can point me to the correct documentation for
> this, I'll take a
> > > look at it.
> > >
> > > There's a lot of stuff to wade through in
> the docs and
> MetaLink, and I'd
> >
> >
> > > rather just
> > > read documentation that's actually relevant.
> > >
> > > Thanks,
> > >
> > > Jared
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Jared.Still_at_radisys.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:
> > INET: Scott.Shafer_at_dcpds.cpms.osd.mil
> >
> > 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:
> > INET: Jared.Still_at_radisys.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:
> INET: Scott.Shafer_at_dcpds.cpms.osd.mil
>
> 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: John Weatherman
> INET: john.weatherman_at_replacements.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).
>
>
> begin 666 InterScan_Disclaimer.txt
> M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!S
> M=')I8W1L>2!C;VYF:61E;G1I86P_at_86YD(&9O<B!T:&4@:6YT96YD960@=7-E
> M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL
> M>2!P<FEV:6QE9V5D(&%N9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@
> M:7,@:&5R96)Y(&=I=F5N('1H870_at_86YY(&1I<V-L;W-U<F4L('5S92!O<B!C
> M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA
> M;B!T:&4@:6YT96YD960@<F5C:7!I96YT(&ES('!R;VAI8FET960_at_86YD(&UA
> M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97-S
> M86=E(&EN(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I
> M871E;'D_at_8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O<F%T92!3>7-T96US+"!)
> M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
> M96YS=7)E('1H870_at_86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S
> M(&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL
> M:71Y(&9O<B!A;GD_at_9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S
> M;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5R
> M(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI;F<@86YY(&%T=&%C:&UE
> %;G0N#0H
> end
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: April Wells
> INET: awells_at_csedge.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: 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).